Jefferson Davis 17.Feb.12 03:45 PM a Web browser 1-2-3All ReleasesWindows XP
Hello all,
Edited on 2/18/12
Nope, @Max didn't work... Every time an @Max formula above the preceding @Max formula activated, they all changed to the same number. Still need to figure this out.
Edited on 2/17/12
Please disregard this post, I figured out that using the @MAX would work, sorry for any inconvenience...
This range is C6 to C54. It will have formulas that result in "blank" within the cells. I attempted to use: 1+@COUNTIF($C$5..$C54,">0") formula, but it can't be loaded in each of the cells because it keeps counting all of the rows in the range.
13
12
11
10
9
8
7
6
5
4
3
2
1
For instance, in the 13 cell, is there a formula that will look down and skip the empty cells until it gets to the 12 cell, then take the 12 and adds a "1" to become "13" without having all of the active cells display the same number? I expect to place an "IF" statement around the formula so that it doesn't show a count if the input cell is empty thereby hiding the formulas.
Is it possible to do this? Thanks ahead of time for any assistance.
Return to top
Counting cells using @MAX (Jefferson Davis... 17.Feb.12)
. . 
Print this page
