counting data in a column

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

msmith

I have a column of part numbers that include duplicates. What I need i
to count the number of different part numbers, avoiding duplicates, an
display the total in a cell. What is the formula for this
 
Bob Umlas posted this today on the G list
=SUM(IF(COUNTIF(B1:B19,B1:B19)=0, "", 1/COUNTIF(B1:B19,B1:B19)))

--
Don Guillett
SalesAid Software
(e-mail address removed)
msmith said:
I have a column of part numbers that include duplicates. What I need is
to count the number of different part numbers, avoiding duplicates, and
display the total in a cell. What is the formula for this?


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



~~Now Available: Financial Statements.xls, a step by step guide to
Click to expand...
creating financial statements
 
Back
Top