Prev: comparing data
Next: Pivot Table showing wrong data
From: JRD on 3 Mar 2010 09:22
Can anyone help?

If I have a column of 10 digit numbers, is there a function which can
identify when a number is repeated

e.g.

A B
1 Number Repeat?
2 1234567890 Yes
3 2345678901 No
4 3456789012 No
5 1234567890 Yes
6 4567890123 No


So I need a function entered in column B which searches down the entire
column A to look for an identical number and if it finds one, it puts in
"Yes" and if not it puts in "No"

Thanks

John
From: Eduardo on 3 Mar 2010 09:29
Hi,
try

=IF(COUNTIF($A$1:$A$4,A1)>1,"Yes","NO")

copy formula down

"JRD" wrote:

> Can anyone help?
>
> If I have a column of 10 digit numbers, is there a function which can
> identify when a number is repeated
>
> e.g.
>
> A B
> 1 Number Repeat?
> 2 1234567890 Yes
> 3 2345678901 No
> 4 3456789012 No
> 5 1234567890 Yes
> 6 4567890123 No
>
>
> So I need a function entered in column B which searches down the entire
> column A to look for an identical number and if it finds one, it puts in
> "Yes" and if not it puts in "No"
>
> Thanks
>
> John
 | 
Pages: 1
Prev: comparing data
Next: Pivot Table showing wrong data