Microsoft Excel: Next Status Change

5 pts.
Tags:
Microsoft Excel
I have a two tables. On table has a unique order number and the associated time it entered a production stage (status). I have another table which has the unique order number and time stamp for each time a production stage changed (status). On the first table how can I systematically determine the next time a production stage (status) changed after it entered the stage? i.e. if order 1234 went into stage 5 on 7/1/2015 and left of 7/6/2015. How can I populate this on my first table? Products may enter stages mul.


Software/Hardware used:
excel
0

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • Jaideep Khanduja
    You will have to write a script.
    19,090 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: