Hello!
I need some help with a complex formula. I have thousands of rows of data that is continuously increasing.
There are two ways the data can be looked at (across Type only and across Type and Size combo).
I need to find the number of times for each a month/year and CP type in which there was a problem. Specifically, if a Type fails (once or more) on any of the series (1-6), then it needs to be counted ONLY ONCE.
In addition, for both these ways, the data needs to be parsed by month/year and CP type.
For Type Only
If everything is ok for that Type, then it is a "0" for that Type
If one or more problems are identified within a Type, then it needs to be counted only ONCE (no matter how many problems were identified)
For Type and Size combination
If everything is ok for that type and size combo, then it is counted as a "0"
If one or more problems are identified within a Type and Size combo, then it needs to be counted only ONCE (no matter how many problems were identified)
I am fine with adding columns to help with the formulas.
I included mock data along with what that data should look like. Its pretty complicated, so I colored the data to help identify the Type (color) and Type and Size (different color shading).
Note:
I updated the spreadsheet based on feedback for clarity.
- Type, Size, OK? (only descriptions), and Date can be anything. These values cannot be unsed within the formula.
- CP, OK? (only 'Yes'), and Series are "fixed". These values can be used within the formula.
This is really kicking my behind and I really need some experts to help figure it out.
Thanks in advance for helping me with this tough formula.
Joanne
Bookmarks