Count appearances of specific words in Excel

Solved/Closed

eskagsms

Posts: 24
Registration date: Wednesday February 9, 2011
Status: Member
Last seen: May 30, 2012

- Mar 17, 2011 at 01:55 AM
RWomanizer

Posts: 365
Registration date: Monday February 7, 2011
Status: Contributor
Last seen: September 30, 2013

- Mar 17, 2011 at 05:41 AM

Hello, I have a spread sheet with names of countries in the first column and over 1300 lines of text in the second column. I want to count number of times each country name (from column A) appears in the text (in column B). The countif function did not work and is returning all zeroes.

Please can anyone help.

Thanks and regards,

EskagSMS

Count appearances of specific words in Excel
How to count specific names in excel - Guide
Macro to extract specific data from excel - Forum - Excel
How to calculate 90 days from a specific date in excel - Guide
How to copy specific data in excel to another sheet - Guide
How to Lock or password protected specific cell in excel 2010 ✓ - Forum - Excel

1 reply

Answer 1 / 1

RWomanizer

Posts: 365
Registration date: Monday February 7, 2011
Status: Contributor
Last seen: September 30, 2013

120
Mar 17, 2011 at 05:41 AM

You can use Pivot Table to count country name.

Subscribe To Our Newsletter!