I need some help on gathering information to present on a report.
This file tracks issues, they are all numbered and they are also classified (A, B, C, D, M, NA). Also they have status and here is the problem I am trying to fix:
This formula to return values of the number of issues that meets a certain status and class:
Any issue classified as "B" and with status Waiting to Be Cleared then it would return: "Issues 129 and 300 are waiting to be cleared", where 129 and 300 would be the result of the formula I cannot find.The rets is discarded.
The attached file can show you better.