### 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.