View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
sundevl21 sundevl21 is offline
external usenet poster
 
Posts: 1
Default Top 10 filter within subgroup

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??