Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
match identical cols aquaflow Excel Discussion (Misc queries) 0 July 11th 08 04:46 PM
MATCH() and duplicate values -- is there a workaround? JimmyQ Excel Worksheet Functions 1 August 10th 06 10:33 AM
Match with 2 Lookup_Values used as search criteria. Sigmaz Excel Worksheet Functions 4 March 23rd 05 03:03 AM
Match with 2 Lookup_Values used as search criteria. Sigmaz Excel Worksheet Functions 0 March 21st 05 08:13 PM
Match with 2 Lookup_Values used as search criteria. Sigmaz Excel Worksheet Functions 0 March 21st 05 08:13 PM


All times are GMT +1. The time now is 02:17 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"