NEED a eqivalent for this imbricate FUNCTION !

Y

ytayta555

HI ALL , and a good day

I have a very big need ! I have this
imbricate function :

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

{ this function shows me if the 5 COUNT imbricate functions in
AND function have the result <=1 (what I strongly need );
the problem is that I'll must do some few milions af this functions
with the reference in combinatoric order ,but this is not a
problem ,too,
(because I have a strategy to do this !) } .

what I need is a function to be eqivalent (!!) to this (!!)
function posted here
(I'm shure I'll built easyer then my actually imbricate function ).

any sugestion will be more then wellcome
 
P

Pete_UK

Instead of B1;B2;B3 you could have B1:B3 and so on for the other
ranges. Not sure what an "imbricate" function is.

Hope this helps.

Pete
 
Y

ytayta555

Excuse for my bad english first ;

I cann't to do B1:B3 because I'll have not 3 columns ,I'll
have 15 columns in every count function , and the number
of rows will be in combinatoric order ;
also , I'll have 30 count functions in AND function (not 5 like
in this example );
I post this formula here
in an easier way , but if somebody will give me an eqivalent
for this formula poasted here I'll be able to make ajustaments
for my need .


What I just need is a eqivalent for this formula , if it is posible

Thanks very much for quick reply
 
P

Pete_UK

Try to describe your data layout and explain what it is you are trying
to achieve, then someone might be able to suggest an alternative.

Hope this helps.

Pete
 
Y

ytayta555

Try to describe your data layout and explain what it is you are trying
to achieve, then someone might be able to suggest an alternative.


I have a database of 15,000,000 count functions in combinatoric
order , used for lotto statistic ;actually , i must to do an autofill
with VBA to see which combination is interesting for me ;
I have in column B the Count functions, from row 91 to row 65536
in every workbook(from 231 workbook whoch are my database);
actually , VBA is doing for me an autofill from B91 to
BB65536 ;another Countif
function is showing me if last 30 columns have the results of Count
function <=1 ;

If I have a function to have inside 30 count function (like my
function posted here now {but posted in a easyer way }),
I'll can do bigger my database , from 15,000,000 combinations to
60,000,000 combinations with the same resource system (with
a combination of another VBA macro , etc .)

My problem is the function !
(to show me in one function what
actually is showing me in 31 functions (30count + 1 countif )

The function posted here work perfecly , but I need a alternative
for this function { and , I said ,, ,I post this formula here
in an easier way , but if somebody will give me an eqivalent
for this formula poasted here I'll be able to make ajustaments
for my need . ,,, }

Thanks very much for quick help
 
Y

ytayta555

Is here any ideea more , please ?
(when I said imbricate I would say ,,combined,,
I apologise for my bad english ...)
 

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