Written by Counts the number of unoccupied cells within a specified range.
Transforms a number into its textual form in a different numeral system, such as base 2 for binary representation.
Calculates the total number of rows within a given array or range.
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.
Horizontal search. Looks through the initial row of a specified range for a key and retrieves the value from a designated cell in the corresponding column.
Provides the formula output as a string.
Provides the column index for a given cell, mapping `A` to `1`.
Outputs a string representing a cell reference.