Updates


Microsoft 365

ARRAYTOTEXTReturns the contents of an array or cell range converted into text.
BYCOLReturns the results from applying a LAMBDA function to each column in an array.
BYROWReturns the results from applying a LAMBDA function to each row in an array.
CHOOSECOLSReturns the array with just a specific number of columns.
CHOOSEROWSReturns the array with just a specific number of rows.
DETECTLANGUAGE(2024) Preview. Returns the language code for the text string provided.
DROPReturns the array without certain rows or columns.
EXPANDReturns the array expanded or padded to specific dimensions.
FIELDVALUEReturns the field data from a Stocks or Geography linked data type.
GROUPBY(2023) Preview. Returns the grouping of your data along one axis and aggregates the associated values.
HSTACKReturns the array after combining two arrays horizontally in sequence.
IMAGEReturns the image from a web URL.
ISOMITTEDReturns the value True or False depending whether the value in a LAMBDA is missing.
LAMBDAReturns the results of a formula added as a named range.
MAKEARRAYReturns the array calculated by applying a LAMBDA function.
MAPReturns the array formed by applying a map using a LAMBDA function.
PIVOTBY(2023) Preview. Returns the grouping of your data along two axis and aggregates the associated values.
PY(2023) Returns the value or object after running code in a Python Editor.
REDUCEReturns the total value after reducing an array by applying a LAMBDA function.
REGEXEXTRACT(2024) Preview. Returns the characters that match the pattern provided.
REGEXREPLACE(2024) Preview. Returns the text string after replacing characters that match the pattern provided.
REGEXTEST(2024) Preview. Returns the boolean True or False depending if the pattern matches any part of a text string.
SCANReturns the array after applying a LAMBDA function to each value and returns an array.
STOCKHISTORYReturns the historical data about a financial instrument.
TAKEReturns the intersection of specific rows and columns in an array.
TEXTAFTERReturns the characters from the end of a text string after a delimiter.
TEXTBEFOREReturns the characters from the start of a text string before a delimiter.
TEXTSPLITReturns the text string split into multiple columns using delimiters.
TOCOLReturns the array transformed into a single column.
TOROWReturns the array transformed into a single row.
TRANSLATE(2024) Preview. Returns the text string translated into another language.
TRIMRANGE(2024) Preview. Returns the array after excluding all empty rows and/or columns from the outer edges of a range.
VALUETOTEXTReturns the text from any specified value.
VSTACKReturns the array after combining two arrays vertically in sequence.
WRAPCOLSReturns the array transformed into multiple columns.
WRAPROWSReturns 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.
DETECTLANGUAGE
(2024) Preview. Returns the language code for the text string provided.
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.
GROUPBY
(2023) Preview. Returns the grouping of your data along one axis and aggregates the associated values.
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.
PIVOTBY
(2023) Preview. Returns the grouping of your data along two axis and aggregates the associated values.
PY
(2023) Returns the value or object after running code in a Python Editor.
REDUCE
Returns the total value after reducing an array by applying a LAMBDA function.
REGEXEXTRACT
(2024) Preview. Returns the characters that match the pattern provided.
REGEXREPLACE
(2024) Preview. Returns the text string after replacing characters that match the pattern provided.
REGEXTEST
(2024) Preview. Returns the boolean True or False depending if the pattern matches any part of a text string.
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.
TRANSLATE
(2024) Preview. Returns the text string translated into another language.
TRIMRANGE
(2024) Preview. Returns the array after excluding all empty rows and/or columns from the outer edges of a range.
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.

Excel 2021

9 New Worksheet Functions

FILTERReturns the array of data in a range that satisfies multiple conditions.
LETReturns the result of a formula that can use variables.
RANDARRAYReturns the array of random numbers between 0 and 1.
SEQUENCEReturns the array of sequential numbers.
SORTReturns the array of data in a range that has been sorted.
SORTBYReturns the array of data in a range that has been sorted based on the values in a corresponding range.
UNIQUEReturns the array of unique values in a list, table or cell range.
XLOOKUPReturns the value in the same row after finding a matching value in any column.
XMATCHReturns the position of a value in a list, table or cell range.
FILTER
Returns the array of data in a range that satisfies multiple conditions.
LET
Returns the result of a formula that can use variables.
RANDARRAY
Returns the array of random numbers between 0 and 1.
SEQUENCE
Returns the array of sequential numbers.
SORT
Returns the array of data in a range that has been sorted.
SORTBY
Returns the array of data in a range that has been sorted based on the values in a corresponding range.
UNIQUE
Returns the array of unique values in a list, table or cell range.
XLOOKUP
Returns the value in the same row after finding a matching value in any column.
XMATCH
Returns the position of a value in a list, table or cell range.

Excel 2019

6 New Worksheet Functions

CONCATReturns the text string that is a concatenation of several strings. Replaces CONCATENATE
IFSReturns the value based on multiple conditions you specify.
MAXIFSReturns the largest value in a list or array of numbers that satisfies multiple conditions.
MINIFSReturns the smallest value in a list or array of numbers that satisfies multiple conditions.
SWITCHReturns the value based on a list of matching items.
TEXTJOINReturns the text string that is a concatenation of several strings.
CONCAT
Returns the text string that is a concatenation of several strings. Replaces CONCATENATE
IFS
Returns the value based on multiple conditions you specify.
MAXIFS
Returns the largest value in a list or array of numbers that satisfies multiple conditions.
MINIFS
Returns the smallest value in a list or array of numbers that satisfies multiple conditions.
SWITCH
Returns the value based on a list of matching items.
TEXTJOIN
Returns the text string that is a concatenation of several strings.

