Forum Discussion
I need a function to return last date of update
Hi I need a function to do this case: in the attached file, based on the values of cells range A3:L19 and the values of cells range A1:L1; if there is data (P OR Number value from (1 to 5)) in th...
As far as I can tell:
=ARRAYFUNCTION(LET(n, MAX(IF((A3:L19<>"")+A1:L1+A22:L22, COLUMN(A3:L19))), IF(n=0, "", INDEX(A2:L2, n))))
There is an error when applying this formula #NAME?
there is another error #NAME?
Could you please write the function in the attached file
Sorry, ARRAYFORMULA instead of ARRAYFUNCTION