Updates
Microsoft 365
| COPILOT | Returns the response based on your referenced data using an AI model. |
| DETECTLANGUAGE | Returns the language code for the text string provided. |
| GROUPBY | Returns the summary table after grouping and aggregating by row. |
| PERCENTOF | Returns the percentage that a subset makes up from a given data set. |
| PIVOTBY | Returns the summary table after grouping and aggregating by row and column. |
| PY | Returns the value or object after running code in a Python Editor. |
| REGEXEXTRACT | Returns the characters that match the pattern provided. |
| REGEXREPLACE | Returns the text string after replacing characters that match the pattern provided. |
| REGEXTEST | Returns the boolean True or False depending if the pattern matches any part of a text string. |
| TRANSLATE | Returns the text string translated into another language. |
| TRIMRANGE | Returns the array after excluding all empty rows and/or columns from the outer edges of a range. |
| COPILOT Returns the response based on your referenced data using an AI model. |
| DETECTLANGUAGE Returns the language code for the text string provided. |
| GROUPBY Returns the summary table after grouping and aggregating by row. |
| PERCENTOF Returns the percentage that a subset makes up from a given data set. |
| PIVOTBY Returns the summary table after grouping and aggregating by row and column. |
| PY Returns the value or object after running code in a Python Editor. |
| REGEXEXTRACT Returns the characters that match the pattern provided. |
| REGEXREPLACE Returns the text string after replacing characters that match the pattern provided. |
| REGEXTEST Returns the boolean True or False depending if the pattern matches any part of a text string. |
| TRANSLATE Returns the text string translated into another language. |
| TRIMRANGE Returns the array after excluding all empty rows and/or columns from the outer edges of a range. |
Excel 2024
| 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. |
| 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. |
| 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. |
| 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
| ARRAYTOTEXT | Returns the contents of an array or cell range converted into text. |
| 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. |
| VALUETOTEXT | Returns the text from any specified value. |
| 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. |
| ARRAYTOTEXT Returns the contents of an array or cell range converted into text. |
| 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. |
| VALUETOTEXT Returns the text from any specified value. |
| 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
| CEILING.MATH | Returns the number rounded up to the nearest integer or significant figure (including negative). |
| DAYS | Returns the number of days between two dates. |
| ENCODEURL | Returns the url encoded string. |
| FILTERXML | Returns the specific data from the xml content by using xpath. |
| FLOOR.MATH | Returns the number rounded down to the nearest integer or significant figure (including negative). |
| FORMULATEXT | Returns the formula from a particular cell. |
| IFNA | Returns the value or something else if it evaluates to #N/A. |
| ISOWEEKNUM | Returns the number of the ISO week of the year for a given date. |
| SHEET | Returns the sheet number of the referenced sheet. |
| SHEETS | Returns the number of sheets in a reference. |
| WEBSERVICE | Returns the results from a webservice. |
| CEILING.MATH Returns the number rounded up to the nearest integer or significant figure (including negative). |
| DAYS Returns the number of days between two dates. |
| ENCODEURL Returns the url encoded string. |
| FILTERXML Returns the specific data from the xml content by using xpath. |
| FLOOR.MATH Returns the number rounded down to the nearest integer or significant figure (including negative). |
| FORMULATEXT Returns the formula from a particular cell. |
| IFNA Returns the value or something else if it evaluates to #N/A. |
| ISOWEEKNUM Returns the number of the ISO week of the year for a given date. |
| SHEET Returns the sheet number of the referenced sheet. |
| SHEETS Returns the number of sheets in a reference. |
| WEBSERVICE Returns the results from a webservice. |
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. |
| RANK.AVG | Returns the rank of a value in descending order (average ranking). |
| 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. |
| RANK.AVG Returns the rank of a value in descending order (average ranking). |
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.
link - learn.microsoft.com/en-us/previous-versions/office/developer/office-2007/bb277364(v=office.12)
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. |
© 2025 Better Solutions Limited. All Rights Reserved. © 2025 Better Solutions Limited TopPrevNext