View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Don Guillett[_2_] Don Guillett[_2_] is offline
external usenet poster
 
Posts: 1,522
Default remove contain from rows B thur J

Sort or datafilterautofilterfilter for RSdelete
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"bill boch" wrote in message ...
In column A there are Two labels RW and RS....I need to remove the
contain from rows B-J labeled RS
A B C D E F G H I J K
1 RW 11 22 88 5 6 p u r l 45
2 RS 2 57 7 6 4 r l m w 50
3 RW 45 25 4 2 8 9 t w a 90

ETC...400 rows

thanks Bill


Submitted via EggHeadCafe - Software Developer Portal of Choice
Silverlight 2 Beta 2: Doing Data Part II
http://www.eggheadcafe.com/tutorials...eta-2-doi.aspx