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...
Do you want to return a single date, or one date for each of rows 3 to 19?
Single date
=INDEX(A2:L2, MAX((A3:L19<>"")*COLUMN(A3:L19)))
- Many thanks for your reply ..
There is another condition in the attached file. the condition should be OR with the other condition
The condition is: "The last cell in the row(A1:L1) is equal to True "
How the formula will be?Using 365
= LET( BooleanRow, $A$1:$L$1, date, $A$2:$L$2, values, $A$3:$L$19, entriesPerCol, BYCOL(values, COUNTA), isPopulated?, SIGN(entriesPerCol + BooleanRow), lastDate, XLOOKUP(1, isPopulated?, date,,,-1), lastDate )
