Feisty472
asked on
Show list of formula results
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?
For-Listing.xls
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?
For-Listing.xls
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
gowflow