Finding Unique Values in Column
There is an Excel file that teaches how to perform the Finding Unique Values in Column operation.
Excel Finding Unique Values in Column
This workbook demonstrates finding unique values in column using VBA macros on a 45-row data layout.
Hope it is useful.