New Functions: TOROW, TOCOL, CHOOSEROWS, CHOOSECOLS
Excel file teaching how to perform New Functions: TOROW, TOCOL, CHOOSEROWS, CHOOSECOLS operation.
Excel Template for New Functions: Torow, Tocol, Chooserows, Choosecols
With TOROW and TOCOL, intervals are reduced to a single dimension. CHOOSEROWS and CHOOSECOLS are used to select rows and columns. Powerful combinations for dynamic reporting are illustrated.
Hope it is useful.