View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
ytayta555 ytayta555 is offline
external usenet poster
 
Posts: 247
Default FUNCTION in easyer format

Thanks very much sir Joel , but , how I said :
2.)Like this doesn't help me
(COUNT(AG4:AG18)<=1;COUNT(AK4:AK18)<=1;........... .), because this
function is for exemple , I must made and built milions af this
function , with references in combinatoric order ! .............

I shall have 1;3;6 1;5;9 for eg .........for rows ; and I have
to built milions of
this kind of functions , with references in COMBINATORIC order ;nobody
could
to help me , I get some ideeas , but don't work :

=COUNT(INDEX(MATCH(ROW(B4:AH83),
{4,7,9,11,14,16,18,22,25,35,46,57,68,72,83},0)/
ISNUMBER(B4:AH83),0))

=SUMPRODUCT(ISNUMBER(MATCH(ROW(B4:AH83),
{4,7,9,11,14,16,18,22,25,35,46,57,68,72,83},0))*
ISNUMBER(B4:AH83))

=SUMPRODUCT(ISNUMBER(MATCH(ROW(B1:F5), {1,3,5},0))*(B1:F5<=1))
for this function posted of me in another thread :
=AND(COUNT(B1;B3;B5)<=1;COUNT(C1;C3;C3)<=1;COUNT(D 1;D3;D5)<=1;COUNT(E1;E3;E*
5)<=1;COUNT(F1;F3;F5)<=1)

Many thanks