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...
Simply enclose the expression in ARRAYFORMULA( 😞
=ARRAYFORMULA(LET(n, MAX(((A3:L19<>"")+A1:L1)*COLUMN(A3:L19)), IF(n=0, "", INDEX(A2:L2, MAX(((A3:L19<>"")+A1:L1)*COLUMN(A3:L19))))))
the function returns date which shifted by three cells