February 2016 archive

New functions of Excel 2016

Function MAXIFS

With the new release of Excel 2016, six new very interesting functions have been added in three libraries. Library Text Function CONCAT Combines the text from multiple ranges and/or strings, but it doesn’t provide the delimiter or ignore empty argumentsThis function depreciates CONCATENATE Example of the function CONCAT – No delimiter between each cells Function …

Continue reading