I am having trouble with ranking numbers. I am trying to rank heat times for
7 out of 24 contestants. my rankedx numbers are going from 18 through 24
instead of 1 through 7. How can I correct this? The formula I am using is as
follows:
=IF(L12="TNT",0,IF(L12="DNF",0,IF(L12="DNS",0,IF(L 12="SCRATCH",0,IF(L12="DISQ",0,IF(L12="DNF/FLIP",0,IF(L12=0,0,RANK(L12,L$12:L$300,1))))))))
each row has the same formula for the correct cell.