Hi Aladin
No . What I'm saying is that number 3 should be the only number (where it is)
and no number 2 because 107 is greater than 35 and that should be the cut off
point , there fore the next sequence should start after the #value! in
column AU45 . So the next sequence starts at AU 46 where the first number is
greater than 35 and that is the cut off point (no result) . The next sequence
starts at AU 51 after the #value! in AU50 and number 2 is correct , the cut
off point is at AU53 which the number is 146 so no number 3 . The next
sequence starts at AU58 after the #value! of AU57.

I hope this will help , please don't give up
thanks bill
--
bill gras


"Aladin Akyurek" wrote:



bill gras wrote:
Hi Aladin,
Thank you for your time and your reply
There is one thing that your formula does not do is: count all numbers under
35 , stop at the first number larger than 35 and than go to the next sequence
, and count
all numbers under 35 stop at the first number larger than 35 and than go to
the next
sequence , and so on .
Can that be done ?
I apologise if I did not explained my self properly the first time .
as per your formula :-
-- AU

row 39 32
40 14
41 19 3
42 107
43 11
44 21 2
45 #value!
46 40
[...]

Are you trying to say that 3 should appear at the same row as 107 and 2
at the same row as 40?