Excel 2007 : Automatically counting items in a list

**Matt Neuteboom** · 09-17-2010, 09:43 AM

For the past week or so I've been compiling a list of part numbers for my boss for a number of modules that need to be built for a project we have. However, now that we have the part numbers, we need to tally them up so we know the total number of each part to order. There are several hundred parts listed, many of which are standard parts that repeat themselves throughout the list. I could use a COUNTIF function with the text string of each individual P/N (since each P/N is unique to that part), but doing this for several hundred parts, even if many are repeated, would probably take hours. Is there a simple way for Excel to simply take a column of data and automatically count the instances of each entry? The person who posts a good solution wins +100 internets, and my hearfelt thanks.

**royUK** · 09-17-2010, 09:46 AM

maybe a PivotTable, depending on the data layout

Which version of Excel?

**Matt Neuteboom** · 09-17-2010, 09:54 AM

2007, though I thought that might have been implied by the forum under which I am posting =D

Unless you meant something esle by version?

**royUK** · 09-17-2010, 10:04 AM

Don't always see which Forum it is, it's more obvious if you complete your User profile

Put Part # in Row labels
Also in Values - Count of

**Matt Neuteboom** · 09-17-2010, 10:37 AM

Ah, my apologies.

How do I put Count Of in the values section?

**royUK** · 09-17-2010, 10:40 AM

Just Drag part # into the Values section

**Matt Neuteboom** · 09-17-2010, 11:01 AM

Wow! Perfect! Thank you so very much good sir, you're 100 free internets should be arriving in the mail in 4-5 business days. Have a great day!

**royUK** · 09-17-2010, 11:07 AM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save