Earlier this week, I mentioned my excitement over the recent update to Apple’s Numbers spreadsheet app adding more than 30 new functions. But alas, though I reached out to Apple to try and get a complete list, I haven’t gotten one yet.
Fortunately reader Neil came to the rescue: using the Internet Archive’s Wayback machine, he retrieved an older version of Apple’s list of functions and compared it to the new version, thus isolating all the new functions. Well done, Neil, and thanks for passing them on.
Here, then, is a list of all the new functions in the latest update, organized by Apple’s categories and linked to their documentation. Now, fellow Numbers enthusiasts, we at least know what we have at our disposal.
Logical and information functions
Numeric functions
Reference functions
- CHOOSECOLS
- CHOOSEROWS
- DROP
- EXPAND
- FILTER
- HSTACK
- SORT
- SORTBY
- TAKE
- TOCOL
- TOROW
- UNIQUE
- VSTACK
- WRAPCOLS
- WRAPROWS
