This is a follow up question from How to remove duplicates that are case SENSITIVE in Excel (for 100k records or more)? .
Since his code procedure manipulates the data of column A only, I'd like to also delete the entire row of data if case-sensitive duplicate is found.
Case sensitive meaning:
- Case1
- case1
- cASE1
Are all unique records.
You can use a
Dictionary
to check for binary uniqueness and variant arrays to speed things up. To use the dictionary you will need to include a reference to Microsoft Scripting Runtime Library(Tools > References > Microsoft Scripting Runtime library)
I've tested this with 100,000 rows which takes on average 0.25 seconds on my laptop.
Based on the brilliant answer from this question