There are many ways of doing what you want to do. This is one:
Data Filter Advanced Filter Unique Records Only

Post back if you need some other ideas.

--
RyGuy


"Russell" wrote:

Hello,

I am working on a spreadsheet that contains about 150 rows of part numbers.
It is possible the rows could eventually range into the 1000s with several
hundred part numbers repeated several times.

What I am trying to do is to have 2 separate columns, one with the part
number listed only one time and the other with the number of times that part
number appears.

I understand how to make the number of times calculate using the countif
statement, but how do I get it to search the list of part numbers and extract
the number only once?

I appreciate your help!!!