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

PreviousmyReplaceNextreturnLastCell

Last updated