Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help a dumb arse & 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 :) -- pricey ------------------------------------------------------------------------ pricey's Profile: http://www.excelforum.com/member.php...o&userid=33897 View this thread: http://www.excelforum.com/showthread...hreadid=536727 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help a dumb arse & win a prize
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" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dumb sorting question | Excel Discussion (Misc queries) | |||
Dumb VBA question | Excel Discussion (Misc queries) | |||
Very dumb question | Excel Discussion (Misc queries) | |||
No Dumb Question | Excel Worksheet Functions | |||
what is a dumb or smart formula | Excel Worksheet Functions |