Maximum value using IF 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 w...

Find total amount from percentage

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 about how to use Conditional formatting to Compare two arrays to show difference in excel. Conditional Formatting ...

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...

Using Worksheet Change Event To Run Macro When any Change is Made

If you are here, its probably you want to learn how to run a subroutine every time a change is made in a specific sheet. This article will teach exact...

The blue boxes represents 11th classes's statistics in all three subjects. The orange boxes are for 12th class to show the same statistics.   ...

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