Excel 2016

5 New Worksheet Functions

FORECAST.ETSReturns a future value based on historical values.
FORECAST.ETS.CONFINTReturns a confidence interval for a future value.
FORECAST.ETS.SEASONALITYReturns the length of the repetitive seasonality pattern.
FORECAST.ETS.STATReturns a statistical value for a future value.
FORECAST.LINEAR(FORECAST) Returns the future y-value based on existing values.
FORECAST.ETS
Returns a future value based on historical values.
FORECAST.ETS.CONFINT
Returns a confidence interval for a future value.
FORECAST.ETS.SEASONALITY
Returns the length of the repetitive seasonality pattern.
FORECAST.ETS.STAT
Returns a statistical value for a future value.
FORECAST.LINEAR
(FORECAST) Returns the future y-value based on existing values.

Excel 2013

50 New Worksheet Functions

ISOWEEKNUMReturns the number of the ISO week of the year for a given date.
ISOWEEKNUM
Returns the number of the ISO week of the year for a given date.

Excel 2010

61 New Worksheet Functions

ASC(New) The text string converted from double byte to single byte characters.
AGGREGATEReturns an aggregate in a list or database. Replaces SUBTOTAL
DBCS(New) The text string converted from single byte to double byte characters.
ISO.CEILINGRounds a number up to the nearest integer or to the nearest multiple of significance.
ASC
(New) The text string converted from double byte to single byte characters.
AGGREGATE
Returns an aggregate in a list or database. Replaces SUBTOTAL
DBCS
(New) The text string converted from single byte to double byte characters.
ISO.CEILING
Rounds a number up to the nearest integer or to the nearest multiple of significance.

Excel 2007

12 New Worksheet Functions

AVERAGEIFReturns the average of all the numbers in a range of cells that satisfy a condition.
AVERAGEIFSReturns the average of all the numbers in a range of cells that satisfy multiple conditions.
COUNTIFSReturns the number of cells with a value that satisfy multiple conditions.
CUBEKPIMEMBERReturns a key performance indicator (KPI) property and displays the KPI name.
CUBEMEMBERReturns a member or tuple from the cube.
CUBEMEMBERPROPERTYReturns the value of a member property from the cube.
CUBERANKEDMEMBERReturns the nth or ranked member in a set.
CUBESETReturns the calculated members returned from a cube.
CUBESETCOUNTReturns the number of items in a set.
CUBEVALUEReturns an aggregated value from the cube.
IFERRORReturns a value or if that value generates an error it returns a different value.
SUMIFSReturns the total of all the numbers in a range of cells that satisfy multiple conditions.
AVERAGEIF
Returns the average of all the numbers in a range of cells that satisfy a condition.
AVERAGEIFS
Returns the average of all the numbers in a range of cells that satisfy multiple conditions.
COUNTIFS
Returns the number of cells with a value that satisfy multiple conditions.
CUBEKPIMEMBER
Returns a key performance indicator (KPI) property and displays the KPI name.
CUBEMEMBER
Returns a member or tuple from the cube.
CUBEMEMBERPROPERTY
Returns the value of a member property from the cube.
CUBERANKEDMEMBER
Returns the nth or ranked member in a set.
CUBESET
Returns the calculated members returned from a cube.
CUBESETCOUNT
Returns the number of items in a set.
CUBEVALUE
Returns an aggregated value from the cube.
IFERROR
Returns a value or if that value generates an error it returns a different value.
SUMIFS
Returns the total of all the numbers in a range of cells that satisfy multiple conditions.

The Analysis-ToolPak functions are now standard worksheet functions and are available without having to install the Analysis-ToolPak add-in.


Excel 2003

334 Worksheet Functions

BAHTTEXT(New) The number converted to a Thai text string and appends 'Baht'.
JIS(New) The text string converted from single byte to double byte characters (renamed).
PHONETIC(New) The phonetic characters from a text string.
RTD(New) The real time data from a program that supports COM.
BAHTTEXT
(New) The number converted to a Thai text string and appends 'Baht'.
JIS
(New) The text string converted from single byte to double byte characters (renamed).
PHONETIC
(New) The phonetic characters from a text string.
RTD
(New) The real time data from a program that supports COM.

Excel 1997

330 Worksheet Functions

CALL(Removed in 2003) The specification for a function or command using a registration ID.
REGISTER.ID(Removed in 2003) The result after running an Excel 4.0 Macro function.
SQL.REQUEST(Removed in 2003) The result after connecting to a data source and executes a SQL query.
CALL
(Removed in 2003) The specification for a function or command using a registration ID.
REGISTER.ID
(Removed in 2003) The result after running an Excel 4.0 Macro function.
SQL.REQUEST
(Removed in 2003) The result after connecting to a data source and executes a SQL query.

© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext