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.

Pati M Wrote:
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.

Check this out

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

for an excellent explanation/sample of RANKING.


--
BenjieLop


------------------------------------------------------------------------
BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019
View this thread: http://www.excelforum.com/showthread...hreadid=319931