Remove Duplicates in Excel - Quick & Dirty but Effective Method | Excel Hacks | Kovolff
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