View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Niniel Niniel is offline
external usenet poster
 
Posts: 80
Default Select rows based on keyword?

Hello,

I've been looking around a bit, but haven't found anything so maybe somebody
here has an idea.

I have a sheet with thousands of rows, and I want to delete a few hundred
based on the presence of a particular word in a specific column.
So ideally, I'll specify the word, and then all the rows get selected which
contain that word in that one column (C in my case), and I can delete all
those rows.
That may be difficult/impossible, but maybe it's easier to change the
background of the cells containing that keyword?

Any ideas would be greatly appreciated.
Thank you.