May 08 2019 12:10 PM
Hi everyone,
I have a problem on this sheet. Any idea about how it may work properly.
Thanks,
Mins
I have
May 08 2019 02:48 PM
@MINIS2310 Can you explain what you are trying to achieve? What is the problem?
May 08 2019 04:19 PM
@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.