As I have mentioned in many of my blogs that a SUMPRODUCT is a very versatile function and can be used for multiple purposes. In this ar...
In this article, we will learn how to find the Loser in a game of points with criteria in Excel. Scenario : Working with game data, sometimes we...
In this article, we will learn how to calculate total marks with criteria in Excel. Scenario: For instance, while working with the correct a...
In this article, we will learn how to flag the first duplicate in a range of values. Sometimes we need to identify the first duplicate from the ot...
In this article, we will learn how to use the MAX/MIN function to replace the long IF Excel formula. In simple words, while working with number...
In this article, we will learn about how to use Conditional formatting to Compare two arrays to show difference in excel. Conditional Formattin...
In this article, we will learn about how to use the IF function to put check marks in for valid inputs in Excel. The check mark option is enabled i...
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.
