Forum Discussion
MINIS2310
May 08, 2019Copper Contributor
IF-MIN-SUMIFS function does not give the proper result
Hi everyone, I have a problem on this sheet. Any idea about how it may work properly. Thanks, Mins I have
SergeiBaklan
May 08, 2019Diamond Contributor
MINIS2310 , if you mean to find min date in AP against column C where values match row values from P to V, when it could be (in AQ30)
=AGGREGATE(15,6,1/(C:C=$P30:$V30)/(C:C<>"")*AP:AP,1)
However, performance will be bad on entire columns.
In your locale you need to change commas on semicolons in above formula.