Listing & Counting Problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Function in Excel to count and list number of entries of text valuesin a row. 2
Access How to check that the value of a field in a new record is not present in 2 fields of the table? 0
Count Unique accross mulitple columns 3
Using list choices to use as headers 3
Count Unique Values 7
Lower-Case Characters 2
Counting for multiple situations 3
Copy rows if greater than zero 3

Back
Top