The SEQUENCE Function in Excel

To get a sequence of numbers we used to use a combination of functions but now MS has provided one function for getting sequential numbers. The SEQUE...

How to Use Excel SORTBY Function

The SORTBY Function of Excel can return a sorted array by another independent array. You can add levels of sorting. In other words you can sort arra...

How to Use The Excel UNIQUE Function

Earlier in Excel 2016 and older versions we used complex formulas to extract unique values from a range. In Excel 365 online version, MS provides a ...

How to Use The Excel FILTER Function

The excel FILTER function simply returns the filtered data from given range. It is a functional version of simple filtering from the home menu that we...

How to use the SWITCH function in Excel 2019

In this article, we will learn about how to use the SWITCH function in Excel. The SWITCH function returns the result based on some condition. This ...

How to use the IFS Function in Excel 2019

In this article, we will learn about how to use IFS function in excel 2019. This function doesn’t work in Excel 2016 and lower versions. IFS func...

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