Multi Conditional Vlookup in Excel

Vlookup function in Excel is one of the most used functions. In this article, we will learn how to use Vlookup with multiple criteria.   Question: ...

Remove Duplicates in List through Formula

How to extract unique values through Excel formula? To count the unique values from a list, we use the IF function along with  the COUNTIF functi...

ISERROR Function in Microsoft Excel

In this article, we will know about ISERROR excel formula in Microsoft Excel. ISERROR- This function is used for checking whether a value is an err...

SUMIF Multiple Condition in Excel 2013

In Excel, we can make so many calculations using excel SUMIF formula. In this article, we will learn Excel SUMIF function, meeting multiple criteria i...

Sum the largest two numbers in range in Microsoft Excel 2010

In this article, we will learn how to sum the largest two numbers in a range in Microsoft Excel 2010.   In order to calculate the sum of tw...

Sum by color using VBA in Microsoft Excel

In this article, we will create a custom function to calculate the sum of numbers in cells in the range having defined color. For this example, sampl...

Simplifying Formulas by Reducing the Complexity of IF Functions in Microsoft Excel 2010

In this article, we will learn simplifying formulas by reducing the complexity of IF functions in Microsoft Excel 2010. While working on NESTED IF ...

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 Google PlusVisit Us On Youtube