| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
ranking by mutliple categories
i have a list of scores with mutliple groups that i am trying to rank within
each group. the RANK function only lets you rank by one range and not by the group within the range. I am sure i can figure out a macro to accomplish it, but i would prefer a formula. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
ranking by mutliple categories
Assuming that A2:A10 contains the group, and B2:B10 contains the score,
try... C2, copied down: =SUMPRODUCT(--($A$2:$A$10=A2),--(B2<$B$2:$B$10))+1 Hope this helps! In article , dbr wrote: i have a list of scores with mutliple groups that i am trying to rank within each group. the RANK function only lets you rank by one range and not by the group within the range. I am sure i can figure out a macro to accomplish it, but i would prefer a formula. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
ranking by mutliple categories
This worked perfectly, thanks so much.
"dbr" wrote: i have a list of scores with mutliple groups that i am trying to rank within each group. the RANK function only lets you rank by one range and not by the group within the range. I am sure i can figure out a macro to accomplish it, but i would prefer a formula. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ranking problem | Excel Worksheet Functions | |||
| Switching Subcategories into Categories and Vice Versa | Excel Worksheet Functions | |||
| Multiple charts in ChartSpace; problems with double Categories | Charts and Charting in Excel | |||
| Multiple charts in ChartSpace; problems with double Categories | Charts and Charting in Excel | |||
| Multiple charts in ChartSpace; problems with double Categories | Charts and Charting in Excel | |||
Linear Mode
