How do I access the 30 new advanced functions in Numbers app?

Hi kranthikatikala

Badunit suggests this link:

What’s new in Numbers on Mac – Apple Support (AU)

Copied from another discussion:

New Numbers Update adds @ Operators to my… - Apple Community 

Regards,

Ian.

Yeah, I think this was badly handled by Apple - "30 New Functions!" but we're not going to tell you what they are 😛

Most of the functions I've found relate to either arrays or LAMBDA functions (which basically let you write your own function within a cell).

Here's what I've come up with so far, based on walking through the Functions list and recognizing something new:

Logical & Info:

BYROW()

BYCOL()

ISOMITTED()

LAMBDA()

LAMBDA.APPLY()

LET()

MAKEARRAY()

MAP()

REDUCE()

SCAN()

Numeric:

RANDARRAY()

Reference:

CHOOSECOLS()

CHOOSEROWS()

DROP()

EXPAND()

FILTER() ?

HSTACK()

SORTBY()

TAKE()

TOCOL()

TOROW()

UNIQUE()

VSTACK()

WRAPCOLS()

WRAPROWS()

Text:

ARRAYTOTEXT()

That's only 26, though, so I've probably missed something :)

Oh, I missed the matrix-related functions:

Numeric:

MDETERM()

MINVERSE()

MMULT()

MUNIT()

SEQUENCE()

and:

Text:

TEXTSPLIT()

I think ISOWEEKNUM is also new (though it might have been there in previous versions.).

SG

There are also some like BIT… or so.

but which one are those in German?

how am I supposed to try and embrace these new functions if I don’t know which ones they are?