Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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. |
#2
![]() |
|||
|
|||
![]() 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
Sorting when some numbers have a text suffix | Excel Discussion (Misc queries) | |||
Sorting imported "numbers" | Excel Discussion (Misc queries) | |||
Paste rows of numbers from Word into single Excel cell | Excel Discussion (Misc queries) | |||
finding common numbers in large lists | Excel Worksheet Functions |