| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
how do I find repeating words in a list
how do I find repeating words in a list. It would look like this
cat dog horse goat bird cat snake I want a way to delete or find the second cat because it is repeated. |
|
#2
|
|||
|
|||
|
Copy to Excel and use Excel's features.
"wendyp" wrote: how do I find repeating words in a list. It would look like this cat dog horse goat bird cat snake I want a way to delete or find the second cat because it is repeated. |
|
#3
|
|||
|
|||
|
Which features in Excel would make this any easier?
You can use Table | Sort (even if the list is not a table) and it will alphabetize the list, putting all the duplicates together. On 6/2/05 1:52 PM, "Martin P" wrote: Copy to Excel and use Excel's features. "wendyp" wrote: how do I find repeating words in a list. It would look like this cat dog horse goat bird cat snake I want a way to delete or find the second cat because it is repeated. -- Daiya Mitchell, MVP Mac/Word Word FAQ: http://www.word.mvps.org/ MacWord Tips: http://www.word.mvps.org/MacWordNew/ What's an MVP? A volunteer! Read the FAQ: http://mvp.support.microsoft.com/ |
|
#4
|
|||
|
|||
|
Then use replace to remove the duplicates -
http://www.gmayor.com/replace_using_wildcards.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Daiya Mitchell wrote: Which features in Excel would make this any easier? You can use Table | Sort (even if the list is not a table) and it will alphabetize the list, putting all the duplicates together. On 6/2/05 1:52 PM, "Martin P" wrote: Copy to Excel and use Excel's features. "wendyp" wrote: how do I find repeating words in a list. It would look like this cat dog horse goat bird cat snake I want a way to delete or find the second cat because it is repeated. |
|
#5
|
|||
|
|||
|
I was thinking of Data, Filter, Advanced Filter, but your suggestion together
with that of Graham Mayor could be better. The Excel method comes in handy if, for any reason, the original order should be kept. "Daiya Mitchell" wrote: Which features in Excel would make this any easier? You can use Table | Sort (even if the list is not a table) and it will alphabetize the list, putting all the duplicates together. On 6/2/05 1:52 PM, "Martin P" wrote: Copy to Excel and use Excel's features. "wendyp" wrote: how do I find repeating words in a list. It would look like this cat dog horse goat bird cat snake I want a way to delete or find the second cat because it is repeated. -- Daiya Mitchell, MVP Mac/Word Word FAQ: http://www.word.mvps.org/ MacWord Tips: http://www.word.mvps.org/MacWordNew/ What's an MVP? A volunteer! Read the FAQ: http://mvp.support.microsoft.com/ |
|
#6
|
|||
|
|||
|
Ah, thanks. I'm not very knowledgeable in Excel.
On 6/3/05 11:25 AM, "Martin P" wrote: I was thinking of Data, Filter, Advanced Filter, but your suggestion together with that of Graham Mayor could be better. The Excel method comes in handy if, for any reason, the original order should be kept. "Daiya Mitchell" wrote: Which features in Excel would make this any easier? You can use Table | Sort (even if the list is not a table) and it will alphabetize the list, putting all the duplicates together. On 6/2/05 1:52 PM, "Martin P" wrote: Copy to Excel and use Excel's features. "wendyp" wrote: how do I find repeating words in a list. It would look like this cat dog horse goat bird cat snake I want a way to delete or find the second cat because it is repeated. |
| Reply |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Word 2003 replaces list of tables when inserting list of figures | New Users | |||
| Where does word 2003 store list of words 'ignored' during spell ch | Microsoft Word Help | |||
| How do I create a list on unique words in a document? | Microsoft Word Help | |||
| Search for CAPITALIZED words? | New Users | |||
| Frequency count in Word | Microsoft Word Help | |||
Linear Mode
