How to remove duplicates in Excel based on one column

You can watch a video tutorial here.

Excel is a spreadsheet application that lends itself easily to creating lists, tables, and databases. When combining data from multiple sources, you will frequently encounter rows that have duplicate values. To analyze the data or to prepare a summary, you may need to remove the duplicates. 

In this example, we have a list of units and expenditures. We are interested in creating a master list of Units so we have to remove the duplicates. 

Step 1 – Select the data

– Select all the data 

Step 2 – Open the Remove Duplicates box

– Go to Data > Data Tools
– Click the Remove Duplicates button

Step 3 – Define the settings

– Tick My data has headers
– Click Unselect All
– Tick ‘Unit’
– Click OK

Step 4 – Acknowledge the message

– Read the confirmation message
– Click OK

Step 5 – Check the result

– The duplicate values of the column ‘Unit’ are removed and only the unique values remain