View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
chrisase chrisase is offline
external usenet poster
 
Posts: 1
Default top values within subtotals

I have a worksheet where i've used subtotals to separate out data into
subsets. within those subsets I want to indicate which rows have the highest
and second highest value in a given column. There are something like 100
groups, so doing it one subset at a time is not good. Any suggestions?