LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 247
Default 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
 
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
I need a eqivalent for function posted here ytayta555 Excel Discussion (Misc queries) 1 April 10th 08 08:15 PM
NEED a eqivalent for this imbricate FUNCTION ! ytayta555 Excel Worksheet Functions 5 April 10th 08 06:39 PM
#VALUE! from Function()...Posted in Excel General Questions by mis pwrichcreek Excel Programming 3 March 21st 08 10:49 PM
Text Function - Custom Format ( Re-posted from Misc still looking for answer ) Ron Rosenfeld Excel Programming 0 July 29th 03 04:18 AM
Text Function - Custom Format ( Re-posted from Misc still looking for answer ) Lance[_2_] Excel Programming 1 July 29th 03 01:58 AM


All times are GMT +1. The time now is 01:54 AM.

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

About Us

"It's about Microsoft Excel"