Problem with ranking numbers
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 |
All times are GMT +1. The time now is 09:36 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com