BradReynolds
New Member
- Joined
- Aug 3, 2010
- Messages
- 3
I am looking for a couple of creative ways to achieve the following in excel:
On a spreadsheet I have a list of numbers that have been identified as the top five defect drivers. Also established are a top five list of typically occurring defects. The end result that I am trying to get to is a stacked bar chart that exhibits the top five part numbers and which of the top five defects affect those part numbers. In other words, I’d like to write a formula that will lookup the part number from a list and then count the defects from the established list of five and return a number. Hope this is making sense. I have attached an excel file (SUM MULTIPLE CONDITIONS.xls) that will hopefully illustrate my goal a little better if needed.
I’d prefer to stay away from VBA as much as possible and stick with formula options.
Thanks!
On a spreadsheet I have a list of numbers that have been identified as the top five defect drivers. Also established are a top five list of typically occurring defects. The end result that I am trying to get to is a stacked bar chart that exhibits the top five part numbers and which of the top five defects affect those part numbers. In other words, I’d like to write a formula that will lookup the part number from a list and then count the defects from the established list of five and return a number. Hope this is making sense. I have attached an excel file (SUM MULTIPLE CONDITIONS.xls) that will hopefully illustrate my goal a little better if needed.
I’d prefer to stay away from VBA as much as possible and stick with formula options.
Thanks!
Last edited: