Count items in a column

P

Peter Nunez

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

Bernie Deitrick

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
 
Top