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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

markythesk8erboi - 20 Mar 2008 23:16 GMT

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.

Reply to this Message

dan dungan - 21 Mar 2008 00:11 GMT

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

Reply to this Message

Barb Reinhardt - 21 Mar 2008 00:16 GMT

Have you tried using the COUNTIF function?

Signature

HTH,
Barb Reinhardt

> 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
[quoted text clipped - 9 lines]
> Please remember also that there are MANY different names but only about a
> dozen that I want for this count.

Reply to this Message