returnCellInversed

Overview

Returns the value of a specific value by its inverse position filtering empty/false values

Video Example

Arguments

  • cells: List of cells that will be checked
  • inverseIndex: Index of the value to return (in an inverse way). 0 means last, 1 means second to last, etc

Expected Output

  • String: The value of a cell by its inversed index

Text example

returnCellInversed(B2:E2, 0)
// Cell values 26 28 32 44
// Return 44
returnCellInversed(B2:E2, 1)
// Cell values 26 28 32 44
// Return 32

Use cases

  • Extract Week over Week data automatically combining with returnLastCell