(Answered) : Need a way to track and write formula to pull information. For example, if I typed Candy Torres into Cell A10, I would want s

Need a way to track and write formula to pull information.

For example, if I typed Candy Torres into Cell A10, I would want something that popped up on the side that showed that on 12/2/2017, the account was in a Gen – New Status, and then on 12/4/2017, it went into Gen Supervideo Review Satus, and then on 12/5/2017, it went into a Gen – Action Needed Status. In addition, I would also like to track how many days it stayed in each status. Please see below for example of raw data. Then, please see the following picture for how