Index:
One propensitates towards complacency after learning the lookups, match, Sumif, Countif etc. because all these are day to day functions and one feels good about himself especially after he/she is tending towards being a rising star in the eyes of his reporting boss.
However, to get the respect which the "Halley's comet" gets, one needs to think out-of-the-box kinds so that he/she can also become like the force of attraction despite the sky being filled with beautiful stars.
To achieve that "Halley's commet" status - learn Index in Excel. It is one of those which can startle you and many others.
It works like any other data retrieving function but it has lot to offer beyond its main function as it can be combined with other functions in excel. There are two sytanxes for an index function which are explained below -
1)INDEX(array, row_number, [column_number]) where,
array - specific range of cells (or can be an entire table)
row_number - the value of the row number that one is wanting to retrieve
[column_number] - which is optional and is the value of the column number that one is wanting to retrieve.
2)INDEX(reference, row_number, [column_number], [area_number]) where,
reference - which means a range that needs to be specified
row_number - the value of the row number within the range that one is wanting to retrieve
[column_number] - which is optional and is the value of the column number within the range that one is wanting to retrieve.
[area_number] - which is optional and is the range that needs to be used from the reference parameter
One propensitates towards complacency after learning the lookups, match, Sumif, Countif etc. because all these are day to day functions and one feels good about himself especially after he/she is tending towards being a rising star in the eyes of his reporting boss.
However, to get the respect which the "Halley's comet" gets, one needs to think out-of-the-box kinds so that he/she can also become like the force of attraction despite the sky being filled with beautiful stars.
To achieve that "Halley's commet" status - learn Index in Excel. It is one of those which can startle you and many others.
It works like any other data retrieving function but it has lot to offer beyond its main function as it can be combined with other functions in excel. There are two sytanxes for an index function which are explained below -
1)INDEX(array, row_number, [column_number]) where,
array - specific range of cells (or can be an entire table)
row_number - the value of the row number that one is wanting to retrieve
[column_number] - which is optional and is the value of the column number that one is wanting to retrieve.
2)INDEX(reference, row_number, [column_number], [area_number]) where,
reference - which means a range that needs to be specified
row_number - the value of the row number within the range that one is wanting to retrieve
[column_number] - which is optional and is the value of the column number within the range that one is wanting to retrieve.
[area_number] - which is optional and is the range that needs to be used from the reference parameter
0 comments:
Post a Comment