Calculating the Average Difference between List Price and Sale Price in Microsoft Excel

In this article, we will learn how to calculate the average difference between list price and sales price. We can either use the “AVERAGE” functio...

Rounding Time Intervals to the Nearest Specified Time Increment in Microsoft Excel

In this article, we will learn how to round the time intervals to the nearest specified time increment. We will use “ROUND” function in Microsoft ...

Finding the Score that Was the Nth Highest for a Specified Team in Microsoft Excel 2010

To find the nth highest score for a specified team, we can use the LARGE function to retrieve the result. LARGE: Returns the k-th largest value in ...

Find the maximum numerical value in a list based on a criteria in Excel

To find the maximum numerical value in a list based on a criteria, we can use the MAX function along with the If function in Excel. First we will lea...

Countifs Multiple Criteria in Microsoft Excel

To count based on multiple criteria we use  COUNTIFS function in Microsoft Excel. Excel function COUNTIFS  is used to count the entries in multip...

Retrieving the Value of the First Nonblank Cell in a List

To retrieve the value of the first non blank cell in a list, we will use Index and Match functions. Why and how we use Index and Match functions toge...

Ignoring Blank Cells Containing Invisible Spaces when Using Array Formulas

Problem: Columns A & B contain the number of points scored by a particular player during each quarter of a game. An empty cell indicates that ...

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