CreateUniqueList

Create list of unique items from a column into another column
This is similar to Column2AnString_Unique except this one is faster, generates the list into another column, and uses "Remove Duplicates" feature in Excel.

Edit 2024-11-22: Fixing issue with ActiveWorksheet found in all functions with optional workbook and worksheet names

CodeFunctionName What is this?

Public

Tested

Original Work

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

From_ColumnName, Optional From_RowNum = 1, Optional From_SheetName = "Active", Optional From_WB = "This", _
    Optional To_ColumnName = "SameAsFrom", Optional To_SheetName = "Active", Optional To_WB = "This"

Views 310

Downloads 99

CodeID
DB ID