Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Unique records
Hi there,
I have a list of sales orders with contact names and addresses in Excel format which I want to extract for mail shots. However within this list, I have several orders from the same contact. I obviously don't want to send a mail shot to the same guy more than once. How do I filter or using Macros to extract the unique records only. Data sample. customer contact address etc..... 123456 Bob ...... 123456 Bob ...... 654321 Pete ...... 234567 Steve ...... 234567 Steve ...... 345678 Bob ...... Many thanks Peter |
#2
|
|||
|
|||
Peter
try Data | Filter | Advanced Filter | Unique records | make copy, etc Have a look at the Help Regards Trevor "Pete" wrote in message ... Hi there, I have a list of sales orders with contact names and addresses in Excel format which I want to extract for mail shots. However within this list, I have several orders from the same contact. I obviously don't want to send a mail shot to the same guy more than once. How do I filter or using Macros to extract the unique records only. Data sample. customer contact address etc..... 123456 Bob ...... 123456 Bob ...... 654321 Pete ...... 234567 Steve ...... 234567 Steve ...... 345678 Bob ...... Many thanks Peter |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
filtering for unique records | Excel Discussion (Misc queries) | |||
Setup Unique Records | Excel Worksheet Functions | |||
Deleting specific records | Excel Discussion (Misc queries) | |||
Counting Unique Records with multiple conditions | Excel Worksheet Functions | |||
Inconsistent Results: Advanced Filter Unique Records Only | Excel Discussion (Misc queries) |