View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Determined07 Determined07 is offline
external usenet poster
 
Posts: 9
Default Filtering or deleting multiple rows

I'm not exactly a new user, but this is the first time in a while that I've
had to apply this knowledge to my professional duties. The spreadsheet I'm
working on is considerably large and I need to retain rows that contain
certain text or specific criteria. For example, I only need items A, C, H,
and P, and Z out of a document that has everything else (i don't need) in
between. How do I delete based on specific criteria (letter, city name,)
withouth scrolling down and sifting through it manually? Please help me.