News

The CHOOSECOLS and CHOOSEROWS functions in Google Sheets are ideal for quickly extracting specific columns or rows from your ...
Other array-based functions include SORTBY and RANDARRAY. The SORTBY function works like the SORT function, except it sorts data according to data contained in another array. For example, you might ...
Here’s a simple example explaining how the new SORT array function works. Columns A and B in the screenshot below (cells A3:B17) contain unsorted sales data by state. To sort these data using a ...
Learn how to use Excel’s dynamic array formulas to automate data pairing, save time, and unlock new insights in your analysis ...
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.
The lookup function in Excel can save you a lot of time and effort, but only if you actually know how to use its many forms and alterations.
Excel’s BYCOL() and BYROW() functions evaluate data across columns and rows, returning an array result set allowing you to bypass a lot of work.