Forum Discussion
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 ...
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.
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.
- Yup thank you so much for the solution. This is what I needed. Thank u so much once again Riny_van_Eekelen