Written by Calculates the number of distinct values within a defined set of values and ranges.
Calculates the total number of rows within a given array or range.
Retrieves an aggregated value from a pivot table based on designated row and column headings.
Calculates the number of columns in a chosen array or range.
Assesses various conditions and returns a corresponding value for the first condition that evaluates to true.
Determines whether a given value is not text.
Executes a query using the Google Visualization API Query Language on data.
Provides unique rows from the given source range while eliminating duplicates. The rows appear in the same order as they first occurred in the source range.
Returns the initial n entries of a dataset following a sorting operation.
Returns a modified version of the source range, displaying only the rows or columns that satisfy the specified criteria.