Remove duplicates except some duplicate values

Question

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 statement i have attached the image. And also i have attached excel with raw data. Please find the both and provide me the solution for the same.

riny_van_eekelen · Answer

Kavi25&nbsp;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.&nbsp;

abiola1 · Answer

Kavi25&nbsp;
&nbsp;
If you have Office 365, you can use the UNIQUE dynamic array function to remove duplicates value as seen below

&nbsp;

kavi25 · Answer

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 · Answer

Yup thank you so much for the solution. This is what I needed. Thank u so much once again Riny_van_Eekelen

Forum Discussion

Remove duplicates except some duplicate values

4 Replies

Resources