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