Morning,
I have a list of questions and people have ranked themselves 0 - 4. I would like to create a summary whereby I have the question and report the highest value and then the persons name so in the end I would know who was the best skilled for each area. If two people (or more) rank themselves 4 I would like to report all of their names.
I've attached a sample of what I'm trying to achieve...
Thank you!
Bookmarks