Do you have an excel column filled with bunch of stuff and you want to have a unique list of items in there. You are in the right place :-)
- Select the column letter, copy and paste to another location (new sheet or just somewhere else)
- Go to Data | Filter | Advanced Filter. Default, Excel will suggest filtering the list "in-place." We prefer copying the unique records to another location, so we can compare the two lists.
- Choose "Copy To Another Location", check the box for "Unique Records Only" and write B1 in the Copy To editor box.
How to generate a list of unique entries from an Excel column
- Press OK, and Hallelujah ... there you go