So i have a sheet that calculates total point for our field day and I would like it automatically populate the Rankings (Desired Results Sheet). I cannot figure out how to get it to put them in order with the team color and points matching.
I would like to look like:
Place Team Points
1 Pink 69
2 Green 64
.
.
.
and so on.
Any help on this would be greatly appreciated i have attached a sample sheet.
Los
Field Day 2014 Sample.xlsx
Bookmarks