find duplicate cells in the same column

[amy]

How to find duplicate cells in a column?

thanks!

 

[mhauler]

....I guess this is stating the obvious, but have you tried setting
filters...?

 

[amy]

there's long list in the spread sheet, and each cell
should have unique value in column1.
I looked at filter but it asks for specific value as
criteria (=, <, >, like...), and I couldn't give it
because I don't know it.
All I want is to select out all the cells which has
a value equals to the value some other cells have.
for example:
if the list is like:
123
234
123
456
456
111
-- then the "filter" will give :
123
123
456
456
But I wouldn't know in advance the 123 and 456 are the
criteria.

thanks!

 

[Kevin McClement]

Amy,

If you select the range of cells assuming it starts in
A1, then go to Tools > Conditional Formatting
then input the following:
"Formula is" =COUNTIF($A$1:$A$??,A1)>1
Then set the formatting to color the cells however you
wish. This will highlight all the cells that have
duplicate entries. If you need more, feel free to contact
me directly.
HTH
Kevin

 

[amy]

I got it, thank you so much Kevin !

-----Original Message-----
Amy,

If you select the range of cells assuming it starts in
A1, then go to Tools > Conditional Formatting
then input the following:
"Formula is" =COUNTIF($A$1:$A$??,A1)>1
Then set the formatting to color the cells however you
wish. This will highlight all the cells that have
duplicate entries. If you need more, feel free to contact
me directly.
HTH
Kevin
.