Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am working on reviewing 2000 projects across the globe. I would like rank
the projects based on type & source (Internal and External) A B C D E Project Type Source Saving Rank Pr-1 S I 10 3 Pr-2 S E 11 7 Pr-3 W E 23 11 Pr-4 W E 15 12 Pr-5 S I 16 1 Pr-6 S E 18 4 Pr-7 W I 14 10 Pr-8 S I 15 2 Pr-9 W I 15 9 Pr-10 S E 12 6 Pr-11 S E 13 5 Pr-12 S E 9 8 I want to see the result in colm E by a SINGLE FORMULA. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Fine-Tune Multi-Condition Formula | Excel Worksheet Functions | |||
Help with Multi-Condition Formula | Excel Worksheet Functions | |||
Rank with condition | Excel Discussion (Misc queries) | |||
Rank items, select one start date, have remaining dates follow based on rank | Excel Discussion (Misc queries) | |||
Multi-condition vlookup | Excel Worksheet Functions |