Wednesday, March 21, 2012

yogi_Filter Numbers In A Column Which Contains Both Text And Numbers

Yogi Anand, D.Eng, P.E.                Google Spreadsheet          Post  #477         www.energyefficientbuild.com

user imonion said: 
FILTERING NUMBERS IN A COLUMN WHICH CONTAINS BOTH TEXT AND NUMBERS Hello, 
 I have a spreadsheet with a column that contains data like this:  
A1 MERINO SOCK 
A2 0 
A3 MERINO/NYLON SOCK 
A4 0 
A5 BFL SOCK 
A6 0 
A7 MCN SOCK 
A8 2 
A9 SPARKLE SOCK 
A10 0 
A11 GAIA SPORT 
A12 0 
A13 GAIA WORSTED 
A14 5 
A1 is a product, A2 is the quantity of that product that has been ordered. I would like to filter out the products that have a quantity of zero. I am trying to create a packing list of sorts that only lists products with quantities >0. 
Thanks. 
---------------------------------------------
 Following is a solution to the problem