How do I count the number of times a particular word is used?

M

markythesk8erboi

My question is in column (B) I have many different names of companies and
there are also blank cells. I want to know if I can have a count of how many
times each name has appeared into a seperate worksheet. For example: B1 = ABC
Co.

B2 = Fish inc.

B3 = ABC Co.
So in sheet number 4 I want a list that says something like ABC Co. 2,

Fish inc. 1.
Please remember also that there are MANY different names but only about a
dozen that I want for this count.
 
D

dan dungan

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to count the numbers in a Word document? 0
Counting the Number of times the Slides are visited 0
Quickly count used rows? 5
Is there a function to count how many times a cells value is used? 0
Count occurances in a range. 5
Count unique with multiple criteria 3
How to count rows with text 2
Counting the number of times a character occurs in a cell 1

Top