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 "?" |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
look for subtotal
1233 06/02/09 400.00 ?
What should the result be for that? -- Biff Microsoft Excel MVP "Bklynhyc" wrote in message ... 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 "?" |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
look for subtotal
I think this is what you want:
http://blogs.techrepublic.com.com/msoffice/?p=416 You may want to consider using a Pivot Table too (or as an alternative): http://peltiertech.com/Excel/Pivots/pivottables.htm http://www.babeled.com/2008/07/18/ex...-manipulation/ HTH, Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Bklynhyc" wrote: 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 "?" |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
look for subtotal
Hi,
it the first list that i want to number the subs abcd merchant date amt ref. 1234 06/01/09 500.00 1 total 500.00 1 1233 06/02/09 100.00 2 1233 06/02/09 100.00 2 1233 06/02/09 100.00 2 1233 06/02/09 100.00 2 total 400.00 2 second list w/o reference abcd merchant date amt ref. 1234 06/01/09 500.00 1 1233 06/02/09 400.00 2 Many thanks "T. Valko" wrote: 1233 06/02/09 400.00 ? What should the result be for that? -- Biff Microsoft Excel MVP "Bklynhyc" wrote in message ... 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 "?" . |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
look for subtotal
Sorry, I don't understand.
-- Biff Microsoft Excel MVP "Bklynhyc" wrote in message ... Hi, it the first list that i want to number the subs abcd merchant date amt ref. 1234 06/01/09 500.00 1 total 500.00 1 1233 06/02/09 100.00 2 1233 06/02/09 100.00 2 1233 06/02/09 100.00 2 1233 06/02/09 100.00 2 total 400.00 2 second list w/o reference abcd merchant date amt ref. 1234 06/01/09 500.00 1 1233 06/02/09 400.00 2 Many thanks "T. Valko" wrote: 1233 06/02/09 400.00 ? What should the result be for that? -- Biff Microsoft Excel MVP "Bklynhyc" wrote in message ... 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 "?" . |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
look for subtotal
Hi,
Thanks for replying. I would like to fill in the "ref." column on the first list by linking the second lists ref. My problem is that the subtotals on the first doesn't match the second list just the total. is there any way to link both the total and subtotal on the first list? Please see below. first list w/o ref. abcd merchant date amt ref. 1234 06/01/09 500.00 ? total 500.00 ? 1233 06/02/09 100.00 ? 1233 06/02/09 100.00 ? 1233 06/02/09 100.00 ? 1233 06/02/09 100.00 ? total 400.00 ? second list with reference abcd merchant date amt ref. 1234 06/01/09 500.00 1 1233 06/02/09 400.00 2 result abcd merchant date amt ref. 1234 06/01/09 500.00 1 total 500.00 1 1233 06/02/09 100.00 2 1233 06/02/09 100.00 2 1233 06/02/09 100.00 2 1233 06/02/09 100.00 2 total 400.00 2 abcd merchant date amt ref. 1234 06/01/09 500.00 1 1233 06/02/09 400.00 2 Once again Many Thanks "T. Valko" wrote: Sorry, I don't understand. -- Biff Microsoft Excel MVP "Bklynhyc" wrote in message ... Hi, it the first list that i want to number the subs abcd merchant date amt ref. 1234 06/01/09 500.00 1 total 500.00 1 1233 06/02/09 100.00 2 1233 06/02/09 100.00 2 1233 06/02/09 100.00 2 1233 06/02/09 100.00 2 total 400.00 2 second list w/o reference abcd merchant date amt ref. 1234 06/01/09 500.00 1 1233 06/02/09 400.00 2 Many thanks "T. Valko" wrote: 1233 06/02/09 400.00 ? What should the result be for that? -- Biff Microsoft Excel MVP "Bklynhyc" wrote in message ... 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 "?" . . |
Reply |
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 |