equivalent for function , please for help
 

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(D 1;D2;D3)<=1;COUNT(E1;E2;E3)<=1;COUNT(F1;F2;F3)<=1)

many thanks

equivalent for function , please for help
 

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




--
www.stfx.ca/people/bliengme


"ytayta555" wrote:

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(D 1;D2;D3)<=1;COUNT(E1;E2;E3)<=1;COUNT(F1;F2;F3)<=1)

many thanks

equivalent for function , please for help
 

On 17 Apr, 04:18, Bernard Liengme wrote:

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

equivalent for function , please for help
 

Please state what you want to do without giving a formula
Tell us in words with every detail
best wishes
--
Bernard Liengme
Microsoft Excel MVP
people.stfx.ca/bliengme
remove caps from email address



"ytayta555" wrote in message
...
On 17 Apr, 04:18, Bernard Liengme wrote:

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

equivalent for function , please for help
 

On 18 Apr, 04:12, "Bernard Liengme"
wrote:
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 ) .

equivalent for function , please for help
 

Any sugestions here , please ?