Sunday, December 7, 2014

yogi_Query Data in 'Master' And present Results By Load_No Lot_No Sale_Date City No_Shipped

              Google Spreadsheet   Post  #1859
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   Dec-07-2014
post by  KyleB73:
Help: Need to Query then Join and Sort Two columns onto new sheet
Spreadsheet needs to track initial inventory that is purchased in lots, then may be shipped to different locations at different times to a final destination. But I need to be able to track that shipment back to the initial purchase. Please help me with necessary formulas. I have master data, the results I've come up with, then desired results attached.

Thanks a ton
Attachments (1)
221 B   View   Download