excel 2016 function

  • How to use MAXIFS function in Excel 2016

    How to use MAXIFS function in Excel 2016

     maxifs function in excel is a statistical function that returns the largest value based on one or more conditions from the specified cells. maxifs function was introduced in ms excel 2016.
  • How to use the TEXTJOIN function in Excel 2016

    How to use the TEXTJOIN function in Excel 2016

     the textjoin function concatenates text from multiple ranges and / or strings, which includes a delimiter between the connected text value. if the delimiter is an empty text string, this function effectively matches the ranges.