Auto Sorting a Summary Sheet

**jweeda** · 09-16-2014, 10:19 AM

Good morning. A buddy and myself are working on a spreadsheet for our fantasy football league. We are doing the NFL.com fantasy games including Perfect Challenge, Weekly Pick'Em, and TNF Challenge. To determine a winner at the end of the year, we are taking all 3 fantasy games and totalizing the scores from each game for each player. The player with the highest score at the end of Week 16 wins. We built the spreadsheet to tally the scores on a summary sheet and we want our chart to update weekly to show the highest score first, descending to the lowest score last. I'm pretty handy with Excel until it comes to conditional formatting or macros and I dont' know how to accomplish what I want. Any ideas?

Thanks! I can upload the spreadsheet if necessary, but its basically a column of names and a column of numbers reflected in a graph. I just need to auto sort them every time we update it.

Jim

**daffodil11** · 09-16-2014, 11:16 AM

You can use a series of INDEX(SMALL array formulas to autoupdate your records.

This pulls the running total score column, J2:J25:

=INDEX(Input!$J$2:$J$25,LARGE(IF(Input!$J$2:$J$25=LARGE(Input!$J$2:$J$25,ROW(A1)),ROW(Input!$J$1:$J$24)),ROW($A$1)))

And this pulls the names of the teams, from A2:A25:

=INDEX(Input!A$2:A$25,LARGE(IF(Input!$J$2:$J$25=LARGE(Input!$J$2:$J$25,ROW(B1)),ROW($I$1:$I$24)),COUNTIF($B$2:B2,B2)))

AUTOSUMMARY.xls

**jweeda** · 09-16-2014, 12:41 PM

[ATTACH]NFL FANTASY SCORES[/ATTACH]

Unfortunately, I can't decipher how to use that formula. I attached the spreadsheet so you can see what my buddy put together and maybe you can help me with that Summary page based off what I have here.