Forum Discussion

Hongi Oinliha's avatar
Hongi Oinliha
Copper Contributor
Apr 23, 2018
Solved

Check if date is latest (with multiple criteria)

Hi,  I am designing an Excel sheet but unfortunately, I am unable to figure out one formula and I was hoping that one of the brilliant minds in this community is able to help me :).  In the 'is...
excel
  • SergeiBaklan's avatar
    SergeiBaklan
    Apr 23, 2018

    Hi Hongi,

     

    You may check by

    =[@Updated]=AGGREGATE(14,6,1/([Company]=[@Company])/([Criteria]=[@Criteria])*[Updated],1)

    Please see attached

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Apr 23, 2018

Hi Hongi,

 

You may check by

=[@Updated]=AGGREGATE(14,6,1/([Company]=[@Company])/([Criteria]=[@Criteria])*[Updated],1)

Please see attached

Hongi Oinliha's avatar
Hongi Oinliha
Copper Contributor
Apr 23, 2018

Thanks Sergei! 

 

This works excellent! 

Resources