Microsoft Excel : How to remove duplicates

Prerequisite : You will need Office 365.

Step 1 : Select Column A and Click on Data --->  Remove Duplicates

Step 2 : Select Expand the selection in the radio button and click on Remove Duplicates.

   Step 3 : Click on Un-select All 

Step 4 : Select the column that has duplicates.                                                                                            

 

 

Voila ! - It is that simple to remove duplicates.

Don't forget to comment, share and subscribe. Thank you very much.