| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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 | |||
Threaded Mode
