Top 10 filter within subgroup

[sundevl21]

I've been having trouble with the "Top 10" filter function once I have
already filtered one column on a certain criteria. I want the top 20 numbers
of a certain subgroup, but after I filter for the subgroup and select the top
20, it only includes 5 records because the other top 15 values in the column
aren't in the subgroup. Any suggestions??

 

[Bernie Deitrick]

SunD21,

Put a new column into your table, with a formula like

=SUBTOTAL(9,C2)

where C2 is the first cell of the column with values where you want the top twenty values. Then
copy that down to match your table.

When you filter, filter for the first criteria, then filter for the top 20 using the column of
SUBTOTAL formulas.

HTH,
Bernie
MS Excel MVP