Sir/Madam, I ll provide you a VBA macro which will loop through all your UPC and extract for each one all the duplicates with the required fields. It will be done in 1-2 days. So let's start. You can send me your file (if you have a specific list of UPC). Best regards, Issam