Calculating the Average Growth of a Child

Problem: A child's height has been measured once a year. Columns A & B show the results of these measurements for a period of six years. We w...

Checking for Sequences within a Sorted List

Problem: List1 (column A) is a series of numbers that has been sorted in ascending order. We want to create a formula that will check whether each n...

Creating a List of All Non-Blank Cells in a Column in Microsoft Excel

In this article, you’ll learn how to create a list of non-blank cells in a column in Microsoft Excel. To solve this problem, we will use IF, INDEX, ...

Find the minimum positive value in Microsoft Excel

In this article, we are going to learn how to find the minimum positive value in a range in Microsoft Excel. To return the positive minimum value from...

Array Formulas in Excel 2007

Understanding Arrays For those who do not have a background in programming or mathematics, the expression Array may not be familiar. So what exac...

Calculating the Average Value in Every Nth Column, Excluding Zeros

Problem: Row 2 contains numeric values, with their matching serial numbers shown in row 1. We want to calculate an average of the values from ever...

Checking for the Presence of Specified Values Within a Range in Microsoft Excel

To check for the presence of specified values within a range, we can use the AND function along with the COUNTIF function in Microsoft Excel. COUNTIF...

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