Locate duplicates in column A, then, delete the row
 

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.

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.

Locate duplicates in column A, then, delete the row
 

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

"Pete_UK" wrote:

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.

Locate duplicates in column A, then, delete the row
 

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

Pete

On Jun 18, 5:39*pm, Gary wrote:
Oh, thank you so much. I really appreciate it.