Updates
Microsoft 365
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. |
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
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. |
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
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. |
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
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. |
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
ISOWEEKNUM | Returns 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
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. |
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
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. |
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
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
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