HELLO 👋,
Remove duplicate from Excel table using formula.
First sort by column from which u want to remove duplicate.
Than create a new column at the right side of sorted column.
Than use formula kin cell a2=a3
Drag down the formula.
Filter by false.
Now all false values are unique.
Remove duplicate from Excel table using formula.
First sort by column from which u want to remove duplicate.
Than create a new column at the right side of sorted column.
Than use formula kin cell a2=a3
Drag down the formula.
Filter by false.
Now all false values are unique.
No comments:
Post a Comment