Howdy,
I work for a manufacturing company and i currently receive rolling
production figures for works orders daily and I need to calculate the
daily figure
(total quantity made yesterday - total made day before = yesterdays
total parts made for yesterday)
Obviously the calculation for this is simple but we have 25 machines
and works orders can change from day to day so I need to find a way of
excel recognising the works order number and starting from zero when a
new works order number is introduced.
Can anyone help?
P.S there's no prize, I lied :)
--
pricey
------------------------------------------------------------------------
pricey's Profile:
http://www.excelforum.com/member.php...o&userid=33897
View this thread:
http://www.excelforum.com/showthread...hreadid=536727