View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bklynhyc Bklynhyc is offline
external usenet poster
 
Posts: 37
Default need to match two totals from two different list

think of the list where it has few hundred lines. the first list is in order
and the second is NOT. I what to number those on the second list according to
the first.

"ryguy7272" wrote:

This doesn't make sense; can't figure out what you want to do. I see what
you have now. What do you want to have? You posted two samples of the same
information...

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Bklynhyc" wrote:

so the first list would look like

no. date merchat no. total
1 06/01/09 1234 500.00
2 06/02/09 1234 200.00
3 06/02/09 4321 11.00

and the second would have basically the same without No. and random

date merchat no. total
06/02/09 4321 11.00
06/01/09 1234 500.00
06/02/09 1234 200.00

Thanks again

"ryguy7272" wrote:

Provide a specific example, please.
Thanks,
Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Bklynhyc" wrote:

Hi,

I have two lists of total, both content the same information.
Date, merchant no., and total.. after matching if i can assign the same
number from list 1 to list 2. how would i go about doing so?

Best regards
H