View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] EagleOne@discussions.microsoft.com is offline
external usenet poster
 
Posts: 391
Default Match() how to workaround identical Lookup_values

2007 (compatibility mode)

The base data is not under my control.

The concatenation string is:
myCatString = AccountNumber & EntryNumber & Amount

Believe it or not, in a ~ thousand data items, there are a few duplicates.

I realize that could sort the base data by myCatString, etc.

The challenges are that, in the contra-account I also "compute" myCatString2 which must match
myCatString1. Also, one account may have more/less data items. The point is to locate unmatched
items which become reconciliation items.

Therefore, if I add a "counter" to myCatString then I must also do it for the info in the contra
account which could be very tricky to do because the "more/less data items" issue.

Bottom line, it would be just fine if the second (un)match item ends up with the same information as
did the first matched item.

OR another thought, if I could make the first matched item "go away" the second identical item would
become matched.

Hope that I have been clear. I'll be close by to answer questions.

TIA EagleOne