# look for subtotal

B

#### 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

#### T. Valko

1233 06/02/09 400.00 ?

What should the result be for that?

B

#### 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

#### T. Valko

Sorry, I don't understand.

B

#### 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