close but no cigar

[msmith]

I'm still trying to count the total number of different part numbers i
column "a". The list has duplicate part numbers, and the total I nee
is for how many different numbers in the column, excluding duplicates
The first try formula was:
=SUM(IF(COUNTIF(A1:A19,A1:A19)=0,"",1/COUNTIF(A1:A19,A1:A19)))
This first gave me a decimal, so I changed the "/" to a "*" and now i
is counting the duplicates of the first number in column "a". I fee
like I'm very close, but not quite there, since what I'm trying to d
is avoid the dupes, or count the first and skip the rest. Anybody?

 

[Don Guillett]

Did you array enter the suggestion?
Here's some more info
http://tinyurl.com/xjuu
--
Don Guillett
SalesAid Software
(e-mail address removed)

I'm still trying to count the total number of different part numbers in
column "a". The list has duplicate part numbers, and the total I need
is for how many different numbers in the column, excluding duplicates.
The first try formula was:
=SUM(IF(COUNTIF(A1:A19,A1:A19)=0,"",1/COUNTIF(A1:A19,A1:A19)))
This first gave me a decimal, so I changed the "/" to a "*" and now it
is counting the duplicates of the first number in column "a". I feel
like I'm very close, but not quite there, since what I'm trying to do
is avoid the dupes, or count the first and skip the rest. Anybody??

creating financial statements

 

[Randall Roberts]

if all your part numbers are in column a and you want a count of how
unique part numbers you have

use this formula ..adjust the range to your needs

=SUM(N(FREQUENCY(A:A,A:A)>0))

Randall