Scooter670
New Member
- Joined
- Nov 14, 2012
- Messages
- 1
I have a sheet with 20 names in one column. Now I have five separate columns to rate different performance categories with a scale of 1-20 (1 being the best). I'm looking for a formula to pick the name in a given cell of the player in each column with the score of 1. In theory, I should show several different player names when each category stat is evaluated. I don't know where to start?
