b3ta.com qotw
You are not logged in. Login or Signup
Home » Question of the Week » Off Topic » Post 627785 | Search
This is a question Off Topic

Are you a QOTWer? Do you want to start a thread that isn't a direct answer to the current QOTW? Then this place, gentle poster, is your friend.

(I helped save b3ta! rob, Sun 1 Apr 2001, 1:00)
Pages: Latest, 837, 836, 835, 834, 833, ... 1

« Go Back | See The Full Thread

Get to it then
I suggest doing it in several different colours on a spread sheet to make it look pretty.
(I helped save b3ta! fuck shit up the best you never had, Mon 1 Feb 2010, 11:26, 1 reply, 16 years ago)
Conditional Formatting is essential in this situation.
if it doesn't contain conditional formatting I don't consider it a real spreadsheet.
(Bazongaloid, Mon 1 Feb 2010, 11:31, Reply)
^this
it must also use vlookup
(I helped save b3ta! Vipros. clever got me this far, then tricky got me in, Mon 1 Feb 2010, 11:32, Reply)
I'm a big fan of countif and sumif.

(PsychoChomp, Mon 1 Feb 2010, 11:41, Reply)
I often forget to use those
and do things in a more convoluted way.

I've been using indirect and concatenate together with vlookup recently to use a cell value as a reference for a different sheet
(I helped save b3ta! Vipros. clever got me this far, then tricky got me in, Mon 1 Feb 2010, 11:46, Reply)

« Go Back | See The Full Thread

Pages: Latest, 837, 836, 835, 834, 833, ... 1