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