Finding Duplicate Phrases in a File

I have a list of phrases in column A of my spreadsheet. I'm fairly certain
there are duplicate phrases listed and I want to find those without scrolling
thousands of rows. Is there a function that can help me find duplicate
phrases?

See Chip Pearson's site for info on duplicates.

http://www.cpearson.com/excel/duplic...tingDuplicates

At the bottom of the page is a list of links to other pages for dealing with
duplicates.


Gord Dibben MS Excel MVP

On Wed, 28 Jun 2006 14:51:02 -0700, Mis <[email protected]> wrote:

>I have a list of phrases in column A of my spreadsheet. I'm fairly certain
>there are duplicate phrases listed and I want to find those without scrolling
>thousands of rows. Is there a function that can help me find duplicate
>phrases?

Thank you!

"Gord Dibben" wrote:

> See Chip Pearson's site for info on duplicates.
>
> http://www.cpearson.com/excel/duplic...tingDuplicates
>
> At the bottom of the page is a list of links to other pages for dealing with
> duplicates.
>
>
> Gord Dibben MS Excel MVP
>
> On Wed, 28 Jun 2006 14:51:02 -0700, Mis <[email protected]> wrote:
>
> >I have a list of phrases in column A of my spreadsheet. I'm fairly certain
> >there are duplicate phrases listed and I want to find those without scrolling
> >thousands of rows. Is there a function that can help me find duplicate
> >phrases?
>
>