Oct 14 2020 02:09 PM
I am trying to set up a workbook that pulls data from another sheet with multiple criteria. The sheet has a list of production steps for various orders, along with the number of that step in the process, whether the step is active or not, and how many of the product have been produced to this point. I am trying to figure out how to pull the number produced from the line on the sheet with the most recent step that is actually active. In other words, for each production order, I need to find which row has the highest numbered operation that is marked as active, then pull the completed product number from that row. Is there a formula combination that can achieve this? I have attached a simplified example mockup to illustrate the situation.
Oct 14 2020 02:39 PM
SolutionSee the attached version.
Oct 15 2020 08:33 AM
@Hans Vogelaar Thank you! I had to modify the formulas slightly since I am using an older version of excel but this solution worked perfectly!
Oct 14 2020 02:39 PM
Solution