Wednesday, April 18, 2012

yogi_Extract Rows That Do Not Contain A Specific Term

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #509    Apr 18, 2012

user brewcrew said:
Deleting rows based on a column containing a specific term
I have a spreadsheet contained over 3000 rows. 
My rows look like this
brewery          item code           description
dogfish          000001              dog-btl 
dogfish          000001              dog-6pk
dogfish          000001              dog-case
flying dog       000002              flyingdog-6pk
flying dog       000002              flyingdog-btl 
flying dog       000002              flyingdog-case 
ommegang         0000003             ommegang-6pk 
ommegang         0000003             ommegang-btl 
ommegang         0000003             ommegang-case 
I want to delete all rows that contain 6pk in the description column. I am new to the the google functions and having trouble figuring out how to write a formula to do this. can anyone help?
following is a solution to the problem