I have a data with two columns. Column A contains the Engineering Change Order (ECO) numbers and Column B contains the Models affected on the particular ECO.
Some ECOs with affected models are only 1 model, some ECOs are affecting two or more models. If the ECO is affecting multiple models, these models are listed only in one cell in column B separated by a comma.
My objective is to create a report to find out which models have the most numbers of Engineering Change order. I have this as output in sheet 2 of the attached spreadsheet.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!