Compare data in a column and set a cell to yes if date is higher than the other

[tlisobar]

Hello Community,

I have got three columns with following data in it:

I want that all unique Products in column A  will be set to "Yes" but if there is a duplicate in column A it schould compare the Date in column B  between those two and take the latest date and set it to "Yes" and the other one to "No".

Can anyone help me?

[#2]

@tlisobar ,

That could be

=IF(COUNTIF($A$2:$A$4,$A2)=1,"Yes", IF($B2=AGGREGATE(14,6,1/($A2=$A$2:$A$4)*$B$2:$B$4,1),"Yes","No"))

and drag it down

[#3]

That is exactly I was looking for. Thank you so much.

[#4]

@tlisobar , you are welcome