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

Question

Hello Community,&nbsp;I have got three columns with following data in it:I want that all unique Products in column A&nbsp; will be set to "Yes" but if there is a duplicate in column A it schould compare the Date in column B&nbsp; between those two and take the latest date and set it to "Yes" and the other one to "No".Can anyone help me?

sergeibaklan · Answer

tlisobar&nbsp;,
&nbsp;
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

tlisobar · Answer

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

sergeibaklan · Answer

tlisobar&nbsp;, you are welcome

Forum Discussion

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

3 Replies

Resources