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   Dec-08-2014
post by  Ajit Tejwani:!mydiscussions/docs/a7J0mTBNUK8
Filter Data
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.


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