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!!!