Query Arithmetic

Mar 14, 2024 3:47 PM
Mar 14, 2024 3:47 PM

The QUERY function is able to process arithmetic functions by default, being processed on the same level as other data manipulation functions. As such, it allows for arithmetic processing via strings.

Syntax

INDEX(QUERY(, "select "&expression, ), 2)

Code golf syntax for non-array-enabled formulae:

+SORT(QUERY(, "select "&expression, ))