View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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