creating a summary list depending on scores

[narrowdave]

Hi, am hoping someone can point me in the right direction...

I have created an excel based audit tool for hospitals. It takes scores from staff and managers in response to around 30 questions. These are combined and triangulated to produce a lovely dashboard / performance summary... All good so far...

So here's the thing... To the dashboard I am wondering about adding a box / table that shows the top 5 recommendations for action... So basically I'd create a list of 30 or so possible actions to improve performance - then on the basis of those which if implemented will make the biggest difference to the overall performance scores, on my dashboard I want to be able to show a list of the top 5... Obviously this needs to be capable of live updating if and when scores change...

I can't for the life of me think how to begin. I've already got hidden sheets with scores and corresponding actions but can't think how to pull through the top 5...

It may be post-Xmas brain fog but any thoughts on how to do this?? I'm thinking some form of table...

Thanks

Dave

 

[oldbrewer]

my 73 year old brain still appears to be functioning......