News

Array.join(), for example, will take the array that .join() was added to and turn it into a single string. Don't worry to much about functions and methods, though. We'll cover that stuff tomorrow.
SORT()’s array argument is the entire FILTER() function. The sort_index value of 2 sorts by the Value column, the second column in array. The sort_index value is -1, which applies a descending sort.
Thanks to the newish dynamic array function XLOOKUP(), you now have more power and less confusion. In this article, we’ll compare XLOOKUP() to VLOOKUP() so you can see how XLOOKUP() excels and ...
There’s an array of floating point numbers, thelist, and two functions that process the list. ... If you study the code, the two averaging functions, average2x and averagethird, ...