| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
can you rank more than 7 items? how?
I can't get Excel to rank more than 7 items (I have 8). Is there a limit to
how many it can do? When the result is a rank of 8, it puts "false" in the cell and I need it to be blank. Here's my formula that works, but delivers a "False" on the 8th rank. =IF(RANK(F13,F13:M13,0)=1,"u",IF(RANK(F13,F13:M13, 0)=2,"v",IF(RANK(F13,F13:M13,0)=3,"w",IF(RANK(F13, F13:M13,0)=4," ",IF(RANK(F13,F13:M13,0)=5,"",IF(RANK(F13,F13:M13, 0)=6,"",IF(RANK(F13,F13:M13,0)=7,""""))))))) Here is my formula with the 8th rank, that comes back with an error... =IF(RANK(F13,F13:M13,0)=1,"u",IF(RANK(F13,F13:M13, 0)=2,"v",IF(RANK(F13,F13:M13,0)=3,"w",IF(RANK(F13, F13:M13,0)=4,"",IF(RANK(F13,F13:M13,0)=5,"",IF(RAN K(F13,F13:M13,0)=6,"",IF(RANK(F13,F13:M13,0)=7,"", IF(RANK(F13,F13:M13,0)=8,"")))))))) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| OLAP Pivot table - How to show items with no data ? | Excel Worksheet Functions | |||
| Pareto's Law and ABCD ranking of items | Excel Discussion (Misc queries) | |||
| Rank items, select one start date, have remaining dates follow based on rank | Excel Discussion (Misc queries) | |||
| multiple items in database | Excel Worksheet Functions | |||
| Rank fx - Fill Down? | Excel Worksheet Functions | |||
Threaded Mode
