Craig

asked on

# Count the number of times each word in a column appears

Hi all,

Hoping someone can guide me with what I thought would be a straightforward Excel calculation:

Say I have a column containing 10,000 first names. I want to have Excel count how many times each name appears and have that count appear in another column.

Can someone point me to the simplest solution?

Thanks!

Hoping someone can guide me with what I thought would be a straightforward Excel calculation:

Say I have a column containing 10,000 first names. I want to have Excel count how many times each name appears and have that count appear in another column.

Can someone point me to the simplest solution?

Thanks!

ASKER

Thanks Subodh. Do I have to identify each criterion (that is, go through the entire column to identify each name that appears)?

ASKER CERTIFIED SOLUTION

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds.

**No credit card required.**ASKER

Subdoh,

I got it using the Pivot Table option!

Thanks much!

I got it using the Pivot Table option!

Thanks much!

You're welcome again Craig!

Great! Pivot Table was most suitable for this scenario.

Thanks for the testimonial and feedback Craig!

Great! Pivot Table was most suitable for this scenario.

Thanks for the testimonial and feedback Craig!

In B2 (or in some other cell in row2)

Open in new window

and then copy it down.Otherwise, you can simply insert a Pivot Table and drag the First Name field in the Row Area and drag the First Name field again in the Values Area.