Address
Choose
Column
Columns
Row
Rows
Address
3.1) Address: This function find the address of a cell in a worksheet, given specific row and column numbers.
Syntax= ADDRESS(row_num, column_num, [abs_num], [a1], [sheet_text])
Example
Choose
3.2) Choose: This function uses index_num to return a value from the list of value arguments.
Syntax = CHOOSE(index_num, value1, [value2],…)
Example
Column
3.3) Column: This function find out column number
Syntax = COLUMN([reference])
Example
Columns
3.4) Columns: This function find out column number of array
Syntax= COLUMNS(array)
Example
Row
3.5) Row: This function return the row number
Syntax= ROW([reference])
Example
Rows
3.6) Rows: This function return the row number from array
Syntax= ROWS(array)
Example