SOLVED

New Contributor

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 latest?' column I would like to check if it is the latest entry of a specific company and criteria. The table will be used to pivot data so I would like to use a filter to be able to do both 'now' analysis as well as trend analysis.

For example:

IF A2 = A2 & IF C2 = C2 & IF D2 = D2 THEN check if F2 = latest.

Is this formula possible? And how should I formulate it?

If you require further explanation please, let me know. I would be forever grateful!

I am using Excel 2010 but have accessibility to excel 2013.

2 Replies
best response confirmed by Hongi Oinliha (New Contributor)
Solution

Re: Check if date is latest (with multiple criteria)

Hi Hongi,

You may check by

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