Please state what you want to do without giving a formula
Tell us in words with every detail
best wishes
Thanks very much for reply BL
I work in a lotto statistic ; the game is 6/90 ; the
result of draws is in B1:BB90 ;the draw is in every column
(1 column is 1 draw );B1 mean number 1 in draw 1 , D5
mean number 5 in draw 3 , etc ;
I need to know if it wasn't in last 30 draws (columns from Y to BB)
in every draw more then 0 or 1 number ;
Actually I have in column B91:B65536 , I have 65434 Count functions ;
in every row in B column , is a combination of 15 numbers ;
I have actually 231 workbooks , it means 15,000,000 combinations of
15 numbers ;
Actually , I am doing with a VBA macro an autofill from B to BB ,
and another CountIF function in column BD ,
is showing me if last 30 draws was 0
or not much of 1 numbers;
With this formula posted here , I see in only one formula if
in last 30 draws it wasn't in every last 30 draws more then 0 or 1
number ,
and it mean for me more speed , a larger database ;
I need strongly a equivalent for this function for some reasons
I'll explain later ( I think another kind of formula will cam
be ,,made,,
more easy ! ( I have a method to do this functions with the
references
in combinatoric order ) .