Domenic Wrote:
Try...
=COUNT(1/FREQUENCY(IF(ISNUMBER(MATCH(N1:N3000,{"SE";"INC"}; 0));IF(A1:A300
0<"";A1:A3000));IF(ISNUMBER(MATCH(N1:N3000;{"SE"; "INC"};0));IF(A1:A3000<
"";A1:A3000))))
....confirmed with CONTROL+SHIFT+ENTER.
Hope this helps!
In article ,
ajajmannen
wrote:
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:N2 385,);0;IF(A1:A3000<"";A1:A
3000)))
Ok one step closer.....It counted 0......I think i know why.....I would
like to use a wildcard on the SE and INC....As all of the values in that
column either starts with SE or INC so a value can look like INC96835 or
INC99784....Is there a way to get it to match the value with either a
wildcard or by stating "starts with"?????
--
ajajmannen
------------------------------------------------------------------------
ajajmannen's Profile:
http://www.excelforum.com/member.php...o&userid=34130
View this thread:
http://www.excelforum.com/showthread...hreadid=538999