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
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
No comments:
Post a Comment