How calculate the max in a column

Flor · August 27, 2024, 4:37pm

Dear all,
In Excel it exist a fonction MAXIFS, I need find in Easymorpht an equivalent function

I need calculate a column that contains the max date in a matrix ID + QUARTER + DATE

In the below exemple ; the max date for the couple ( ID = A and quarter =1Q_2024) is 23/03/2024

Could you help me to find the formula to calculate that

id	QUARTER	DATE	MAX QUARTER/ID
A	2Q_2024	25/06/2024	25/06/2024
A	1Q_2024	23/03/2024	23/03/2024
A	4Q_2024	31/12/2024	31/12/2024
A	1Q_2025	31/03/2025	31/03/2025
A	1Q_2024	31/01/2024	23/03/2024

thanks for your help

dgudkov · August 28, 2024, 12:48am

You can do it with the "Total/subtotals" action. See the example below.

PS. Special thanks for providing a sample dataset.