New Functions in 2024

Excel 2024 introduced 27 new worksheet functions.

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

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