Forum Discussion

Iron Contributor

Nov 03, 2024

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...

Iron Contributor

Nov 03, 2024

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?

PeterBartholomew1

Silver Contributor

Nov 03, 2024

ajl_ahmed

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
  )

ajl_ahmed
Iron Contributor
Nov 03, 2024
Is it working with google Sheet? I tried it with google sheet but return !Value#