Hello all-
I have a question about how to make a formula, thanks in advance for your assistance.
Ok, so my website hosts amateur wrestling tournaments and post results, what we are attempting to do is make a point system whereby wrestler will get so many points for each placement at a tournament, and then be "ranked" in order of how many points they have within their age group and weight class. So in other words, 20 wrestlers will be ranked in order of points at 11-12 75 pounds, another 20 wrestlers will be ranked at 11-12 80 pound weight class, and so forth. Altogether there are about 50 age group/weight class combinations, and probably 100 tournaments going into the ranking/point system, so as you can imagine, it is something that needs to be done automatically by excel. We get new results for in several tournaments every week, hoping to just "dump" in the new results for each tournament and have it automatically update the standings.
So here's how far I've gotten. I list the results in a new spreadsheet, and it looks like this. The third column is weight class, the far right column is how many points the wrestler accumulated at that tournament. Note that I just listed results for the same tournament twice in a row, for way of example, because it will be easier to illustrate my problem.
DUSTIN OTERO 5-6 Rookie 40 5
TEEGAN GILMORE 5-6 Rookie 40 3
BEAU WILKOVICH 5-6 Rookie 40 2
HAYDEN SIGLER 5-6 Rookie 45 8
BLAKE BARTOS 5-6 Rookie 45 6
GREY BURNETT 5-6 Rookie 45 4
CALEB NICELY 5-6 Rookie 45 3
BEAU FIERCE 5-6 Rookie 45 2
HUNTER BENHAM 5-6 Rookie 45 1
CONNOR HANEY 5-6 Rookie 50 8
EMMANUEL CAIN 5-6 Rookie 50 6
NICHOLAS PARKS 5-6 Rookie 50 4
JEFF MASLAR 5-6 Rookie 50 3
DIEGO CASTRO 5-6 Rookie 50 2
E.J. GERMAN 5-6 Rookie 55 5
RAYMOND FIERCE 5-6 Rookie 55 3
AIDEN SUPERS 5-6 Rookie 55 2
ALYSSA RODKEY 5-6 Rookie 55 1
GAVYN MCCRAY 5-6 Rookie 60 5
ARMAN GABLE 5-6 Rookie 60 3
ANTHONY SEVIEK 5-6 Rookie 60 2
AGE:
JOEL RAY 7-8 Rookie 45 4
R.J. SYCZ 7-8 Rookie 45 2
DOMINIC CASTRO 7-8 Rookie 50-55 8
CONNOR HOLM 7-8 Rookie 50-55 6
SHANE HICKMAN 7-8 Rookie 50-55 4
DOMONIC SPRURIG 7-8 Rookie 50-55 3
ISAIAH CRIBE 7-8 Rookie 50-55 2
KINGSTON URIAS 7-8 Rookie 60 5
MARK WISSEL 7-8 Rookie 60 3
BRENDEN WATCHHAM 7-8 Rookie 60 1
JESSE FARMER 7-8 Rookie 66 8
KYLE SANBORN 7-8 Rookie 66 6
CAYDEN FIALA 7-8 Rookie 66 4
AVERY VIANCOURT 7-8 Rookie 66 3
AYDEN DUNN 7-8 Rookie 66 2
LANDON KINAS 7-8 Rookie 66
CARLOS JOHNSON 7-8 Rookie 68-72 5
AIDEN MAYS 7-8 Rookie 68-72 3
MJ SEBRING 7-8 Rookie 68-72 2
DREW WILSON 7-8 Rookie 68-72 1
ANDREW SUPERS 7-8 Rookie 85 5
GABE TITMAS 7-8 Rookie 85 3
ANDREW HENDERSON 7-8 Rookie 85 2
ANDREW FLESHER 7-8 Rookie 85-91 4
ANDREW HENDERSON 7-8 Rookie 85-91 2
DUSTIN OTERO 5-6 Rookie 40 5
TEEGAN GILMORE 5-6 Rookie 40 3
BEAU WILKOVICH 5-6 Rookie 40 2
HAYDEN SIGLER 5-6 Rookie 45 8
BLAKE BARTOS 5-6 Rookie 45 6
GREY BURNETT 5-6 Rookie 45 4
CALEB NICELY 5-6 Rookie 45 3
BEAU FIERCE 5-6 Rookie 45 2
HUNTER BENHAM 5-6 Rookie 45 1
CONNOR HANEY 5-6 Rookie 50 8
EMMANUEL CAIN 5-6 Rookie 50 6
NICHOLAS PARKS 5-6 Rookie 50 4
JEFF MASLAR 5-6 Rookie 50 3
DIEGO CASTRO 5-6 Rookie 50 2
E.J. GERMAN 5-6 Rookie 55 5
RAYMOND FIERCE 5-6 Rookie 55 3
AIDEN SUPERS 5-6 Rookie 55 2
ALYSSA RODKEY 5-6 Rookie 55 1
GAVYN MCCRAY 5-6 Rookie 60 5
ARMAN GABLE 5-6 Rookie 60 3
ANTHONY SEVIEK 5-6 Rookie 60 2
AGE:
JOEL RAY 7-8 Rookie 45 4
R.J. SYCZ 7-8 Rookie 45 2
DOMINIC CASTRO 7-8 Rookie 50-55 8
CONNOR HOLM 7-8 Rookie 50-55 6
SHANE HICKMAN 7-8 Rookie 50-55 4
DOMONIC SPRURIG 7-8 Rookie 50-55 3
ISAIAH CRIBE 7-8 Rookie 50-55 2
KINGSTON URIAS 7-8 Rookie 60 5
MARK WISSEL 7-8 Rookie 60 3
BRENDEN WATCHHAM 7-8 Rookie 60 1
JESSE FARMER 7-8 Rookie 66 8
KYLE SANBORN 7-8 Rookie 66 6
CAYDEN FIALA 7-8 Rookie 66 4
AVERY VIANCOURT 7-8 Rookie 66 3
AYDEN DUNN 7-8 Rookie 66 2
LANDON KINAS 7-8 Rookie 66
CARLOS JOHNSON 7-8 Rookie 68-72 5
AIDEN MAYS 7-8 Rookie 68-72 3
MJ SEBRING 7-8 Rookie 68-72 2
DREW WILSON 7-8 Rookie 68-72 1
ANDREW SUPERS 7-8 Rookie 85 5
GABE TITMAS 7-8 Rookie 85 3
ANDREW HENDERSON 7-8 Rookie 85 2
ANDREW FLESHER 7-8 Rookie 85-91 4
ANDREW HENDERSON 7-8 Rookie 85-91 2
Then, I sort them by Age group and weight class, and rank them in order of points within that age group and weight class, here's how it looks (obviously it looks much more organized on Excel):
DUSTIN OTERO 5-6 Rookie 40 5
DUSTIN OTERO 5-6 Rookie 40 5
TEEGAN GILMORE 5-6 Rookie 40 3
TEEGAN GILMORE 5-6 Rookie 40 3
BEAU WILKOVICH 5-6 Rookie 40 2
BEAU WILKOVICH 5-6 Rookie 40 2
HAYDEN SIGLER 5-6 Rookie 45 8
HAYDEN SIGLER 5-6 Rookie 45 8
BLAKE BARTOS 5-6 Rookie 45 6
BLAKE BARTOS 5-6 Rookie 45 6
GREY BURNETT 5-6 Rookie 45 4
GREY BURNETT 5-6 Rookie 45 4
CALEB NICELY 5-6 Rookie 45 3
CALEB NICELY 5-6 Rookie 45 3
BEAU FIERCE 5-6 Rookie 45 2
BEAU FIERCE 5-6 Rookie 45 2
HUNTER BENHAM 5-6 Rookie 45 1
HUNTER BENHAM 5-6 Rookie 45 1
CONNOR HANEY 5-6 Rookie 50 8
CONNOR HANEY 5-6 Rookie 50 8
EMMANUEL CAIN 5-6 Rookie 50 6
EMMANUEL CAIN 5-6 Rookie 50 6
NICHOLAS PARKS 5-6 Rookie 50 4
NICHOLAS PARKS 5-6 Rookie 50 4
JEFF MASLAR 5-6 Rookie 50 3
JEFF MASLAR 5-6 Rookie 50 3
DIEGO CASTRO 5-6 Rookie 50 2
DIEGO CASTRO 5-6 Rookie 50 2
E.J. GERMAN 5-6 Rookie 55 5
E.J. GERMAN 5-6 Rookie 55 5
RAYMOND FIERCE 5-6 Rookie 55 3
RAYMOND FIERCE 5-6 Rookie 55 3
AIDEN SUPERS 5-6 Rookie 55 2
AIDEN SUPERS 5-6 Rookie 55 2
ALYSSA RODKEY 5-6 Rookie 55 1
ALYSSA RODKEY 5-6 Rookie 55 1
GAVYN MCCRAY 5-6 Rookie 60 5
GAVYN MCCRAY 5-6 Rookie 60 5
ARMAN GABLE 5-6 Rookie 60 3
ARMAN GABLE 5-6 Rookie 60 3
ANTHONY SEVIEK 5-6 Rookie 60 2
ANTHONY SEVIEK 5-6 Rookie 60 2
JOEL RAY 7-8 Rookie 45 4
JOEL RAY 7-8 Rookie 45 4
R.J. SYCZ 7-8 Rookie 45 2
R.J. SYCZ 7-8 Rookie 45 2
KINGSTON URIAS 7-8 Rookie 60 5
KINGSTON URIAS 7-8 Rookie 60 5
MARK WISSEL 7-8 Rookie 60 3
MARK WISSEL 7-8 Rookie 60 3
BRENDEN WATCHHAM 7-8 Rookie 60 1
BRENDEN WATCHHAM 7-8 Rookie 60 1
JESSE FARMER 7-8 Rookie 66 8
JESSE FARMER 7-8 Rookie 66 8
KYLE SANBORN 7-8 Rookie 66 6
KYLE SANBORN 7-8 Rookie 66 6
CAYDEN FIALA 7-8 Rookie 66 4
CAYDEN FIALA 7-8 Rookie 66 4
AVERY VIANCOURT 7-8 Rookie 66 3
AVERY VIANCOURT 7-8 Rookie 66 3
AYDEN DUNN 7-8 Rookie 66 2
AYDEN DUNN 7-8 Rookie 66 2
LANDON KINAS 7-8 Rookie 66
LANDON KINAS 7-8 Rookie 66
ANDREW SUPERS 7-8 Rookie 85 5
ANDREW SUPERS 7-8 Rookie 85 5
GABE TITMAS 7-8 Rookie 85 3
GABE TITMAS 7-8 Rookie 85 3
ANDREW HENDERSON 7-8 Rookie 85 2
ANDREW HENDERSON 7-8 Rookie 85 2
DOMINIC CASTRO 7-8 Rookie 50-55 8
DOMINIC CASTRO 7-8 Rookie 50-55 8
CONNOR HOLM 7-8 Rookie 50-55 6
CONNOR HOLM 7-8 Rookie 50-55 6
SHANE HICKMAN 7-8 Rookie 50-55 4
SHANE HICKMAN 7-8 Rookie 50-55 4
DOMONIC SPRURIG 7-8 Rookie 50-55 3
DOMONIC SPRURIG 7-8 Rookie 50-55 3
ISAIAH CRIBE 7-8 Rookie 50-55 2
ISAIAH CRIBE 7-8 Rookie 50-55 2
CARLOS JOHNSON 7-8 Rookie 68-72 5
CARLOS JOHNSON 7-8 Rookie 68-72 5
AIDEN MAYS 7-8 Rookie 68-72 3
AIDEN MAYS 7-8 Rookie 68-72 3
MJ SEBRING 7-8 Rookie 68-72 2
MJ SEBRING 7-8 Rookie 68-72 2
DREW WILSON 7-8 Rookie 68-72 1
DREW WILSON 7-8 Rookie 68-72 1
ANDREW FLESHER 7-8 Rookie 85-91 4
ANDREW FLESHER 7-8 Rookie 85-91 4
ANDREW HENDERSON 7-8 Rookie 85-91 2
ANDREW HENDERSON 7-8 Rookie 85-91 2
So here's my problem. Once I sort, I need the system to automatically add each wrestlers points together that he has received at each tournament, list that wrestler only once, and rank/order them by total points, instead of listing them multiple times for the individual points they list at each tournament (as you see above).
Once again, thanks in advance, the extent of my knowledge currently ends at basic sorts and sum functions for columns, so any insight is much appreciated.
Bookmarks