Keep single value from a list of duplicate values

Occasional Visitor

I have a whole list of Excel duplicate data which I have filtered now I have to keep one row from each duplicate row(s) how to do it

1 Reply


Try 'Remove Duplicates' on the Data tab of the ribbon.