Microsoft Excel Functions & Formulas

Use the INDEX function to determine the last

number in a column

Sometimes it is very useful to let Excel automatically determine

the last value in a list. Use the INDEX function in combination with

COUNTA and COUNTBLANK to determine the last number in a

column. The INDEX function returns the value of an element in a

table or an array that is selected by the row and column number

indexes.

INDEX(array, row_num, column_num)

array: A range of cells or an array constant.

row_num: Indicates the row in an array from which a value will

be returned. If omitted, column_num is required.

column_num: Indicates the column in an array from which a

value will be returned. ...