Help a dumb **** & win a prize

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

Assuming that the numbers are in row 1, A1, B1, C1, etc, a formula to
extract the last two numbers is

=IF(COUNT(1:1)=1,INDEX(1:1,1,1),INDEX(1:1,1,MAX(IF(1:1<>"",COLUMN(1:1))))-
INDEX(1:1,1,MAX(IF(1:1<>"",COLUMN(1:1)))-1))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"pricey" <pricey.26x0py_1146128400.7702@excelforum-nospam.com> wrote in
message news:pricey.26x0py_1146128400.7702@excelforum-nospam.com...
>
> 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
>