Friday, 1 August 2014

Index formula in excel

Index Formula:

index formula in excel

Array: is a range of cells or an array constant.

    If array contains only one row or column, the corresponding row_num or column_num argument is optional.
    If array has more than one row and more than one column, and only row_num or column_num is used, INDEX returns an array of the entire row or column in array.

Row_num : Selects the row in array from which to return a value. If row_num is omitted, column_num is required.

Column_num : Selects the column in array from which to return a value. If column_num is omitted, row_num is required.

0 comments:

Post a Comment