matching up and auto populating

[The Grim Discovery]

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]Reference
[/TD]
[TD]Eligible
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]ABC
[/TD]
[TD]Yes
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]123
[/TD]
[TD]Yes
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]DEF
[/TD]
[TD]No
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5
[/TD]
[TD]123
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6
[/TD]
[TD]123
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7
[/TD]
[TD]GHI
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Hiya

Can anyone help me with the following problem.
If a value in Col A is repeated elsewhere in Col A I'd like its corresponding cell in Col B to be automatically populated. In this instance cells B5 & B6 should populate with a 'yes' because of the data in Row 3. Col A could contain an almost infinite range of references - many of which wont duplicate but some will.

Thanks in advance.

 

[AlanY]

try

=IF(COUNTIF(A:A,A2)>1,"Yes","No")

 

[jmacleary]

Hi there. Put this formula in B2 and drag down: =IF(COUNTIF(A:A,A2)>1,"Yes","No")

This will flag all instances where the reference is duplicated, including the first instance.

 

[The Grim Discovery]

Thank J and Alan - appreciate your time and knowledge.