View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Domenic
 
Posts: n/a
Default Count the number of unique Numbers in a column

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