CODEWITHSUNDEEP
excel
LewlSauce
LewlSauce

Reputation: 5872

Count occurrences in multiple rows

I have a spreadsheet with a table containing data such as:

Apple
Orange
Banana
Banana
Orange

etc. I thought I could find my solution by doing something with a Pivot Table, but I have no idea how. I'm basically trying to count the number of occurrences for each value without having to change the function for every single text I want to count the occurrences of.

Upvotes: 0

Views: 144

Answers (1)

Scott Craner
Scott Craner

Reputation: 152505

So setting up the pivot table like this did not work?:

Highlight the data

Go to INSERT ==> Pivot Table

enter image description here

I put it in C1 but you can choose where you want it.

I named the column Fruits and as you can see in the picture below it has that column name. Add the column to both the rows and the value section. If need be change the value to do the count.

enter image description here

note I would have put this in the comments but it required a picture.

Upvotes: 2

Related Questions