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
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
Please can anyone help.
Thanks and regards,
EskagSMS
Related:
- Count appearances of specific words in Excel
- Number to words in excel - Guide
- How to find specific words on a page - Guide
- Gif in excel - Guide
- How to count names in excel - Guide
- Excel mod apk for pc - Download - Spreadsheets
1 response
RWomanizer
Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
120
Mar 17, 2011 at 05:41 AM
Mar 17, 2011 at 05:41 AM
You can use Pivot Table to count country name.
