Updates

2019FILTER - Returns the array of data in a range that satisfies multiple conditions.
 RANDARRAY - Returns the array of random numbers between 0 and 1.
 SEQUENCE - Returns the array of sequential numbers.
 SINGLE - Returns the value from a cell range which is the intersection of a row OR a column.
 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.
2016CONCAT - 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.
 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 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.
201350 New Worksheet Functions
201061 New Worksheet Functions
 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.
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.

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