Tuesday, March 24, 2020

How to generate a list of unique entries from an Excel column

Hi,

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 :-)

  1. Select the column letter, copy and paste to another location (new sheet or just somewhere else)
  2. 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.
  3. 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
  4. Press OK, and Hallelujah ... there you go

Result


No comments: