duplicate

A

amie etincelle

how do I go about finding if there are many words that come back up more than
once in the text? without using the find option. Let's say that I do not know
which word might come up more than once, and I want to discover which ones
do, how do I do that?
 
J

Jim Rech

If you're talking about a list of words then you could use Data, Filter,
Advanced Filter to get a list of the unique words. Then you could use the
Countif to determine how many there are of each.

If you're talking about analyzing paragraphs of text there is nothing built
into Excel to do this that I know of.

--
Jim
| how do I go about finding if there are many words that come back up more
than
| once in the text? without using the find option. Let's say that I do not
know
| which word might come up more than once, and I want to discover which ones
| do, how do I do that?
 
Top