Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how can I rank within a filtered list in Excel?
I'd like to have a dynamic report that ranks my lists based on an
autofiltered list. In other words, I'd like to toggle the criteria that qualifies the lists content, and have excel generate "ranks" based on the values returned. Currently the rankings are based on the overall list, includeing the records that are filtered out. |
#2
|
|||
|
|||
Assuming that Column B contains the values to be ranked, and the first
row contains your headers/labels... C2, copied down: =SUMPRODUCT(SUBTOTAL(3,OFFSET($B$2:$B$10,ROW($B$2: $B$10)-MIN(ROW($B$2:$B$ 10)),0,1)),--(B2<$B$2:$B$10))+1 Hope this helps! In article , "Brandon" wrote: I'd like to have a dynamic report that ranks my lists based on an autofiltered list. In other words, I'd like to toggle the criteria that qualifies the lists content, and have excel generate "ranks" based on the values returned. Currently the rankings are based on the overall list, includeing the records that are filtered out. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
In Excel, how can I print a long list on 1 page in multiple colum. | Excel Discussion (Misc queries) | |||
Mailing list in Excel | Excel Discussion (Misc queries) | |||
Determine Frequency in Filtered List | Excel Worksheet Functions | |||
how can I count distinct names in an excel list? | Excel Discussion (Misc queries) | |||
How do I paste data into filtered list in Excel? | Excel Discussion (Misc queries) |