Reply
 
Thread Tools Display Modes
  #1   Report Post  
wendyp
 
Posts: n/a
Default 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   Report Post  
Martin P
 
Posts: n/a
Default

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   Report Post  
Daiya Mitchell
 
Posts: n/a
Default

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   Report Post  
Graham Mayor
 
Posts: n/a
Default

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   Report Post  
Martin P
 
Posts: n/a
Default

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   Report Post  
Daiya Mitchell
 
Posts: n/a
Default

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

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Word 2003 replaces list of tables when inserting list of figures kburns New Users 1 May 24th 05 11:00 PM
Where does word 2003 store list of words 'ignored' during spell ch Sameeksha Microsoft Word Help 2 May 11th 05 06:51 AM
How do I create a list on unique words in a document? Mark Mascaro Microsoft Word Help 0 April 20th 05 01:46 PM
Search for CAPITALIZED words? Pop New Users 2 April 11th 05 09:53 PM
Frequency count in Word mmm Microsoft Word Help 1 November 28th 04 12:44 PM


All times are GMT +1. The time now is 03:30 AM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"