Written by Calculates the standard deviation for an entire population drawn from a database-like array or range using a SQL-inspired query.
Calculates the standard deviation of a population sample extracted from a database table-like array or range, utilizing a SQL-like query.
Calculates the product of values extracted from a database-like array or range using a SQL-like query.
Retrieves the smallest value from a range or array that resembles a database table, applying a SQL-like query.
Retrieves the highest value from a database-like array or range using a SQL-style query.
Fetches a single value from a database-like range or array using a SQL-style query.
Counts entries, including text, drawn from a database-style array or range using a SQL-like query.
Calculates the count of numeric entries from a database-like range, using a query formatted in the style of SQL.
Calculates the mean of a selected set of values from a database-like array or range using a query format similar to SQL.
Arranges the specified row or column of cells into multiple rows based on a designated number of elements, resulting in a newly structured array.