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. | |
| 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. | |
| 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 appliying 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. | |
| 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. | |
| 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. | |
| 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. | |
| Office 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 and satisfies multiple conditions. | |
| 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. | |
| Office 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. | |
| Office 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 - Returns the future y-value based on existing values. | |
| AutoComplete - Function autocomplete will now return any functions that contain the characters you type in. | |
| CEILING and FLOOR have been moved to Compatibility category. | |
| The Database category of functions (still) does not have its own drop-down on the Formulas tab. | |
| Office 2013 | 50 New Worksheet Functions |
| Office 2010 | 61 New Worksheet Functions |
| AGGREGATE - Returns an aggregate in a list or database. Replaces SUBTOTAL | |
| BETA.DIST has an additional parameter to specify the type of distribution (left-tailed cumulative or probability density). | |
| CRITBINOM returns the inverse of the binomial distribution but BINOM.INV is a much more intuitive name. | |
| ERF can now accept negative values. | |
| ERFC can now accept negative values. | |
| MOD can take larger input values. | |
| OFFSET arguments have different rounding. | |
| Function Renaming - A number of existing functions have been renamed for consistency. | |
| Improved Accuracy - Several of the Statistic Functions have had their accuracy improved. | |
| Asynchronous - User Defined Functions can run asynchronously without using multiple Excel calculation threads. | |
| VBA - Application.MacroOptions - ArgumentDescriptions - An additional argument has been added to the Application.MacroOptions method. It is not possible to provide argument descriptions for your User Defined Functions. | |
| Office 2007 | 12 New Worksheet Functions |
| Analysis-ToolPak Functions - All the Analysis-ToolPak functions are now standard worksheet functions and are available without having to install the Analysis-ToolPak add-in. | |
| Office 2003 | 344 Worksheet Functions |
| 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. |
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. |
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 appliying 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. |
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. |
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. |
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. |
| Office 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 and satisfies multiple conditions. |
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. |
| Office 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. |
| Office 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 - Returns the future y-value based on existing values. |
AutoComplete - Function autocomplete will now return any functions that contain the characters you type in. |
CEILING and FLOOR have been moved to Compatibility category. |
The Database category of functions (still) does not have its own drop-down on the Formulas tab. |
| Office 2013 50 New Worksheet Functions |
| Office 2010 61 New Worksheet Functions |
AGGREGATE - Returns an aggregate in a list or database. Replaces SUBTOTAL |
BETA.DIST has an additional parameter to specify the type of distribution (left-tailed cumulative or probability density). |
CRITBINOM returns the inverse of the binomial distribution but BINOM.INV is a much more intuitive name. |
ERF can now accept negative values. |
ERFC can now accept negative values. |
MOD can take larger input values. |
OFFSET arguments have different rounding. |
Function Renaming - A number of existing functions have been renamed for consistency. |
Improved Accuracy - Several of the Statistic Functions have had their accuracy improved. |
Asynchronous - User Defined Functions can run asynchronously without using multiple Excel calculation threads. |
VBA - Application.MacroOptions - ArgumentDescriptions - An additional argument has been added to the Application.MacroOptions method. It is not possible to provide argument descriptions for your User Defined Functions. |
| Office 2007 12 New Worksheet Functions |
Analysis-ToolPak Functions - All the Analysis-ToolPak functions are now standard worksheet functions and are available without having to install the Analysis-ToolPak add-in. |
| Office 2003 344 Worksheet Functions |
© 2023 Better Solutions Limited. All Rights Reserved. © 2023 Better Solutions Limited TopPrevNext