Forum Discussion
Solved
Get a value from Range
Hi Currently, I am using goole sheet. I need a function to get last date of update. Last date of update means the latest date from range (C7:H7) of the following conditions: the last column in t...
=ARRAYFORMULA(MAX(IF(C5:H5+C6:H6+C8:H8+(C9:H18<>""),C7:H7)))
=ARRAYFORMULA(LET(m, MAX(IF(C5:H5+C6:H6+C8:H8+(C9:H18<>""),C7:H7)), IF(m=0, "", m)))