Written by Extracts substrings that match a specified regular expression.
Extracts a segment of text starting from a specific character and extending for a defined number of bytes.
Determines variance based on a sample set.
Computes the skewness of a dataset, providing insight into the distribution’s symmetry around the mean.
Calculates the mean of a specified range based on given conditions.
Transforms a given date/time, percentage, currency, or any formatted numeric value into a raw number, stripping away all formatting.
Given a numeric input, returns `-1` for negative numbers, `1` for positive numbers, and `0` for zero.
Vertical lookup. Searches the first column of a specified range for a key and retrieves the corresponding value from another cell in the same row.
Returns the number of the row containing a specified cell.
Provides details about a specified cell’s attributes.