Locate duplicates in column A, then, delete the row

[Gary]

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.

 

[Pete_UK]

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

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

There is also a short video for you to watch.

Hope this helps.

Pete

 

[Gary]

Oh, thank you so much. I really appreciate it.

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

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

There is also a short video for you to watch.

Hope this helps.

Pete

 

[Pete_UK]

You're welcome, Gary - thanks for feeding back.

Pete