How to remove duplicate values and keep some values

Occasional Visitor

Dear Excel community, 


I am working on very big data! I need your help to remove duplicate data and wants to keep some data! How I can do I? I am attaching an excel file along with queries. Please help me. I have the office 365 version. Thanks



1 Reply


In Excel, there are several ways to filter for unique values—or remove duplicate values:

Filter for unique values or remove duplicate values


Sometimes duplicate data is useful, sometimes it just makes it harder to understand your data. Use conditional formatting to find and highlight duplicate data. That way you can review the duplicates and decide if you want to remove them.

Find and remove duplicates


I would be happy to know if I could help.



I know I don't know anything (Socrates)

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.