Hi!!

I tried your formula but excel is complaining about the Lookup value in
the first Match formula?

When I look at the help it states that the Value I'm looking for should
be second and the Array second but I don't seem to get it right
anyway......

Please help me here
First of all I probably have a diffrent version of excel I use smicolon
instead of colon.
I tried something like this but now it stops at last parentes after the
first IF statement


=COUNT(1/FREQUENCY(IF(ISNUMBER(MATCH({"SE";"INC"};(N1:N2385 );0;IF(A1:A3000<"";A1:A3000)))
IT stops here and I don't know why??
;IF(ISNUMBER(MATCH({"SE","INC"};(N1:N2385,);0;IF(A 1:A3000<"";A1:A3000)))

=COUNT(1/FREQUENCY(IF(ISNUMBER(MATCH({"SE";"INC"};(N1:N2385 );0;IF(A1:A3000<"";A1:A3000)));IF(ISNUMBER(MATCH( {"SE","INC"};(N1:N2385,);0;IF(A1:A3000<"";A1:A300 0)))


--
ajajmannen
------------------------------------------------------------------------
ajajmannen's Profile: http://www.excelforum.com/member.php...o&userid=34130
View this thread: http://www.excelforum.com/showthread...hreadid=538999