Quote:
Originally Posted by ShaileshC
I have data in this format, I want to know what is the diff of quantity between warehouse and the store, storewise
Warehouse
ItemId ItemDesc StoreId Qnty
i101 ItemA str21 9
i201 itemB str21 8
i101 ItemA str25 7
i201 itemB str25 9
Store
ItemId StoreId Qnty
i101 str21 5
i101 str25 3
i201 str21 2
i201 str25 3
Thanks in advance...
|
Hi,
Could you clarify a few points...?
What you asking is for the number difference of any given item between store and warehouse? So you want to know how many more/less of each item there are in each store than there are in the warehouse?
Also, which version of Excel are you using?