Hello

I have a need to be able to do the following:

Scenario:
1000 rows that contain duplicates in columns A, C, E. (there are not 1000 duplicates, but 1000 rows contain data that could be duplicates).

Based on these 3 columns, I would consider it a duplicate record if all 3 columns' values are identical. However, Column E is an email address and I want to consider this column duplicate if the domain name is the same. The excel function I created will extract the domain name =MID(E2,FIND("@",E2)+1,FIND(".",E2)-1), which will extract the domain name to a new column (F). So, If A, C, and F are duplicate, it is a duplicate record. Columns B,D,G etc do not matter.

Is there a way to do this programatically? Ideally, I would like an entire list of the unique values to be placed on another sheet.

Thank you
Terry