equivalent for function , please for help

Y

ytayta555

Good night

I need strongly an equivalent for this function ,
how is it posted here , but better with another
functions :

=AND(COUNT(B1;B2;B3)<=1;COUNT(C1;C2;C3)<=1;COUNT(D1;D2;D3)<=1;COUNT(E1;E2;E3)<=1;COUNT(F1;F2;F3)<=1)

many thanks
 
B

Bernard Liengme

=AND(COUNT(B1:B3)<2;COUNT(C1:C3)<2;COUNT(D1:D3)<2;COUNT(E1:E3)<2;COUNT(F1:F3)<2)
Has 20 fewer keystrokes.
 
Y

ytayta555

Thanks very much Bernard

, but I shall have in a only AND function
30 count functions , and every of this count functions
shall have 15 arguments in combinatoric order !

{(B1:B3) , (C1:C3) , don't help me very much , sorry ....}
I am looking for a formula to give me the same result with
this formula , I mean to be 30 COUNT functions and another function
to
show me if every conditions is true for the each 30 count functions ;

Thanks again
 
B

Bernard Liengme

Please state what you want to do without giving a formula
Tell us in words with every detail
best wishes
 
Y

ytayta555

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 ) .
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top