Let AU38 contain #VALUE!...

AV39, copied down:

=IF(1-ISNUMBER(AU38),MATCH(TRUE,INDEX(AU39:$AU$50035,0) ,0)-1,"")

Hope this helps!

In article ,
bill gras wrote:

I have in column AU cell 39 to cell 500 random sequences of 1-10 rows ,
with numbers in them, (as an result of formulas)
I need to count the number of rows in each sequence that have numbers
of 35 or less , but only up to the first number of 35 or higher. eg:-

AU result
row 39 32 3
40 14
41 19
42 107
43 11
44 21
45 #value!
46 40
47 45
48 16
49 15
50 #value!
51 29 2
52 11
53 146
54 14
55 17
56 11
57 #value!
and so on down to 500 rows

all help is appreciated

thanks
bill gras