You can use Advanced Filter to extract duplicates - Debra Dalgleish
shows how he

http://www.contextures.com/xladvfilter01.html

Hope this helps.

Pete

On Jun 27, 9:59*pm, Excel-lent Novice <Excel-lent
wrote:
I have an excel sheet with 5000 entries - much of which are duplicates. *Is
there a way to pull only one line/name/address from each set of duplicates
without going through and doing it one by one? *