|  

» Creating Progressively Incremented Counting Criteria

CATEGORY - Counting VERSION - All Microsoft Excel Versions
Problem:

Create a new list in column B where the first value is the number of values in List1 (column A) that are smaller than 1, the second value is the number of values in List1 smaller than 2, and so on.

Solution:

Use the COUNTIF and ROW functions as shown in the following formula in the first cell (B2) of the new list, and copy the formula down the column:
=COUNTIF($A$2:$A$6,"<"&ROW()-ROW($B$2)+1)


Rate This Tip
12 34 5
Rating: 3.00     Views: 15968
No comments have been submitted.
Name
Comment Title
Comments