I'm not great with Excel, so any help would be awesome!
I'm taking stats for my team, and I'm trying to create Top 5 lists for different stats. For example,
Player Goals
Al 4
Bob 11
Craig 1
Dave 7
Ed 5
Frank 3
Gary 9
I'd like to get a top 5 list, so it would rank
1. Bob
2. Gary
3. Dave
etc.
I can use =rank to give each player a number rank, but I don't know how to change that to a name.
Thanks!
Bookmarks