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



.