Thanks for the suggestion.

However, I would like a 'clean' list not just a filtered list so I would
prefer the lines containing duplicates to be deleted.

"Ardus Petus" wrote:

Turn on macro recorder and use DataFilterAdvanced Filter with no
Duplicates.

HTH
--
AP

"Constantly Amazed" a écrit
dans le message de news:
...
Hi

Using Excel 2000 I would like to incorporate a macro which allowed the
user
to select the first cell in any column of sorted data and then compare
each
entry and remove any duplicate lines. It would continue to do this until
the
next cell in the chosen column did not contain an entry.
ie The list
A
B
B
C
D
E
E
E

Should produce
A
B
C
D
E

I would be very grateful for assistance on this.

Regards