This may be something that Excel does not easily do.
In the attached, you will find a Summary Scorecard tab. I want to be able to click into any given cell that is counting values and somehow actually *list* the data that makes up that count.
For example: cell B3 contains the number 15. I want to be able to *list* the 15 KCs with and Ops Risk Score of 9 that aligns under the Bankruptcy workstream.
I do not want to recreate this entire Scorecard using pivot tables.
Is there another creative way?