Hi Johan,

Am Tue, 1 Sep 2020 10:45:14 -0700 (PDT) schrieb :

Amazing :)

=IF(MAXIFS(Y:Y;I:I;I2)=0;"";MAXIFS(Y:Y;I:I;I2))

9sec calculate time for 50.000 records.

if you change the first MAXIFS to COUNTIF it is a little bit faster:

=IF(COUNTIF(I:I,I2)=0,"",MAXIFS(Y:Y,I:I,I2))


Regards
Claus B.
--
Windows10
Office 2016