Find duplicates
 

Hi

I have Excel 2003.

I have a spreadsheet where column C has over 3,000 item codes, some of these
are repeated, some more than once.

How do I highlight the codes that are appear more than once in the column.

thanks

Find duplicates
 

There are several methods in this link

http://www.cpearson.com/excel/Duplicates.aspx


--


Regards,


Peo Sjoblom



"Daniel - Sydney" wrote in message
...
Hi

I have Excel 2003.

I have a spreadsheet where column C has over 3,000 item codes, some of
these
are repeated, some more than once.

How do I highlight the codes that are appear more than once in the column.

thanks

Find duplicates
 

Select the range of cells in question. Assume this range is C1:C3000
Goto the menu FormatConditional Formatting
Select Formula Is
Enter this formula in the box on the right:

=COUNTIF(C$1:C$3000,C1)1

Click the Format button
Select the Patterns tab
Select a fill color of your choice
OK your way out.

--
Biff
Microsoft Excel MVP


"Daniel - Sydney" wrote in message
...
Hi

I have Excel 2003.

I have a spreadsheet where column C has over 3,000 item codes, some of
these
are repeated, some more than once.

How do I highlight the codes that are appear more than once in the column.

thanks

Find duplicates
 

Biff, thank you for you help, it worked perfectly.

Peo

thanks for the link, I have saved it in my Favorites.

regards


"T. Valko" wrote:

Select the range of cells in question. Assume this range is C1:C3000
Goto the menu FormatConditional Formatting
Select Formula Is
Enter this formula in the box on the right:

=COUNTIF(C$1:C$3000,C1)1

Click the Format button
Select the Patterns tab
Select a fill color of your choice
OK your way out.

--
Biff
Microsoft Excel MVP


"Daniel - Sydney" wrote in message
...
Hi

I have Excel 2003.

I have a spreadsheet where column C has over 3,000 item codes, some of
these
are repeated, some more than once.

How do I highlight the codes that are appear more than once in the column.

thanks

Find duplicates
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Daniel - Sydney" wrote in message
...
Biff, thank you for you help, it worked perfectly.

Peo

thanks for the link, I have saved it in my Favorites.

regards


"T. Valko" wrote:

Select the range of cells in question. Assume this range is C1:C3000
Goto the menu FormatConditional Formatting
Select Formula Is
Enter this formula in the box on the right:

=COUNTIF(C$1:C$3000,C1)1

Click the Format button
Select the Patterns tab
Select a fill color of your choice
OK your way out.

--
Biff
Microsoft Excel MVP


"Daniel - Sydney" wrote in
message
...
Hi

I have Excel 2003.

I have a spreadsheet where column C has over 3,000 item codes, some of
these
are repeated, some more than once.

How do I highlight the codes that are appear more than once in the
column.

thanks