Hi

I need a formula where I can copy unique record from one sheet to another.

Sheet 1 - Summary
Sheet 2 - Record

In the Record sheet, I have the following:
Country Postal City
GERMANY BAUTZEN
GERMANY BERLIN
GERMANY COLOGNE
GERMANY COLOGNE
GERMANY BERLIN
GERMANY BERLIN
GERMANY BERLIN
UK LONDON
UK LONDON
UK KOENIGSWINTER
UK BREMEN
USA LONDON
USA NEW YORK

So what I need is to copy all the unique record to Summary. It should appear
like
Country Postal City
GERMANY BAUTZEN
GERMANY BERLIN
GERMANY COLOGNE
UK LONDON
UK KOENIGSWINTER
UK BREMEN
USA LONDON
USA NEW YORK

Would prefer a formula but if not available, then please advice what's the
best solution. Please note there could be over 1000 line of record in the
Record Sheet.

Thanks.
Kim