Hi, is it possible in Excel to remove the duplicated, but not all?
For example, I have the following companies in column A:
Nike
Apple
Coca Cola
Nike
Nike
Nike
Nike
Apple
So, I want the duplicates to be removed, but not all. I want 3 duplicates to stay per company.
So, there are 5 "Nike" companies and I want 2 of them randomly to be removed and 3 to stay.
Also, there are 2 "Apple" companies. In this case, I want both "Apple" companies to stay because I am removing records with above 3 duplicates.
For example, I have the following companies in column A:
Nike
Apple
Coca Cola
Nike
Nike
Nike
Nike
Apple
So, I want the duplicates to be removed, but not all. I want 3 duplicates to stay per company.
So, there are 5 "Nike" companies and I want 2 of them randomly to be removed and 3 to stay.
Also, there are 2 "Apple" companies. In this case, I want both "Apple" companies to stay because I am removing records with above 3 duplicates.