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 Boldcodes.com
Linkedin Login
RData, Optional DupCols = "A|B|C", Optional Sepa = "|", Optional HaveHeaders = xlYes, Optional Shee = "Active", Optional WB = "This"
Views 202
Downloads 72
CodeID
DB ID
