Re: how do I find repeating words in a list

Tech-Archive recommends: Speed Up your PC by fixing your registry

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/

.

Relevant Pages

  • Re: how do I find repeating words in a list
    ... I was thinking of Data, Filter, Advanced Filter, but your suggestion together ... > Which features in Excel would make this any easier? ... >>> cat ... > Word FAQ: http://www.word.mvps.org/ ...
    (microsoft.public.word.docmanagement)
  • Re: Sudden Excel Problem after XP SP2 install
    ... Every product I have ever owned had good features, bad features, annoying ... Having dabbled in building code within Excel I have learned to appreciate ... >> Do a disc check and defrag ...
    (microsoft.public.excel.programming)
  • Re: The Wintard Preoccupation with Price and Marketshare
    ... never use both Excel and PowerPoint, ... They have desirable features. ... Vista is actually pushing many away, ... Can you suggest a feature in MS Office useful to enterprise and is also ...
    (comp.sys.mac.advocacy)
  • Re: Office XP Sucks ass...
    ... >>I forget the amount of feedback submitted to Microsoft on a daily ... One of the most common features ... > requested for both is more columns (Excel) or fields. ... How do they begin to interpret some of the feedback they have ...
    (microsoft.public.office.misc)
  • Re: Office XP Sucks ass...
    ... One of the most common features requested for both is ... more columns (Excel) or fields. ... For Excel, at least, it's always safest to assume Microsoft will ... >do they begin to interpret some of the feedback they have received? ...
    (microsoft.public.office.misc)