# 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 365ARRAYTOTEXT - 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 2021FILTER - 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 2019CONCAT - 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 2016FORECAST.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 201350 New Worksheet Functions |

Office 201061 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 200712 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 2003344 Worksheet Functions |

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