Thread: Array formula for lookup a max value cost too much time
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
[email protected] jmsla...@gmail.com is offline
external usenet poster
  
Posts: 9
Default Array formula for lookup a max value cost too much time
Dear Claus,

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

Is there also a formula solution for :)

regards, Johan

Reply With QuoteReply With Quote