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]

	A​	B​	C​
1​	Martin Gray	12​	FALSE​
2​	Joe Barker	23​
3​	Martin Gray	0.3​	TRUE​

Sheet: Sheet2

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

 

[member23]

Thank you so much!!