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 ...
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.
Kavi25
Apr 18, 2020Copper Contributor
Yup thank you so much for the solution. This is what I needed. Thank u so much once again Riny_van_Eekelen