CODEWITHSUNDEEP
excelexcel-formula
zulqarnain
zulqarnain

Reputation: 1735

MS Excel count occurrences

I have excel columns as follows:

Name,Name1
Name,Name3
Name1,Name3
Name3,Name4,Name

Now I want a function that will give count of each unique name on all rows. For example output 

Name = 3
Name1 = 2
Name3 = 3
Name4 = 1

Upvotes: 0

Views: 102

Answers (2)

MLDev
MLDev

Reputation: 1277

Step 1: Select the data and use text to columns to split them into seperate columns:

enter image description here

Result:

enter image description here

Step 2

Move your data to 1 single column:

enter image description here

Step 3:

Create a pivot table

enter image description here

Though you could always use a VBA solution.

Upvotes: 1

Gary's Student
Gary's Student

Reputation: 96753

Assuming the names are spread over three columns, pick a cell and enter:

="Name = " & COUNTIF(A:C,"Name")

and then the same for the other names.

Upvotes: 1

Related Questions