Reference Functions

Clarkson ITT Wiki functions logoThis section of the Clarkson ITT Wiki includes articles and videos tagged as providing technical information on or demonstrating the use of functions that return References to ranges and functions that return information about ranges, such as their size and location.

Some articles are tagged as being available only to students and alumni of specific courses, or for subscribers to the The Learning HabITT and only those to which you have access will be listed.  You may need to login to see all the articles available to you.

Title Modified Date
ADDRESS 16 July 2022
AREAS 20 July 2022
CELL 30 May 2023
CHOOSE 15 July 2022
COLUMN, ROW, SHEET 30 December 2023
COLUMNS, ROWS 20 July 2022
DROP 29 February 2024
EXPAND 29 February 2024
IF 15 July 2022
IFS 15 July 2022
INDEX 30 December 2023
INDIRECT 16 July 2022
ISREF 30 May 2023
MATCH 17 July 2022
OFFSET 16 July 2022
SWITCH 15 July 2022
TAKE 29 February 2024
XLOOKUP 04 March 2024
XMATCH 17 July 2022