Another possibility for you to consider. First, right click the Status Bar
at the bottom of the Excel window and select Count from the list that pops
up. Next, select the range of cells that you want to search, then click
Edit/Find from Excel's Menu Bar, type the word you want to find in the "Find
what" field, click the Options button to show the full options available
(unless they are already displayed) and select whatever options you want to
apply (I'm thinking mainly of the "Match entire cell contents" option here),
then click the Find All button and press Ctrl+A, and, finally, click the
Close button. All cells with your word in them will be selected and the
count for these selected cells will be shown in the Status Bar.

--
Rick (MVP - Excel)


"Té" wrote in message
...
Is there a way to find repeated words in a spreadsheet, as well as how
many
times the word is repeated besides using the COUNTA function? I was
thinking
of filtering, and then applying the COUNTA function. Is that the easiest
way?