Inventory Allocation based on Warehouses near expiry and less Qty location

Hi all,
i need your help to identify Pick items based on near expiry and less qty location warehouses. i do on a sheet manually to present what i want. its a scenario based problem. kindly tell me if it is possible pivot table. please review the attached sheet.
i want first Qty, Location and Lot based on above criteria.
Thanks
its a duplicate thread.

https://www.excelguru.ca/forums/show...s-Qty-location

please review a file

Hi,
any help, i show you my data in sheet2 warehouse wise, but actually my data is in four sheet W1,W2,W3 and W4 but i show this as a sample because data is too large, so every one can convert this by row wise like copy this data and paste Warehouse wise, W1 data end then paste W2 data and so on. please see the new sheet.
thanks

any help please?

is here any help?

hi,
i use helper column to find out qty,lot,location and warehouse, but i did not sort expiry wise in helper column and stuck to order issuance qty. kindly help me. real data items are too much and so lengthy. please see the new sheet attached.

Hi Bo_Ry,
you are really super man of Excel. formula is working very perfect.
thousand of thanks,
kindly tell me about when i increase/decrease order quantity of a item then formula return qty 0 but next of columns formula are working. please see the attached file highlighted when qty Zero next columns will be show Zero or blank space.

kindly also tell me there are two condition apply on it first check expiry and then less qty location, if i want remove one condition less qty location, kindly show me where i have to change formula to remove less qty condition.

thanks a lot again to reply me.

Hi Bo_Ry,
Lot of thanks,
great Boss, Excellent work, real champion.
Thanks a Again.