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?
