Data Validation with Specific Year, Month, Day or Excel

In this article, we will learn how to validate data entries that must contain specific year, specific month or specific date using data validation i...

Return Conditional Output Using REPT Function

Yes, you read it right. The REPT function can be used to return conditional output. How? Let's see. As we know the REPT function repeats the given ...

How to Get Max If Satisfies Criteria in Excel

In this article, we will learn about how to get the maximum value if condition stands True in Excel. Scenario: In simple words, when working...

How to Find Actual Price of Discounted Price

In this article, we will learn about how to find the total amount from the percentage value in Excel. Scenario: For instance, working with p...

Get Relative COLUMN index in excel

In this article, we will learn about how to Get Relative Column index in excel. For instance, we have data and we need to mark the index for the da...

Compare two arrays to show difference in excel

In this article, we will learn how to use conditional formatting to compare two arrays to show difference in excel. Conditional Formatting in Exce...

The Do While Loop in Excel VBA

The VBA programming language supports the Do While Loop. In this article, we will learn how to use the Do While Loop in Excel VBA. The Syntax of Do...

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.

Visit Us On TwitterVisit Us On FacebookVisit Us On Youtube