Finding Duplicate Phrases in a File

[Guest]

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?

 

[Gord Dibben]

See Chip Pearson's site for info on duplicates.

http://www.cpearson.com/excel/duplicat.htm#HighlightingDuplicates

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


Gord Dibben MS Excel MVP

 

[Guest]

Thank you!

See Chip Pearson's site for info on duplicates.

http://www.cpearson.com/excel/duplicat.htm#HighlightingDuplicates

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


Gord Dibben MS Excel MVP