| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Counting specified words in a column - macro if possible
Looking to count the number of times say the following words appear in
column 1 Mouse Ant Pig Is there a code that will count each of these individually so I can then offset the results into another column? Grateful for advice John |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Counting specified words in a column - macro if possible
Hi John
=COUNTIF(A:A,"mouse") =COUNTIF(A:A,"ant") =COUNTIF(A:A,"pig") Cheers JulieD "John Hayden" wrote in message ... Looking to count the number of times say the following words appear in column 1 Mouse Ant Pig Is there a code that will count each of these individually so I can then offset the results into another column? Grateful for advice John |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| counting words | Excel Worksheet Functions | |||
| Counting words in column | Excel Worksheet Functions | |||
| Macro to Delete first words in a column | Excel Discussion (Misc queries) | |||
| how do i insert words into a column without erasing the words | Excel Discussion (Misc queries) | |||
| Searching for a words in a column from a list of words. | Excel Programming | |||
Linear Mode
