Macro to lookup duplicates
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
|