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
|