You could use Advanced Filter to copy a unique list which would remove all
the duplicates

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Greg" wrote in message
...
Hi,

I am trying to delete duplicate data in a column.
All of the data is in column A and has over 5000 rows.
What is unique about the data, is duplication of it is not the same,
please see the example below.

ABQ - Albuquerque, NM, USA - Albuquerque International Airport
ABQ - Albuquerque, NM, USA Albuquerque International Airport
ABR - Aberdeen, SD, USA - Aberdeen Regional Airport
ABR - Aberdeen, SD, USA Aberdeen Regional Airport
ABS - Abu Simbel, Egypt - Abu Simbel
ABS - Abu Simbel, Egypt Abu Simbel
ABX - Albury, New South Wales, Australia - Albury
ABX - Albury, New South Wales, Australia Albury

Is there a formula or macro that I can use to remove the duplicate
information where I can have a single line of data and also remove the
blank
rows that had the duplicate data?

Thanks,
Greg


--
I am always thankful for the help everyone gives me.

Virtual Cocktails for all!