Copy Name and Sum total scores to new Tab

[SirScott13]

I have a spreadsheet that is compiling the results of 6 different climbing competitions. The climbers can attend all 6 competitions and can score multiple times per competition, but only their top 2 point totals count towards their season rankings. I have a sheet which groups all of the competitions into a sheet and then lists their top 2 scores. At this point, I just want to create a new tab/sheet which ranks the athletes with the sum of their top two climbs. This list would then be ranked from highest point total to lowest.

Here is the Mini-Sheet for the existing data.

Climbing Rankings 2021.xlsx
	A	B	C
3	FJR
4	Rank	Name	Points
5	1	Steve Williams	100
6	2	Bill Gates	100
7	3	**** Trickle	80
8	4	Bob Barker	65
9	5	Jacob Degrom	35
10	6	Jacob Degrom	100
11	7	Jacob Degrom	110
12	8	David Johnson	40
13	9	Jason Johnson	30
14	10	**** Trickle	40
15	11	**** Trickle	42
16	12	0	0
17	13	0	0
18	14	0	0
19	15	0	0
20	16	0	0
21	17	0	0
22	18	0	0
23	19	0	0
24	20	0	0
25	21	0	0
26	22	0	0
27	23	0	0
28	24	0	0
29	25	0	0
30	26	0	0
31	27	0	0
32	28	0	0
33	29	0	0
34	30	0	0
35	31	0	0
36	32	0	0
37	33	0	0
38	34	0	0
39	35	0	0
40	36	0	0
41	37	0	0
42	38	0	0
43	39	0	0
44	40	0	0
45	1	Jason Johnson	80
46	2	0	0
47	3	0	0
48	4	0	0
49	5	0	0
50	6	0	0
51	7	0	0
52	8	0	0
53	9	0	0
54	10	0	0
55	11	0	0
56	12	0	0
57	13	0	0
58	14	0	0
59	15	0	0
60	16	0	0
61	17	0	0
62	18	0	0
63	19	0	0
64	20	0	0
65	21	0	0
66	22	0	0
67	23	0	0
68	24	0	0
69	25	0	0
70	26	0	0
71	27	0	0
72	28	0	0
73	29	0	0
74	30	0	0
75	31	0	0
76	32	0	0
77	33	0	0
78	34	0	0
79	35	0	0
80	36	0	0
81	37	0	0
82	38	0	0
83	39	0	0
84	40	0	0
85	1	0	0
86	2	0	0
87	3	0	0
88	4	0	0
89	5	0	0
90	6	0	0
91	7	0	0
92	8	0	0
93	9	0	0
94	10	0	0
95	11	0	0
96	12	0	0
97	13	0	0
98	14	0	0
99	15	0	0
100	16	0	0
101	17	0	0
102	18	0	0
103	19	0	0
104	20	0	0
105	21	0	0
106	22	0	0
107	23	0	0
108	24	0	0
109	25	0	0
110	26	0	0
111	27	0	0
112	28	0	0
113	29	0	0
114	30	0	0
115	31	0	0
116	32	0	0
117	33	0	0
118	34	0	0
119	35	0	0
120	36	0	0
121	37	0	0
122	38	0	0
123	39	0	0
124	40	0	0
125	1	0	0
126	2	0	0
127	3	0	0
128	4	0	0
129	5	0	0
130	6	0	0
131	7	0	0
132	8	0	0
133	9	0	0
134	10	0	0
135	11	0	0
136	12	0	0
137	13	0	0
138	14	0	0
139	15	0	0
140	16	0	0
141	17	0	0
142	18	0	0
143	19	0	0
144	20	0	0
145	21	0	0
146	22	0	0
147	23	0	0
148	24	0	0
149	25	0	0
150	26	0	0
151	27	0	0
152	28	0	0
153	29	0	0
154	30	0	0
155	31	0	0
156	32	0	0
157	33	0	0
158	34	0	0
159	35	0	0
160	36	0	0
161	37	0	0
162	38	0	0
163	39	0	0
164	40	0	0
165	1	Steve Williams	65
166	2	Bill Gates	35
167	3	Bob Barker	100
168	4	David Johnson	1000
169	5	0	0
170	6	0	0
171	7	0	0
172	8	0	0
173	9	0	0
174	10	0	0
175	11	0	0
176	12	0	0
177	13	0	0
178	14	0	0
179	15	0	0
180	16	0	0
181	17	0	0
182	18	0	0
183	19	0	0
184	20	0	0
185	21	0	0
186	22	0	0
187	23	0	0
188	24	0	0
189	25	0	0
190	26	0	0
191	27	0	0
192	28	0	0
193	29	0	0
194	30	0	0
195	31	0	0
196	32	0	0
197	33	0	0
198	34	0	0
199	35	0	0
200	36	0	0
201	37	0	0
202	38	0	0
203	39	0	0
204	40	0	0
205	1	Jason Johnson	100
206	2	0	0
207	3	0	0
208	4	0	0
209	5	0	0
210	6	0	0
211	7	0	0
212	8	0	0
213	9	0	0
214	10	0	0
215	11	0	0
216	12	0	0
217	13	0	0
218	14	0	0
219	15	0	0
220	16	0	0
221	17	0	0
222	18	0	0
223	19	0	0
224	20	0	0
225	21	0	0
226	22	0	0
227	23	0	0
228	24	0	0
229	25	0	0
230	26	0	0
231	27	0	0
232	28	0	0
233	29	0	0
234	30	0	0
235	31	0	0
236	32	0	0
237	33	0	0
238	34	0	0
239	35	0	0
240	36	0	0
241	37	0	0
242	38	0	0
243	39	0	0
244	40	0	0
245
246	Name	1st Score	2nd Score
247	Steve Williams	100	65
248	Bill Gates	100	35
249	**** Trickle	80	42
250	Bob Barker	100	65
251	Jacob Degrom	110	100
252	David Johnson	1000	40
253	Jason Johnson	100	80
Consolidated Data

Cell Formulas
Range	Formula
B6:B8,A13:C44,C5:C12,A5:A12	B6	='High Point'!B6
A45:C84	A45	=Ozark!A5
A85:C124	A85	='Upper Limits'!A5
A125:C164	A125	=RoKC!A5
A165:C204	A165	='The Crag'!A5
A205:C243,A244:B244	A205	='High Point Cleveland'!A5
C244	C244	=A14:C244='High Point Cleveland'!C44
A247:A253	A247	=UNIQUE(FILTER(B5:B244,B5:B244<>0))
B247:C253	B247	=INDEX(SORT(FILTER($C$2:$C$244,$B$2:$B$244=A247),,-1),{1,2})
Dynamic array formulas.

 

[SirScott13]

Oh, one last thing. The list of names in the consolidated list grows as a name is added, but the scores do not automatically grow. I can extend the formula for 40-50 additional rows, but it then populates with unexpected data. Until a name exists, it just spits out the number 140 in the "1st Score" column.