Returns the last value of an array of cells filtering empty & false values

Video Example


  • cells: List of cells that will be checked

Expected Output

  • String: The last value of a group of cells.

Text example

returnLastCell(B2:E2) // Cell values 26 28 32 44
// Return 44

Use cases

  • Extract Week over Week data automatically combining with returnLastCellInversed
  • Get last added data in a row/column automatically in Sheets