Find Replace Ex 1
We need to determine which orders are not yet picked by subtracting the Pick Qty from the Order Qty. There seems to be a problem with some of the numbers that need to be sorted out with a tool. It seems that there are comma’s where there should be full stops.
Find Replace Ex 2
What are the totals of these 2 columns?
Create a sum in cell C100 and D100 (yellow cells)
If it won’t work, figure out how to change the cells to be numbers!
To see the full course contents click here.