• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Using Excel to track order status

S

Sachin

New Member
All,


I run a report where I track the progress of various orders. Our tracking software (homegrown) records dates for each milestone such as when a order comes in, when it is assigned, etc. I want to use these dates to derive the order status. Right now, I used a series of long and complicated multiply-nested IF functions to figure out the status. There must be a simpler way, but I just can't see it. There is a link to my file here:


http://bit.ly/ri8T00


Does anyone have any ideas?


Thank you in advance,


Sachin
 
Sachin


in A4 try: =INDEX(JobTable[#Headers],,MATCH(MAX($D4:$K4),$B4:$K4,0))

Copy down
 
You must log in or register to reply here.
Back
Top