Re: Re-allocation
Thank you sooooooooooooooo much....
Re: Re-allocation
Thank you sooooooooooooooo much....
forum.ozgrid.com/index.php?attachment/36620/Hi peeps
Need a bit of help here.... this is my table in Excel (see attachment). Delivery Cycle is usually the same so don't need to update that one. I will be updating "Q in container". So lets say I am getting 100 products in the container. Stores 1-9 placed their orders (see "Q on order" in left table). As you can see in the second table the sum is 76 but I am getting 100 pieces in the container. So I need to re-allocate the rest of them (29 pieces). I want to do this based on who needs it most! "Q more required" in the second table tells for how much managers under or over-ordered.
Please help me with which formula I can use to re-allocate the "rest of the stock" between the stores that need it most.
This has to work in cases if I over-order so I can re-allocate the stock or underorder to see which manager will need more stock so I can place another order.
Thank you sooooooooooooo much!!!!!! forum.ozgrid.com/index.php?attachment/36619/
Re: Cross checking 2 tables
Please help?
I have been trying to use IF and LOOKUP functions but its not working
Re: Cross checking 2 tables
Hi there.
Firstly thank you so much for helping me out.
So this is what I have done...
1. I have put both columns that have Product ID codes next to each other
2. deleted duplicates using Advanced filter /unique thingy
3. used =IF(COUNTIF($A$2:$A$932,$B2),$B2,"") to see if which ID codes from exSheet2 have a match with exSheet1
4. used =IF(COUNTIF($B$2:$B$1114,A2),VLOOKUP(A2,$B$2:$B$1114,1),"") to adjust the exSheet2 codes in the same rows where exSheet1 codes are.
Now i'm left with adjusting Quantities and LCs to the ID codes that are in step 4....
Anyone??? pweeze??
Re: Cross checking 2 tables
This is how it looks (see attachment)...
I really want to learn how to do this as I will be cross checking a lot of spread sheets in the future.
Thank you for your help - will be more then welcome! forum.ozgrid.com/index.php?attachment/35753/
Hi everyone! I need help with this... BADLY!
I have two sheets (sheet1 and sheet2).
Sheet1 has Column2 with "product ID codes"
Sheet2 has Column1 with "product ID codes", Column2 with Quantity, Column3 with Costs
BUT: there are some "product ID codes" from sheet1 that I dont have on sheet2 and vice versa.
What I need to do is: Get rid of duplicates from both "product ID codes" (from sheet1 and sheet2). Then I need to cross check and add Quantities and Costs (from sheet2) to only the "Product ID codes" that are Matching! This needs to be added to Sheet1's version.
Thanks
M