Hi,
I need to identify in an excel table who requires intervention based on their weekly scores, I have 10 depots and the person who scores the lowest will require intervention, however for one site I'll do an intervention to the bottom 5 not just the lowest one.
I want to be able to have a category in a column that says "Yes" or "No" next to their name so I can filter quickly and see who requires intervention, I've managed to do this for the person with the lowest score, but I get stock when it comes to the bottom 5 for that single depot.
A few additional things:
- The number of people varies every week
- Every week I'll have a new report with new scores
I've added a screenshot of the example table, for some reason I can't upload the excel file.
Excel help.PNG
Appreciate your help!!
Bookmarks