Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,718
Default duplicate

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
"amie etincelle" <amie wrote in message
...
| 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?


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
duplicate name help please Terry Excel Worksheet Functions 9 February 20th 08 03:52 PM
Duplicate Look up Excel Crazy New Users to Excel 1 November 15th 06 02:35 AM
How do you delete duplicate addresses, but keep duplicate names? Shelly Excel Discussion (Misc queries) 1 August 28th 06 10:36 PM
duplicate Metalteck Excel Discussion (Misc queries) 2 May 11th 05 10:04 PM
Duplicate Bottle Excel Worksheet Functions 3 April 14th 05 04:57 PM


All times are GMT +1. The time now is 11:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"