Unique records

[Guest]

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

 

[Trevor Shuttleworth]

Peter

try Data | Filter | Advanced Filter | Unique records | make copy, etc

Have a look at the Help

Regards

Trevor