counting data in a column

[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

 

[Don Guillett]

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)

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?

creating financial statements

 

[Gord Dibben]

See Chip Pearson's page on counting unique items in a range.

http://www.cpearson.com/excel/duplicat.htm#CountingUnique