| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
RANK Q
i hve a Q plz get me d solutn
project 1 project 2 project 3 xpctd rate 0.3 0.3 0.3 out flow 500000 800000 450000 inflow 1. 300000 135000 219000 2. 75000 148500 320000 3. 30000 163350 79000 4. 100000 179685 50000 5. 95000 188669.25 215000 6. 225000 198102.7125 300000 NPV 79987.22902 291664.3373 754872.1383 *IN DIS Q V HVE 2RANK D BEST PROJ OUT OF 3 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| rank the numbers / range of data using 'RANK' and 'ABS' | Excel Worksheet Functions | |||
| RANK, duplicate ranking but no gaps in rank | Excel Worksheet Functions | |||
| Rank where lowest value is highest rank | Excel Worksheet Functions | |||
| Does Correl/Rank combo work eg CORREL(cols E & H) where E&H=RANK(. | Excel Worksheet Functions | |||
| Rank items, select one start date, have remaining dates follow based on rank | Excel Discussion (Misc queries) | |||
Threaded Mode
