Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
match identical cols | Excel Discussion (Misc queries) | |||
MATCH() and duplicate values -- is there a workaround? | Excel Worksheet Functions | |||
Match with 2 Lookup_Values used as search criteria. | Excel Worksheet Functions | |||
Match with 2 Lookup_Values used as search criteria. | Excel Worksheet Functions | |||
Match with 2 Lookup_Values used as search criteria. | Excel Worksheet Functions |