ExcelNoob2022
New Member
- Joined
- Apr 3, 2022
- Messages
- 8
- Office Version
- 365
- Platform
- Windows
Hello,
I am very new with Excel and trying to use my Googlefu to help as much as possible but finally got stuck and I found this website and am hoping someone here is nice enough to lend a hand.
For my stats sheet, I want to create a list of the Top Players in several categories. I would like their names to be included in the list.
So far, I have used the LARGE command to successfully get a list of Goals, Assists and Saves in a top 3 order. However, I can't figure out how to get the matching names.
The next issue I have is with the "Points" category. This is calculated by Goals(x2)+Assists. I can get the Goals(x2) with the following command: =LARGE($B$3:$B$17*2,ROWS(A$3:A4)) but whenever I attempt to add in the Assists, I get a !NUM error.
Any advice or help would be greatly appreciated.
I am very new with Excel and trying to use my Googlefu to help as much as possible but finally got stuck and I found this website and am hoping someone here is nice enough to lend a hand.
For my stats sheet, I want to create a list of the Top Players in several categories. I would like their names to be included in the list.
So far, I have used the LARGE command to successfully get a list of Goals, Assists and Saves in a top 3 order. However, I can't figure out how to get the matching names.
The next issue I have is with the "Points" category. This is calculated by Goals(x2)+Assists. I can get the Goals(x2) with the following command: =LARGE($B$3:$B$17*2,ROWS(A$3:A4)) but whenever I attempt to add in the Assists, I get a !NUM error.
Any advice or help would be greatly appreciated.
Team Statsheet.xlsx | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | N | |||
1 | FULL SEASON STATS | WIN | LOSS | TIE | ||||||||||||
2 | Player | Goals | Assists | Shots | Offsides | Fouls | Goals Allowed | Saves | Shut Out Halves | Hat Tricks | 2 | 0 | 0 | |||
3 | Adelyn Holexa | 1 | 0 | 1 | 0 | 0 | 2 | 5 | 2 | 0 | 1 | 1 | 0 | |||
4 | Alice Felton | 1 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||
5 | Blakely Haines | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||
6 | Brooke Risser | 3 | 2 | 6 | 0 | 0 | 1 | 6 | 1 | 0 | Team Leaders | |||||
7 | Charlie Zetterberg | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||
8 | Dempsey Meyers | 3 | 0 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | Points | |||||
9 | Emery Schmitz | 3 | 1 | 4 | 0 | 0 | 3 | 7 | 1 | 0 | 12 | |||||
10 | Grace Hart | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | |||||
11 | Hayden Haines | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | |||||
12 | Holly Beckman | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||
13 | Hope Hoffman | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | Goals | |||||
14 | Jenna Thurlkill | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | |||||
15 | Lauren Martinsen | 3 | 0 | 7 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | |||||
16 | Nia Reilly | 6 | 0 | 8 | 0 | 0 | 0 | 0 | 0 | 1 | 3 | |||||
17 | Zuzu Gilman | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||
18 | TOTAL | 21 | 3 | 34 | 0 | 0 | 6 | 18 | 4 | 1 | Assists | |||||
19 | 2 | |||||||||||||||
20 | 1 | |||||||||||||||
21 | 0 | |||||||||||||||
22 | ||||||||||||||||
23 | Saves | |||||||||||||||
24 | 7 | |||||||||||||||
25 | 6 | |||||||||||||||
26 | 5 | |||||||||||||||
Main |
Cell Formulas | ||
---|---|---|
Range | Formula | |
L2:N3 | L2 | =SUM(Plains:Kalispell!W2) |
B3:J17 | B3 | =SUM(Plains:Kalispell!B3,Plains:Kalispell!M3,Plains:Kalispell!M22,Plains:Kalispell!B22,) |
B18:J18 | B18 | =SUM(B3,B4,B5,B6,B7,B8,B9,B10,B11,B12,B13,B14,B15,B16,B17,) |
N9:N11 | N9 | =LARGE($B$3:$B$17*2,ROWS(A$3:A3)) |
N14:N16 | N14 | =LARGE($B$3:$B$17, ROWS(A$3:A3)) |
N19:N21 | N19 | =LARGE($C$3:$C$17, ROWS(A$3:A3)) |
N24:N26 | N24 | =LARGE($H$3:$H$17, ROWS(A$3:A3)) |