which functions are not available in Excel 2021 apart from Textbefore and Textafter?

[snjpverma]

Which functions are not available in Excel 2021 apart from Textbefore and Textafter?

 

[etaf]

i use this as a reference for functions in different version - not the best - but i found it more accurate then some others

Excel Functions 365 New Functions

Excel Reference - Microsoft Office Add-ins and Consultancy. One website for all Microsoft Office Users and Developers.

bettersolutions.com

ARRAYTOTEXT	(2021) Returns the contents of an array or cell range converted into text.
BYCOL	(2021) Returns the results from applying a LAMBDA function to each column in an array.
BYROW	(2021) Returns the results from applying a LAMBDA function to each row in an array.
CHOOSECOLS	(2022) Returns the array with just a specific number of columns.
CHOOSEROWS	(2022) Returns the array with just a specific number of rows.
DROP	(2022) Returns the array without certain rows or columns.
EXPAND	(2022) Returns the array expanded or padded to specific dimensions.
FIELDVALUE	(2020) Returns the field data from a Stocks or Geography linked data type.
HSTACK	(2022) Returns the array after combining two arrays horizontally in sequence.
IMAGE	(2022) Returns the image from a web URL.
ISOMITTED	(2021) Returns the value True or False depending whether the value in a LAMBDA is missing.
LAMBDA	(2020) Returns the results of a formula added as a named range.
MAKEARRAY	(2021) Returns the array calculated by applying a LAMBDA function.
MAP	(2021) Returns the array formed by applying a map using a LAMBDA function.
REDUCE	(2021) Returns the total value after reducing an array by applying a LAMBDA function.
SCAN	(2021) Returns the array after applying a LAMBDA function to each value and returns an array.
STOCKHISTORY	(2020) Returns the historical data about a financial instrument.
TAKE	(2022) Returns the intersection of specific rows and columns in an array.
TEXTAFTER	(2022) Returns the characters from the end of a text string after a delimiter.
TEXTBEFORE	(2022) Returns the characters from the start of a text string before a delimiter.
TEXTSPLIT	(2022) Returns the text string split into multiple columns using delimiters.
TOCOL	(2022) Returns the array transformed into a single column.
TOROW	(2022) Returns the array transformed into a single row.
VALUETOTEXT	(2021) Returns the text from any specified value.
VSTACK	(2022) Returns the array after combining two arrays vertically in sequence.
WRAPCOLS	(2022) Returns the array transformed into multiple columns.
WRAPROWS	(2022) Returns array transformed into multiple rows.

 

[Fluff]

I tend to use Excel functions (alphabetical) - Microsoft Support
or by category Excel functions (by category) - Microsoft Support

 

[snjpverma]

Thank you for your responses. It was really helpful.

 

[Fluff]

As far as I know these functions are only available with 365

Function list.xlsx
	A
16	ARRAYTOTEXT
50	BYCOL
51	BYROW
67	CHOOSECOLS
68	CHOOSEROWS
140	DROP
160	EXPAND
172	FIELDVALUE
214	HSTACK
223	IMAGE
267	ISOMITTED
274	LAMBDA
293	MAP
386	REDUCE
402	SCAN
432	STOCKHISTORY
452	TAKE
460	TEXTAFTER
461	TEXTBEFORE
463	TEXTSPLIT
467	TOCOL
469	TOROW
483	VALUETOTEXT
492	VSTACK
500	WRAPCOLS
501	WRAPROWS
Sheet1

 

[etaf]

just an FYI
i used to use that website - but found it was not reliable - for where functions had been release in 2019 / 2021 but the site said 365, in the little note - so then had to open to actually see what versions

Note: Version markers indicate the version of Excel a function was introduced. These functions aren't available in earlier versions.

for example
FILTER
TEXTJOIN

as i dont have earlier version, i cannot check at all, and i was making sure people had the functions in the version they indicated and got caught out a few times - I think someone on one of the forums recommended the one i linked , not sure which forum

textjoin

TEXTJOIN function​

Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web Excel 2021 Excel 2021 for Mac Excel 2019 Excel 2019 for Mac Less

 

[Fluff]

Unfortunately none of the sites are that accurate & the one you linked to show that the Lambda functions were released in 2021 (which they were) but are not available in xl 2021.

 

[snjpverma]

The lists that both of you gave are almost the same. Out of that list, I found 4 functions which are mentioned above, but they are available in Excel 2021. All the other functions are indeed missing. And yes Lambda is indeed missing inspite of being released in 2021.

Below are those four functions:
Arraytotext
Fieldvalue
Stockhistory
Valuetotext

 

[Fluff]

Thanks for letting us know that.