Other Functions
TRANSPOSE(array): Returns the transpose of an array.
Example: =TRANSPOSE(A1:C3) flips the rows and columns of the array.
OFFSET(reference, rows, cols, [height], [width]): Returns a reference offset from a given reference.
Example: =OFFSET(A1, 2, 3) returns the reference to cell D3.
INDIRECT(ref_text, [a1]): Returns the reference specified by a text string.
Example: =INDIRECT(“A”&”1”) returns the value in cell A1.
CHOOSE(index_num, value1, [value2], …): Chooses a value from a list of values based on an index number.
Example: =CHOOSE(2, “Red”, “Blue”, “Green”) returns “Blue”.
For all things Strategy, Management Theories, and Business Frameworks, please visit https://www.stratrix.com