Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use Subtotal Function
I have several columns of data and I would like to create subtotals based on
one of the columns. That is easy enough to do, but eventually I would like to show only the subtotals (and hide the rows making up the subtotal) and then copy the subtotals to a different sheet to be compared to some other data. The problem I am having is that Excel puts the subtotal on the row beneath the data. When I hide the rows making up the subtotal, I lose a piece of information I need. Let me show you: Entity # Acct # Amount 456 1020 100.00 456 1020 350.00 456 1020 200.00 456 2100 225.00 560 1025 200.00 560 1025 100.00 When I run the subtotal function, I get Entity # Acct # Amount 456 1020 100.00 456 1020 350.00 456 1020 200.00 Subtotal 1020 650.00 456 2100 225.00 Subtotal 2100 225.00 560 1025 200.00 560 1025 100.00 Subtotal 1025 300.00 If I hide all but the subtotal rows, I lose the acct number. Does anyone know of a way to get the 456 and 560 to copy down to the cell on the same row as the subtotal so when I hide those rows, I still know what account the subtotal refers to? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUBTOTAL function | Excel Discussion (Misc queries) | |||
SubTotal Function | Excel Discussion (Misc queries) | |||
Embed a countif function in subtotal function? | Excel Worksheet Functions | |||
How do I nesting subtotal function within average function in Exc | Excel Worksheet Functions | |||
subtotal function | Excel Programming |