Feb 24 2021 06:09 AM
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 |
Feb 24 2021 06:28 AM
SolutionAssuming 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.
Feb 25 2021 12:27 AM
Thank you soo much friend :)
Can you translate this function into a power query?
Feb 25 2021 01:06 AM
I can't help you with that; I hope someone else will step in.
Feb 25 2021 07:22 AM
@Ahmedb96 Perhaps like this?
Attached file contains a PQ solution that only uses "standard" applied steps. No custom M-code required.
Feb 24 2021 06:28 AM
SolutionAssuming 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.