Domenic Wrote:
Try the following formula instead...

=COUNT(1/FREQUENCY(IF((LEFT(N1:N3000;2)="SE")+(LEFT(N1:N300 0;3)="INC");IF
(A1:A3000<"";A1:A3000));IF((LEFT(N1:N3000;2)="SE" )+(LEFT(N1:N3000;3)="IN
C");IF(A1:A3000<"";A1:A3000))))

....confirmed with CONTROL+SHIFT+ENTER.

Hope this helps!

In article ,
ajajmannen
wrote:

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"?????


I must say many thanks for all the help.....But It still counts it to 0
and I know that it should be around 700 entries at least.

Please help out.....I don't know what more information to give to be
able to get the correct formula.


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