[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 223
  • Last Modified:

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
0
Feisty472
Asked:
Feisty472
1 Solution
 
Zack BarresseCEOCommented:
Hi there,

Nope, no can do.  Not the way you want anyway.  With such a cluttered worksheet I'm not sure why you'd want to add anymore data to that sheet.  Yikes!  Besides, I'm not entirely sure where you want this *list* to go.  You could do this with VBA, although you'd need to define what you wanted to do a little more and what version of Excel you're working with.

I hate to say it, but a PivotTable doesn't sound too bad for this.  It'd probably be the quickest way.

Regards,
Zack Barresse
0
 
gowflowCommented:
Any help still needed in this question ?
gowflow
0

Featured Post

Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now