Find unique rows in Excel

I was faced with a problem yesterday where I had a long list of postcodes to load into a shopping cart via the database.

I soon realised that the list I received had many many duplicates in it. So I began the usual sort by postcode and manually deleting duplicates. There had to be a better way, and yet again, Excel delivers so many amazing tools (I probably know only 10% of what it has to offer).

Here is how to only find unique rows in your excel spreadsheet:

  • Load your data into Excel
  • Go to the "Data" menu and click "Filter".
  • Click "Advanced" next to Filter.
  • In the "Advanced" dialog, tick "Unique records only".
  • Click OK and you are done.

You will now have a spreadsheet with unique rows of data. Such a time saver for these tedious tasks.

Hope you find this helpful one day!