look for subtotal

[Bklynhyc]

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 "?"

 

[T. Valko]

1233 06/02/09 400.00 ?

What should the result be for that?

 

[ryguy7272]

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.ht
http://www.babeled.com/2008/07/18/excel-pivot-table-tutorial-wizard-usage-and-basic-manipulation/

HTH,
Ryan---

 

[Bklynhyc]

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]

Sorry, I don't understand.

 

[Bklynhyc]

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