Hello everyone, first time poster here and basicly a first time user of Excel.
I work at a warehouse and we dont have a system that warns us if an article on A (floor) is about to be empty.
We have thousands of articles and to manualy keep track of them and refill is not possible.
So i need help to figure out a formula that warns me if A is about to be empty and suggest B or C so we can refill A with pallets from B or C before it´s to late.
I copy the entire shelving system to excel usually around 1500 articles and remove the double entries because we use batches.
So this is the data im left with to sort in order from left to right.
Article number, Name of article, place, balance.
Example:
45226 Tape 0579-A 48
45226 Tape 0579-B 544
45226 Tape 0579-C 612
I want the option to only show a pallet that has <48 on A and suggest a B or C pallet with >48.
If the pallets has >48 then i dont want it to be shown or just let the pallets im interested in be marked with 1 and those im not interested in to be marked with 0.
Is this possible?
Thankful for any help i can get.
/Istid
Bookmarks