How to get last entry by month in Excel

In this article, we will learn How to get the last entry by month in Excel. Scenario: When working with datasets, sometimes we need to extra...

Excel increment cell reference using INDIRECT function

In this article, we will learn How to get cell reference increments using the INDIRECT function in Excel. Scenario : Working with datasets i...

How to use VLOOKUP with self contained table in Excel

In this article, we will learn How to use VLOOKUP with a self contained table in Excel. Scenario: Sometimes, when working with datasets. We ...

Get Employee Information Using VLOOKUP in Excel

To retrieve information from an employee database we can use a VLOOKUP formula. This formula will simply find the unique id and return the informa...

How to link the first match in Excel

In this article, we will learn How to link the first match in Excel. Scenario : When working with long data with links. We need to get the l...

How to find column index number from table in Excel

In this article, we will learn How to extract the column index from the table in Excel. Scenario: Many times when working with long scattere...

The Source Currently Evaluates To an Error. How to Solve it?

To solve this error, check all the named ranges and see if you have used the correct named ranges in the formula.  When you try to create a da...

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.