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

https://docs.google.com/spreadsheets/d/1ScgC1H5FnEAw7lA8KKC0w43sbPSRw0zVkHUAVaKoDaI/edit?usp=sharing

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