Problem with ranking numbers

[Pati M]

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(L12="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.

 

[BenjieLop]

I am having trouble with ranking numbers. I am trying to rank heat time
for
7 out of 24 contestants. my rankedx numbers are going from 18 throug
24
instead of 1 through 7. How can I correct this? The formula I am usin
is as
follows:
=IF(L12="TNT",0,IF(L12="DNF",0,IF(L12="DNS",0,IF(L12="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.

Check this out

HTTP://WWW.XLDYNAMIC.COM/SOURCE/XLD.RANK.HTM

for an excellent explanation/sample of RANKING