The functions like VLOOKUP, COUNTIF, SUMIF are called worksheet functions. Generally, the functions that are predefined in Excel and rea...
As we all know, whenever we make changes in a source data of a pivot table, it doesn't reflect immediately in the pivot table. We need to refresh ...
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...
There will be times when you want to do different tasks depending on different conditions. You would like to check different conditions if one conditi...
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...
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...
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.
