Thread: Row Count...
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
fzl2007 fzl2007 is offline
external usenet poster
 
Posts: 23
Default Row Count...

I want to count the rows bottom up for a column value. As soon as the
sign is changed or the number is the value of a zero, counter finishes
counting. Ex,
-2.1
0.3
-1.1
44
13.1
12.2
counter x = 3

31.2
44.8
9.4
10.4
-2.2
-11.1
counter x = 2

5.3
9
0
3.2
counter x = 1

Thanks.