Written by Calculates the total number of rows within a given array or range.
Returns the number of the row containing a specified cell.
Provides a range reference that is displaced by a specified number of rows and columns from a given starting cell reference.
Returns the position of an item in a specified range that corresponds to a given value.
Searches a row or column for a specific key and returns the corresponding value from a specified result range that aligns with the search input.
Returns a reference to a cell defined by a text string.
Retrieves the content of a cell based on its specified row and column indices.
Retrieves an aggregated value from a pivot table based on designated row and column headings.
Provides the formula output as a string.
Calculates the number of columns in a chosen array or range.