Hello,
I'm looking to make automation process I do several times a day . Since it's quite complex so first explanation - this is an online report I'm getting it to Excel . The report contains data on the number of production batch
each batch begin at step 2 and ends at step 28 ( column J) . the relevant steps for me are step 13-22
What i need :
1 . Delete empty cells
2 . Ordering data by batch of stages 13-22 only in the other sheet
Add another column of an absolute time that 0 represents the beginning of step 13 ( for the same batch ) and the end time is the end stage 22 . Simply Ahrotharc first would be 0, the next one will be 00:00:60 , and so on ( each row is one minute )
3 . Building a scatter graph Y axis is the values ​​of temperature (column A ) and the X axis is the absolute time for each batch with a third -order trend Foliniomali presenting formula and correlation .

sorry for my eng...
Thanks in advance ! ! !