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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top