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