Written by Calculates the product of values extracted from a database-like array or range using a SQL-like 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.
Arranges the specified row or column of cells into multiple rows based on a designated number of elements, resulting in a newly structured array.
Transforms a specified row or column of cells into a new array by organizing them into columns after a given number of elements.
Converts a set of data or cells into a single horizontal row.
Converts a range of cells or an array into a single-column format.
Determines the total of squared differences from two sets of values.
Determines the total of the squared differences between corresponding elements from two arrays.
Scans through an array to generate intermediate values by applying a LAMBDA function to each entry. It yields an array containing the intermediate values produced at every individual step.