Average with multiple criteria in Excel

In this article, we will learn how to get the Average with multiple criteria in Excel. Problem? For Instance, We have a large list of data a...

How to Get Maximum Value From a List Having Errors

In this article, we will learn about how to get the Maximum score from the list having error values in Excel 2013. Scenario: For instance, we ha...

Exponents in Excel

In this article, we will learn to get exponents in Excel. In simple words, the exponent of a number is, the number of times the number gets multipl...

Calculate median with criteria

In this article, we will learn how to calculate MEDIAN with criteria in Excel. For instance, you have a large list of numbers in a data and you n...

Replace negative numbers with 0 value in Excel

In this article, we will learn about how to count valid numbers in a list in Excel. Scenario: At Instance, we need to calculate some values with f...

Average numbers if not blank in Excel

In this article, we will learn how to get the Average numbers if not blank in Excel. Problem? For Instance, We have a large list of data and we ...

Nth lowest or nth highest value in Excel

In this article, we will learn how to get Nth lowest or nth highest value in Excel. In simple words, while working with data numbers, sometimes w...

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.