Duplicates and compare values in other cells

[member23]

Hello to you all,

I would really appreciate it if you could help me out with this one.

I’ve got a table:

A B
Martin Gray | 12
Joe Barker | 23
Marin Gray | 12.5

What I need to do is find the duplicates in column A, in this case Martin Gray, and then compare their values in column B. If the value in column B is <= to 0.5 then TRUE if >0.5 then FALSE.

Thanks for spending time to even read this.

Member23

 

[Oscar Cronquist]

[Table="width:, class:head"][tr=bgcolor:#E0E0F0][th] [/th][th]

A​

[/th][th]

B​

[/th][th]

C​

[/th][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

1​

[/td][td]Martin Gray [/td][td]

12​

[/td][td]

FALSE​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

2​

[/td][td]Joe Barker [/td][td]

23​

[/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

3​

[/td][td]Martin Gray [/td][td]

0.3​

[/td][td]

TRUE​

[/td][/tr]
[/table][Table="width:, class:grid"][tr][td]Sheet: Sheet2[/td][/tr][/table]

Formula in cell C1:
=IF(COUNTIF($A$1:$A$3,A1)>1,B1<=0.5,"")

 

[member23]

Thank you so much!!