Count items in a column

  • Thread starter Thread starter Peter Nunez
  • Start date Start date
P

Peter Nunez

How can I count the number of different items in a column
and return the different counts in another column?
 
Peter,

Select your column, then choose Data | Pivot table... and drag the
button to both the row and the data areas, and you'll get a table of
unique items showing how many times each appears.

HTH,
Bernie
 
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

Count Based on Comparison with Two Fields 2
Count the columns from one sheet and paste it in another sheet 0
counting blank cells within two columns 2
Formula to count text with two conditions. 3
Counting the number of different entries in a column 2
Excel How to count from a column if specific condition in another column is true 3
Data Lookup Question 1
COUNT function 1

Back
Top