Forum Discussion
How to remove data automatically "After Filter the Data"
Filter for unique values or remove duplicate values
In Excel for the web, you can remove duplicate values.
Remove duplicate values
When you remove duplicate values, the only effect is on the values in the range of cells or table.
Other values outside the range of cells or table will not change or move.
When duplicates are removed, the first occurrence of the value in the list is kept, but other identical values are deleted.
Important: You can always click Undo to get back your data after you have removed the duplicates. That being said, it's a good idea to copy the original range of cells or table to another worksheet or workbook before removing duplicate values.
Follow these steps: go to the upper link for more information.
Hope I could help you with this information / link.