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...
In your sample workbook, A1:L1 is empty (and you originally mentioned A1:A18 instead of A1:L1)
=LET(n, MAX((A3:L19<>"")*A1:L1*COLUMN(A3:L19)), IF(n=0, "", INDEX(A2:L2, MAX((A3:L19<>"")*A1:L1*COLUMN(A3:L19)))))
return no thing