Forum Discussion
Kavi25
Apr 18, 2020Copper Contributor
Remove duplicates except some duplicate values
Hi, i need help in removing duplicates (column named asset) but wherein my condition is not to remove duplicate value (column named asset) of different file no. For better understanding of my problem ...
Kavi25
Apr 18, 2020Copper Contributor
Thanx for the solution. But in this case all duplicate values got eliminated wherein i want the duplicate value to be retained if my file number changes as i have explained my problem statement in the attached image. So please help me with the same.
Riny_van_Eekelen
Apr 18, 2020Platinum Contributor
Kavi25 Perhaps the attached file holds the solution. It's quick-and dirty and can probably be automated better. But it works, supposing you are on the most recent Excel version.
- Kavi25Apr 18, 2020Copper ContributorYup thank you so much for the solution. This is what I needed. Thank u so much once again Riny_van_Eekelen