» Creating Progressively Incremented Counting Criteria
CATEGORY - Counting
VERSION - All Microsoft Excel Versions
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)
Book Store:
Recommended Books:
- The Fall of Advertising and the Rise of PR
- Writing Excel Macros with VBA, 2nd Edition
- The McGraw-Hill 36-Hour Course in Finance for Nonfinancial Managers
- Microsoft Access Version 2002 Step by Step
- Real Estate Finance and Investments (Real Estate Finance and Investments, 11th Ed)
- Not-for-Profit Accounting Made Easy
Yes, but ...
David J W
But how about if I want to count how many times I have changed the contents of one cell - plus the ability to reset this counter?
