Thread
:
Macro to lookup duplicates
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Ardus Petus
external usenet poster
Posts: 718
Macro to lookup duplicates
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
Reply With Quote
Ardus Petus
View Public Profile
Find all posts by Ardus Petus