ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   i need a eqivalent for this posted function (https://www.excelbanter.com/excel-programming/409146-i-need-eqivalent-posted-function.html)

ytayta555

i need a eqivalent for this posted function
 
HI ALL

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

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

{ this function shows me if every of the 5 COUNT combined 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 combined function ).

any sugestion will be more then wellcome

Dave Peterson

i need a eqivalent for this posted function
 
You have an active thread elsewhere.

ytayta555 wrote:

HI ALL

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

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

{ this function shows me if every of the 5 COUNT combined 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 combined function ).

any sugestion will be more then wellcome


--

Dave Peterson


All times are GMT +1. The time now is 10:48 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com