Hi Domenic

I was just about to post to say that I came up with an incorrect result ,
but you beat me to it .
Your new formula works perfect all the way down to 500 rows , no errors !
You are a gentleman and genius.
Thank you very much !

regards bill
--
bill gras


"Domenic" wrote:

Bill,

The formula will return an incorrect result when a sequence does not
contain a number greater than 35. Therefore, try the following formula
instead...

=IF(ISERR(AU38),COUNTIF(AU39:INDEX(AU39:$AU$500,MA TCH(TRUE,IF(ISNUMBER(AU
39:$AU$500),AU39:$AU$50035,ISERR(AU39:$AU$500)),0 )),"<=35"),"")

....confirmed with CONTROL+SHIFT+ENTER, not just ENTER.

Hope this helps!

In article ,
bill gras wrote:

Hi Domenic
Thanks for your reply and your time , your fomula works perfect
Once again thanks
regards bill

--
bill gras