Hi

I have Office 2003 with Excel

I have a spreadsheet with several columns each over 1,000 cells long,
columns A and C contain product names, there are a lot of duplicates between
A and C, I need know which names in A are duplicated in C.

Is there a way I can do this.

thanks

Daniel

Chip Pearson has lots of techniques to work with duplicates:
http://www.cpearson.com/excel/duplicat.htm

Daniel wrote:
>
> Hi
>
> I have Office 2003 with Excel
>
> I have a spreadsheet with several columns each over 1,000 cells long,
> columns A and C contain product names, there are a lot of duplicates between
> A and C, I need know which names in A are duplicated in C.
>
> Is there a way I can do this.
>
> thanks
>
> Daniel

--

Dave Peterson

Okay, thanks for your reply

regards

Daniel
"Dave Peterson" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Chip Pearson has lots of techniques to work with duplicates:
> http://www.cpearson.com/excel/duplicat.htm
>
> Daniel wrote:
>>
>> Hi
>>
>> I have Office 2003 with Excel
>>
>> I have a spreadsheet with several columns each over 1,000 cells long,
>> columns A and C contain product names, there are a lot of duplicates
>> between
>> A and C, I need know which names in A are duplicated in C.
>>
>> Is there a way I can do this.
>>
>> thanks
>>
>> Daniel
>
> --
>
> Dave Peterson