Remove Duplicates in Excel - Quick & Dirty but Effective Method | Excel Hacks | Kovolff
Channel: prelearn
Date: 2021-01-23

For those of you wishing to remove duplicate data from your columns, maybe this method can help you.

Step 1: Sort the data. Sorting order does not matter

Step 2: In the column next to the data, create a if statement similar to
if(A3=A2;”X”;””)
Assuming your data starts off at A2. With this condition you’re producing an X everywhere you have identical values.

Step 3: Turn on AutoFilters and hide all rows without an X in the column in which you had created the if statement

Step 4: Delete all rows with an X

Step 5: Switch off AutoFilters and delete the column with the if statement

Now your original columns contain unique values.

#excel #duplicates #learn #spreadsheets