View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] theiliad2000x@yahoo.com is offline
external usenet poster
 
Posts: 4
Default Macro deleting row if duplicates found

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.