Prepare Unique List
There is an Excel file that teaches how to perform the Prepare Unique List operation.
Excel Solution: Prepare Unique List
This workbook demonstrates Prepare Unique List with VBA driven sheet behavior.
Hope it is useful.
ADVERTISEMENT AREA