hicksi
Board Regular
- Joined
- Mar 5, 2012
- Messages
- 203
I have a list of words. And now I'm trying to ensure that they are all unique.
If I take a copy of that list and RemoveDuplicates, then that removes duplicates, IRREGARDLESS of case.
I then place a COUNTIF against that list to find the duplicate which has a count of 2.
I then remove all count-1 entries, and do a VLOOKUP from the full list of the words with Count-2 (or more).
THAT process usually gives me a proper list that I can peruse and ensure that the 'correct' version of the word is removed (based on the perused case).
The ISSUE that arose is when the word Æterna is the duplicate.
VLOOKUP only finds Æterna, not Aeterna.
Ie, REMOVEDUPLICATES sees them as the same word, COUNTIF sees them as the same word, but VLOOKUP does not.
Is this intended, or an irregularity in the way 'case' is handled. And is there a workaround (as there's probably other instances that fail)
If I take a copy of that list and RemoveDuplicates, then that removes duplicates, IRREGARDLESS of case.
I then place a COUNTIF against that list to find the duplicate which has a count of 2.
I then remove all count-1 entries, and do a VLOOKUP from the full list of the words with Count-2 (or more).
THAT process usually gives me a proper list that I can peruse and ensure that the 'correct' version of the word is removed (based on the perused case).
The ISSUE that arose is when the word Æterna is the duplicate.
VLOOKUP only finds Æterna, not Aeterna.
Ie, REMOVEDUPLICATES sees them as the same word, COUNTIF sees them as the same word, but VLOOKUP does not.
Is this intended, or an irregularity in the way 'case' is handled. And is there a workaround (as there's probably other instances that fail)
