Get new posts in your inbox

Did you know you can actually sort data dynamically using Array Formulas? Earlier this week, we introduced the powerful new functionality of Array Formulas. And today we’re highlighting a unique way to sort your data using this functionality. 

Have a look at the two spreadsheets embedded below. The first example shows data gathered from NYSE, including the current stock price, stock price at previous day close, and % change from previous day close, using the Stock Formula for various stock markets like NYSE-100, NASDAQ, etc. The second table in each sheet contains the list of companies sorted in descending order of the price change using Array Formulas:

Similarly, this second example displays matches from a Cricket tournament by taking data from the ‘Match Details’ sheet and making use of Array Formulas:

This is just one way to creatively use Array Formulas. Have you used Array Formulas in a unique way? If so, do share it with us.