Last update , Question

[Ahmedb96]

Hello guys,

I'd like to write a function in Excel in the last update column to define
Which row is the most recent in the evaluation (evaluation date Col), taking into account the contract number (x,Y)

For clarity in the contract X, the latest evaluation update is on 04/01/2021

The answer is yes or no

conract	visit date	Evaluation date	last update
x	01/01/2021	01/01/2021
x	01/01/2021	03/01/2021
x	01/01/2021	04/01/2021
y	02/02/2021	02/02/2021
y	02/02/2021	03/02/2021
y	02/02/2021	04/02/2021

[#2 · Accepted solution]

@Ahmedb96 

Assuming that the data are in columns A to D, with headers in row 1, enter the following formula in D2:

=IF(MAXIFS($C$2:$C$7,$A$2:$A$7,A2)=C2,"yes","no")

Fill down.

[#3]

Thank you soo much friend :)

Can you translate this function into a power query? 

[#4]

@Ahmedb96 

I can't help you with that; I hope someone else will step in.

[#5]

@Ahmedb96 Perhaps like this?

Attached file contains a PQ solution that only uses "standard" applied steps. No custom M-code required.