Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
top values within subtotals
Hi chrisase;
One way might be to not use the build in subtotals and do it programatically. Sort the results so the data lines up by category then loop down the numeric column incrementing the total value for the sub set. Hold variables as you do it for varTopValue & varSecond Value and maybe their address. Then when the sub totaling rotine completes you can go back to the address and highlight the top two rows. Hope it helps, -- DownThePaint Where points are scored and games are won! "chrisase" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Subtotals of Items in A Column based on Spec. Values found in Colu | Excel Discussion (Misc queries) | |||
Subtotals problem: Excel 2003 (not, AFAIK, the nested subtotals bug) | Excel Discussion (Misc queries) | |||
How to Copy Field Values to Group Subtotals row | Excel Discussion (Misc queries) | |||
Loop that finds blanks, then subtotals values into different column | Excel Programming | |||
How to calculate percentage of values of subtotals | Excel Discussion (Misc queries) |