RANK on race times
Hi,
I have a number of times (mm:ss) which I'd like to rank by quickest first.
Having problems in that even though formatted as mm:ss, ISNUMBER (A1) gives
FALSE thus, RANK(A1,A1:A20,1) returns #N/A.
I'd also like it to ignore blank cells (currently A15:A20) as these would be
future races.
Ok, so what's the best plan he format as text or mm:ss?
--
tia
|