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
 
Back
Top