Macro deleting row if duplicates found
On May 31, 11:34*am, Dave Peterson wrote:
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- Hide quoted text -
- Show quoted text -
Dave,
Thanks, that sounds like a good idea, especially for a short list.
But my lists are always more than a thousand rows, and, unless I'm
missing a step here, it would take a very long time to delete all
those rows manually, that's why I was trying to find an automated
system.
|