Hi-
I had previously received some great advice about how to properly parse my data to get it from the interwebs into the excel.
I now need help with my sorting of the data. The story is this:
I am in a fantasy baseball league where every week, we accumulate our total stats and go to head to head with another team. At the end of the week, in each matchup, whichever team has the higher total gets a point. There are 12 categories, so you could win a weekly matchup 12-0-0 (wins, losses, ties) if you do really well.
The problem that I have with this method of scoring is that you only go up against one opponent, not the entire league each week. So I am trying to get the raw stats for each team for each week and say where they finish in each category (1-10).
I have so far accomplished getting the stats from the internet to the excel, getting each team's weekly totals all in a nice readable order, getting all the stats for week 1 into a nice little box (the blue box on the analysis tab), and I am starting to get the stats sorted to the point that for each category, it spits out the team with the highest value and next highest and all that (the pink box).
The problem that I am having is that I sometimes get duplicate values: in week 1, both the rockford peachz and the vaya con bernabe teams hit 12 homers, so when I do a vlookup on the "large" function, it gives the same team for the second highest homers. Is there a way to get around this? Do I need some insane complicated if function?
I have attached the spreadsheet, all of the real action is in the analysis tab. Also, FYI, we are currently in week 8, so the only stats that I have are before that.
thanks!
Bookmarks