| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
look for subtotal
I would like to know how to go about formulate a subtotal matching formula,
I looks like this; first list with reference. abcd merchant date amt ref. 1234 06/01/09 500.00 1 1233 06/02/09 100.00 2 1233 06/02/09 100.00 3 1233 06/02/09 100.00 4 1233 06/02/09 100.00 5 second list w/o reference abcd merchant date amt ref. 1234 06/01/09 500.00 ? 1233 06/02/09 400.00 ? need to fill in the "?" |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sort macro, subtotal and add lines after subtotal | Excel Discussion (Misc queries) | |||
| 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 | |||
| copy subtotal value only, subtotal value can be vlookup by others | Excel Discussion (Misc queries) | |||
| Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions | |||
Threaded Mode
