Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
HI ALL , and a good day
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.misc
|
|||
|
|||
![]()
You have an active thread elsewhere.
ytayta555 wrote: HI ALL , and a good day 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 | |
|
|
![]() |
||||
Thread | Forum | |||
Please can someone look at question i posted yesterday | Excel Worksheet Functions | |||
How do I get back to a question I've posted? | Excel Discussion (Misc queries) | |||
having items posted in one worksheet appear in another | Setting up and Configuration of Excel | |||
Automation of Averages (X-posted) | Excel Discussion (Misc queries) | |||
Hi ..I posted some more info ..... | Excel Discussion (Misc queries) |