close but no cigar

  • Thread starter Thread starter msmith
  • Start date Start date
M

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?
 
Did you array enter the suggestion?
Here's some more info
http://tinyurl.com/xjuu
--
Don Guillett
SalesAid Software
(e-mail address removed)
msmith said:
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??


------------------------------------------------



~~Now Available: Financial Statements.xls, a step by step guide to
Click to expand...
creating financial statements
 
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
 
Back
Top