| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| delete duplicates in column not the row | Excel Discussion (Misc queries) | |||
| Locate Duplicates | Excel Worksheet Functions | |||
| How do i locate/highlight duplicates ? | Excel Discussion (Misc queries) | |||
| HOW TO LOCATE DUPLICATES ON TWO COLUMNS | Excel Discussion (Misc queries) | |||
| locate duplicates by sing conditional formatting--doesn't work for | Excel Discussion (Misc queries) | |||
Hybrid Mode
