View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
dan dungan dan dungan is offline
external usenet poster
 
Posts: 411
Default How do I count the number of times a particular word is used?

If your list is in a worksheet named Company List,

Insert a new worksheet named Counted Companies, list the company names
you want to count in column A.

in column b, put this formula and copy it down to the last item in
your list:

=COUNTIF('Company List'!A1:A369,A