Thread
:
Macro deleting row if duplicates found
View Single Post
#
2
Posted to microsoft.public.excel.programming
Dave Peterson
external usenet poster
Posts: 35,218
Macro deleting row if duplicates found
I would add a header row, then do data|filter|autofilter on that column.
Use the dropdown arrow
Contains
beta
And then delete the visible rows
Then remove the autofilter.
wrote:
Is there a macro whereby if I have a list, all in one column, but
different rows:
Column A:
Row 1: Alpha Beta Gamma
Row 2: Alpha Alpha Alpha
Row 3: Beta Gamma Gamma
Row 4: Gamma Gamma Alpha
If I wanted to delete all rows in MS Excel that have the word "Beta"
in it, I should be left with:
Alpha Alpha Alpha
Gamma Gamma Alpha
Thanks.
--
Dave Peterson
Reply With Quote
Dave Peterson
View Public Profile
Find all posts by Dave Peterson