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

I would create a new column with 1 on each row. Then I would use the pivot
table function that will sum the values in this new column, per part number.

Stephane Quenson.

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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200708/1