excelgirl2583
New Member
- Joined
- Oct 19, 2015
- Messages
- 4
I am sort of new to excel so this is probably an easy question but can't get my head around it! I am working on building a Dynamic Dashboard and want to people able to type in a metric (or pick from a drop down list) and have the dashboard show me the top 3 performers based on max (the names of store not the score)
And to make things more fun i would want it to identify that if "problems experienced" is picked as the metric on the dashboard it would show me the top 3 performers based on "MIN"
Thank you in advance! i have been banging my head against the wall trying to use index match and watching youtube videos with no luck
<TBODY>
</TBODY>
And to make things more fun i would want it to identify that if "problems experienced" is picked as the metric on the dashboard it would show me the top 3 performers based on "MIN"
Thank you in advance! i have been banging my head against the wall trying to use index match and watching youtube videos with no luck
customer osat | problems expereinced | timeliness | |
store 1 | 75 | 22 | 77 |
store 2 | 67 | 33 | 85 |
store 3 | 89 | 44 | 67 |
store 4 | 91 | 11 | 95 |
<TBODY>
</TBODY>