I need to take a column over 5000 rows long and find out which control
numbers are duplicated. I have tried =COUNTIF($C$2:$C$5000,C2)1 as an
array in conditional formatting, but it didn't work. If it had worked this
would have been perfect to highlight all duplicated numbers.

Can someone tell me what I did wrong here?
--
Cheryl

For highlighting duplicates. Select the range C2:C5000 and try
=COUNTIF(C$2:C$5000,C2)1

If this post helps click Yes
---------------
Jacob Skaria


"Cheryl" wrote:


I need to take a column over 5000 rows long and find out which control
numbers are duplicated. I have tried =COUNTIF($C$2:$C$5000,C2)1 as an
array in conditional formatting, but it didn't work. If it had worked this
would have been perfect to highlight all duplicated numbers.

Can someone tell me what I did wrong here?
--
Cheryl

I have tried =COUNTIF($C$2:$C$5000,C2)1
as an array in conditional formatting

That should have worked. Are you sure you applied it properly?

Select the *entire* range of cells starting from cell C2. C2 will be the
active cell. The active cell is the one cell in the selected range that *is
not* shaded. The formula is relative to the active cell.

In Excel versions 2003 and earlier:

Goto the menu FormatConditional Formatting
Select the Formula Is option
Enter this formula in the box on the right:
=COUNTIF($C$2:$C$5000,C2)1
Click the Format button
Select the desired style(s)
OK out

In Excel 2007:

Goto Home tabStylesConditional FormattingManage rulesNew ruleUse a
formula to determine which cells to format
Enter this formula in the box below:
=COUNTIF($C$2:$C$5000,C2)1
Click the Format button
Select the desired style(s)
OK out

--
Biff
Microsoft Excel MVP


"Cheryl" wrote in message
...

I need to take a column over 5000 rows long and find out which control
numbers are duplicated. I have tried =COUNTIF($C$2:$C$5000,C2)1 as an
array in conditional formatting, but it didn't work. If it had worked this
would have been perfect to highlight all duplicated numbers.

Can someone tell me what I did wrong here?
--
Cheryl