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
Edit 2024-11-22: Fixing issue with ActiveWorksheet found in all functions with optional workbook and worksheet names
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 LoginViews 205
Downloads 73
ANmarAmdeen
709