Thread: Array formula for lookup a max value cost too much time
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Claus Busch Claus Busch is offline
external usenet poster
  
Posts: 3,872
Default Array formula for lookup a max value cost too much time
Hi Johan,

Am Tue, 1 Sep 2020 20:35:39 -0700 (PDT) schrieb :

The problem is that when there is no value in column YY then it results with COUNTIF in 0 and with MAXIFS in "" (empty).

try:
=IF(COUNTIFS(I:I,I2,Y:Y,"<")=0,"",MAXIFS(Y:Y,I:I, I2))

Regards
Claus B.
--
Windows10
Office 2016
Reply With QuoteReply With Quote