| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to find ranking value of one column grouped on another col
For those interested:
The ranking was taking minutes because it was scanning through some 30000 records for matches. Since my groups are never larger than 15 and each group is contiguous in col A, I made the sumproduct range a relative index +/- 16 -more than twice the size of my groups and put a few (17) blank lines in at the top starting the records from row 17. The thing ranks the whole 30k records in a couple of secs. Here is the revised version. =SUMPRODUCT(--($A1:$A32=$A17),--($B17$B1:$B32))+1 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to hide and show a grouped column via VBA code? | Excel Discussion (Misc queries) | |||
| HDI: Show Value as 'Percentage of' Grouped Column in Pivot | Excel Discussion (Misc queries) | |||
| naming a grouped column | Excel Worksheet Functions | |||
| create chart from series grouped by value in another column | Charts and Charting in Excel | |||
| Column Charts - stacked and grouped | Charts and Charting in Excel | |||
Hybrid Mode
