excel seach

[Excel-lent Novice]

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?

 

[Pete_UK]

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

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

Hope this helps.

Pete