Locate and count the recurrences of a text string

T

Trish2

I have a mutliple worksheet workbook and want to find and count the
recurrences of certain text strings but don't know how to do it.
 
M

Miguel Zapico

Use the menu edit -> find, expand the Options button to select "Workbook" in
the Within dropdown and click Find all. It will display all the cells that
contain the text and the count.
 
Top