Previous Topic Next Topic

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



Related:

1 response

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.
0

Similar discussions

Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses