Yogi Anand, D.Eng, P.E. Google Spreadsheet Post #509 Apr 18, 2012 www.energyefficientbuild.com.
user brewcrew said:
Deleting rows based on a column containing a specific term
I have a spreadsheet contained over 3000 rows.
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
No comments:
Post a Comment