Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I count the number of times a particular word is used?
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count how many times the same word appears in column | Excel Discussion (Misc queries) | |||
count the number of times a specific word appears in a column | Excel Worksheet Functions | |||
how do I count the number of times a word is repeated in a range? | Excel Discussion (Misc queries) | |||
Count number of times a specific number is displayed in a cell ran | Excel Worksheet Functions | |||
Count number of times a specific number is displayed in cells | Excel Programming |