Tag: Arrays

Coming hot on the heels of last year’s batch of new lambda functions, Google recently announced another group of new analytical functions for Sheets.

Included in this new batch are the long-awaited LET function, 8 new array manipulation functions, a new statistical function, and a new datetime function.

Let’s begin with a look at the new array functions. The LET function is at the end of the post.

1. TOROW Function
2. TOCOL Function
3. CHOOSEROWS Function
4. CHOOSECOLS Function
5. WRAPROWS Function
6. WRAPCOLS Function
7. VSTACK Function
8. HSTACK Function
9. MARGINOFERROR Function
10. EPOCHTODATE Function
11. LET Function

Continue reading 11 New Analytical Functions In Google Sheets For 2023