Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 247
Default I need a eqivalent for function posted here

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default I need a eqivalent for function posted here

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Please can someone look at question i posted yesterday jimE Excel Worksheet Functions 2 October 23rd 07 10:27 PM
How do I get back to a question I've posted? Jim Excel Discussion (Misc queries) 2 June 6th 07 04:24 PM
having items posted in one worksheet appear in another Penny Setting up and Configuration of Excel 1 January 25th 07 07:58 AM
Automation of Averages (X-posted) bachya1208 Excel Discussion (Misc queries) 4 May 1st 06 10:06 PM
Hi ..I posted some more info ..... ANDREW_B Excel Discussion (Misc queries) 1 December 2nd 04 04:08 PM


All times are GMT +1. The time now is 04:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"