Removes duplication in table in 1 or more columns using Excel "RemoveDuplicates" feature.
Will work in sheet, cleaning table from duplication in one or more columns.
Similar to CreateUniqueList but works in same table, does not copy into another sheet and removes based on more than 1 column.
As usual, caller can decide sheet, workbook, list of columns to consider for duplicates (with separator) and if table has header or not
Access is limited.
Login here using your Linkedin account. to see or download code.
No registration, not another password to remember, login using your Linkedin account and have access to all public codes in Bold.codes
Linkedin LoginRData, Optional DupCols = "A|B|C", Optional Sepa = "|", Optional HaveHeaders = xlYes, Optional Shee = "Active", Optional WB = "This"
Views 203
Downloads 73
CodeID
DB ID
ANmarAmdeen
701
Revisions
v1.0
Saturday
February
24
2024