Let's say you have a list of products with their price in an Excel table. Now you need to create bundles that may contain different products from avai...
The ranges that expand when copied in the below cells or to right cells are called expanding references. Where do we need expanding references? Well,...
In my recent article, I talked all about named ranges in excel. While exploring named ranges, the topic of dynamic ranged popped up. So in this articl...
While working or learning Excel, you’ve must hear of Relative and Absolute referencing of cells and ranges. Absolute referencing is also called lo...
In this article, we will learn about how to use the INDIRECT function in Excel. For what in Excel INDIRECT function in used Cell reference...
In this article, we will learn How to Get the Path of Current Worksheet in Excel. CELL function in Excel Cell function in Excel ge...
In this article, we will learn the random number generator in Microsoft Excel. To generate the random number, we will use the “RAND” and “RA...
In this article, we will learn How to generate random values from the given list or table column in excel. Scenario : For Instance, when wor...
VBA Distinct Random Number Generator If you want to generate random number in Excel & all the numbers should be unique (no repeat), you can use...
In this article, we will learn How to Lookup and Reference functions in Excel. If you have multiple excel tables and you want to do a dynamic V...
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.
