I love vlookup. I might call one of my children vlookup.

( Captain Wow currently being a cunt in Infamous, Tue 16 Jun 2009, 16:37, archived)

vlookup is too slow
if you put data from a number of cells into one line using the & function you can use countif the same way but quicker and it's more useable.
(PsychoChomp, Tue 16 Jun 2009, 16:40, archived)

YEAH BUT I CAN'T USE THAT.
I'm only good at excel if I've done it before.
( Captain Wow currently being a cunt in Infamous, Tue 16 Jun 2009, 16:41, archived)

I might send you an example spreadsheet or something if I can be bothered.

(PsychoChomp, Tue 16 Jun 2009, 16:48, archived)

Phwoar, you charmer.

( Captain Wow currently being a cunt in Infamous, Tue 16 Jun 2009, 16:50, archived)