Total number of things (Eg:word) in a column

R

Reana

I want to know what formula to use to find the total number of things in a
column. For example if 'Strawberry' is written in column 'J' 10 times, I want
to have a seperate page that shows that information.
 
M

Max

To get it all up at one go, try a pivot table: Insert a col label for col J,
eg: Fruit. Select col J, click Data > Pivot table & PivotChart report, click
Next > Next. Click Layout, then drag n drop Fruit into the ROW area, drag n
drop Fruit again into the DATA area (it'll appear as Count of Fruit). Click
OK, then Finish. The pivot table in the new sheet to the left should display
the desired results.
 
Top