| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
To find subtotal - Please help
Hi all, I have an excel with the following format. I have to find out
subtotal of the each date column. The empty date column should be considered under the group of previous column having date. Please help Date Amount A1 B1 C1 01.01.2010 2000 Cumi.Sum -200 -300 -1500 0.00 10.01.2010 500 -300 -200 0.00 20.01.2010 700 -200 500.00 30.01.2010 400 -400 0.00 With thanks and regards Pol |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sort macro, subtotal and add lines after subtotal | Excel Discussion (Misc queries) | |||
| Trying to find easy way to copy 400K rows of data from Subtotal | New Users to Excel | |||
| pasting to subtotal lines without replacing hidden -non-subtotal l | Excel Discussion (Misc queries) | |||
| Bolding the subtotal lines automaticlly When using the Subtotal fu | New Users to Excel | |||
| Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions | |||
Threaded Mode
