A
amy
How to find duplicate cells in a column?
thanks!
thanks!
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
mhauler
....I guess this is stating the obvious, but have you tried setting
filters...?
filters...?
A
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!
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!
K
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
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
A
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
.