General Functions in Excel: Difference between revisions
Jump to navigation
Jump to search
(Created page with "=Internal= * Excel =<tt>INDEX</tt>= The <code>INDEX</code> function returns a value or a reference to a value from a table or range. <font size...") |
(→INDEX) |
||
| Line 15: | Line 15: | ||
* '''row_num''' selects the row in array from which to reenter the value. | * '''row_num''' selects the row in array from which to reenter the value. | ||
=<tt>ROW</tt>= | |||
Returns the town number of a reference. The reference is a cell or a range. | |||
Revision as of 04:19, 21 December 2023
Internal
INDEX
The INDEX function returns a value or a reference to a value from a table or range.
INDEX(array, row_num, [column_num])
where:
- array is a range of cells or an array constant.
- row_num selects the row in array from which to reenter the value.
ROW
Returns the town number of a reference. The reference is a cell or a range.