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



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

How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Counting cells containing only numbers
jutulu -
jutulu -

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

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

1 response
Excel if range of cell contain a text put a cell value in
diegomagum -
TrowaD -

11 responses