The Excel MINIFS Function

The Excel MINIFS function is a new function, introduced in Excel 365 and 2019. This function returns the minimum value from a given range. In this ...

10+ New Functions in Excel 2019 and 365

Excel is a great tool for reporting, analyzing, organizing and automating data. The Excel Functions help a great deal with working on data. The functi...

The Excel MAXIFS Function

The Excel MAXIFS function is a new function, introduced in Excel 365 and 2019. This function returns the MAX value from a given range. In this arti...

The Excel TEXTJOIN Function

The TEXTJOIN function is used to join text in different cells. Isn't it what CONCAT and CONCATENATE function do? Then why another function to just add...

The Excel CONCAT Function

The new Excel CONCAT function is introduced in Excel 2019 and Excel 365. The CONCAT function simply adds given strings into one, just like CONCATENATE...

Excel RANDARRAY Function

In Excel 2019 and 365 we get a new function called RANDARRAY. This is a dynamic array function that returns an array of random numbers. In Excel 2016 ...

The SORT Function in Excel

The SORT function is introduced in Excel 365 online. It is an dynamic array function that sort the given array into ascending and descending orders. T...

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Youtube