Forum Discussion

Copper Contributor

Apr 25, 2019

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

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 comp...

excel

Formulas and Functions

Macros and VBA

SergeiBaklan

Diamond Contributor

Apr 25, 2019

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

not unigue by max.xlsx10 KB

tlisobar
Copper Contributor
Apr 25, 2019
That is exactly I was looking for. Thank you so much.
- SergeiBaklan
  Diamond Contributor
  Apr 25, 2019
  tlisobar , you are welcome