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...
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...
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...
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...
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...
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...
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...
The XLOOKUP function is exclusive to the insider program of office 365. The LOOKUP function has many functionalities that overcome many of the weaknes...
In our previous articles, we have learned how to extract unique values from a range using a combination of different excel functions. Although the...
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...
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.
