Hi Johan,

Am Mon, 31 Aug 2020 19:31:04 -0700 (PDT) schrieb :

{=IF(MAX(IF(I:I=I2;Y:Y))=0;"";MAX(IF(I:I=I2;Y:Y))) }

Both formulas spend too much time when calculate.

I tried following formula with more than 50000 values and it did it in a
blink:
=IF(COUNTIF(I:I,I2)=0,"",MAXIFS(Y:Y,I:I,I2))


Regards
Claus B.
--
Windows10
Office 2016