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 arguments This function depreciates CONCATENATE Function TEXTJOIN Better than the CONCAT function (it’s strange that Microsoft …

Continue reading