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

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

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

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



.

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



.

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



.



.