Monday, December 8, 2014

yogi_Pull From Column A Items Beginning With Entry In Cell G3 Quantities In Warehouses Specified In Cell G5

              Google Spreadsheet   Post  #1860
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Dec-08-2014
post by  Ajit Tejwani:
https://productforums.google.com/forum/#!mydiscussions/docs/a7J0mTBNUK8
Filter Data
Hello
I use following Sheet for my warehouse record


I use it frequently How Can I

1.Select Items > 0 For the selected Warehouse.
Example: W1



2.Find Item For particular Warehouse or all
Example : Item Ud For All Warehouse or Particular Warehouse.

Thanks
----------------------------------------------------------------------------------------------------------------

for the first problem one can use the FILTER command to see the results in-situ or one can use the FILTER function tp pull the results in another location

solution to the second problem is presented in the following