Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I need a eqivalent for function posted here | Excel Discussion (Misc queries) | |||
NEED a eqivalent for this imbricate FUNCTION ! | Excel Worksheet Functions | |||
#VALUE! from Function()...Posted in Excel General Questions by mis | Excel Programming | |||
Text Function - Custom Format ( Re-posted from Misc still looking for answer ) | Excel Programming | |||
Text Function - Custom Format ( Re-posted from Misc still looking for answer ) | Excel Programming |