View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default Locate duplicates in column A, then, delete the row

You can do this using Advanced Filter - Debra Dalgleish shows you how
to do this he

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

There is also a short video for you to watch.

Hope this helps.

Pete

On Jun 18, 4:45*pm, Gary wrote:
Have a large name and address list; I want to locate duplicates based on
"NAMES," or 'TAX ID NUMBERS," *then delete the duplicate row records
(leaving, of course, one record to use for the mailing).
Thanks so much.