Copying Duplicate rows

[terryvanduzee]

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

[Tom Ogilvy]

If you move A, C and F to be adjacent, then you can use Advanced filter
after you select the 3 columns - use the unique option. You may have to do
a copy => Paste Special with the current column F first.

--
Regards,
Tom Ogilvy


"terryvanduzee" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>
>
> --
> terryvanduzee
> ------------------------------------------------------------------------
> terryvanduzee's Profile:
> http://www.excelforum.com/member.php...o&userid=37004
> View this thread: http://www.excelforum.com/showthread...hreadid=567285
>