| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
include criteria to 'rank based array function'
Hi, Everybody.I got a robust formula from Mr.Biff and Mr.Bob against my post
"rank based array function'. Can any body make it more robust by adding one more criteria i.e 'Job' wise(B2:B10).In precise, I am looking for a w/sheet function that returns Top 3 gainers( salary increase percetage wise) by job wise,that means Top 3 managers,Top 3 clerks etc....who gained/lost most. Since Mr.Biff used Sumproduct function with unary I presume one more criteria can be added as an array to sumproduct function. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| RANK Function - Zero Value Ranked as 1 - Should be 10 | Excel Worksheet Functions | |||
| sum items in a column based on criteria located in other columns | Excel Discussion (Misc queries) | |||
| VBA function for "Mean" using Array as argument | Excel Worksheet Functions | |||
| Rank based on criteria | Excel Worksheet Functions | |||
| Formula to list unique values | Excel Worksheet Functions | |||
Threaded Mode
