Create VBA Function to Return Array

As the title suggests, we will learn how to create a user-defined function in Excel that returns an array. We have already learned how to create a...

Return An Array Using in Excel Using INDEX Function

For any reason, if you want to do some operation on a range with particular indexes, you will think of using INDEX function for getting array of value...

How to Convert Number to Words in Excel in Rupees

Excel does not provide any default function that converts a number or amount in words in Indian rupees or any currency. But it doesn't mean that w...

Sum by OFFSET groups in Rows and Columns

In this article, we will learn how to Calculate Sum by groups in Rows and Columns in Excel. For Instance, you have a large list of data and you nee...

Calculate median with criteria

In this article, we will learn how to calculate MEDIAN with criteria in Excel. For instance, you have a large list of numbers in a data and you n...

How to Get Average if Matches Month

In this article, we will learn how to get the average of matched months only in Excel. For instance, you have a large list of data and you need...

How to use the FORMULATEXT Function in Excel

In this article, we will learn the function FORMULATEXT in Excel.  FORMULA values in cell is the value returned by the formula. In Excel when ther...

Custom Excel XLOOKUP Function

The XLOOKUP function is exclusive to the insider program of office 365. The LOOKUP function has many functionalities that overcome many of the weaknes...

Extract Unique Values in Excel using one function

In our previous articles, we have learned how to extract unique values from a range using a combination of different excel functions. Although the...

How to Find Nth Occurrence in Excel

With VLOOKUP we always get the first match. The same happens with the INDEX MATCH function. So how do we VLOOKUP second match or 3rd or nth? In this a...

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.