how to check if any repeated values

[Alex]

I have some values (around 20) such as
451
523
658
....
in a column. There shouldn't be any repeated values.
How could I check whether there are any repeated
values/numbers in the column?

Thanks

 

[Charles Maxson]

Assuming column A has your data, add this formula to column B next to all of
your data items...

=IF(COUNTIF(A:A,A1)>1,"Duplicated","")

 

[GerryK]

By way of example:
In B2 if you have Apples, B3 Oranges, B4 Oranges, B5
Oranges and in B6 Pears.
In C2 put =INDEX($B$2:$B$6,MATCH(0,COUNTIF(Sheet1!
$C$1:$C1,$B$2:$B$6),0)) and then in C3 put
=INDEX($B$2:$B$6,MATCH(0,COUNTIF($C$2:$C2,$B$2:$B$6),0))
and copy this one down as far as you need.
Note: enter the above as array hold Ctrl,Shift then Enter.
Column C will have only the unique and the rest of the
column will be #N/A

 

[Alex]

Thanks a lot, Charles.
It's working good.

-----Original Message-----
Assuming column A has your data, add this formula to column B next to all of
your data items...

=IF(COUNTIF(A:A,A1)>1,"Duplicated","")

--
Charles
www.officezealot.com



.