Counting specified words in a column - macro if possible

  • Thread starter Thread starter John Hayden
  • Start date Start date
J

John Hayden

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
 
Hi John

=COUNTIF(A:A,"mouse")
=COUNTIF(A:A,"ant")
=COUNTIF(A:A,"pig")

Cheers
JulieD
 
You must log in or register to reply here.

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

VBA set thick borders around non empty cells in range 0
Count how many instances of an item appear in a range 2
Count occurrences of filename in column 5
Counting rows in a column 5
Count the columns from one sheet and paste it in another sheet 0
Text To Column max 26 characters 7
Turning column count into a Column Letter 4
Import multiple workbooks to current workbook in specified row number 0

Back
Top