healimonster
03-15-2003, 05:55 PM
I know this is probably not the best forum to ask this question, and I have asked it else where. I just want to test my fellow k-lite board brethren with a bit of a conundrum.
This time of year several sources rank the top baseball players for fantasy baseball. To go into the draft you pretty much have to subscribe to 1 source and stick to it while you draft. If the source that you picked sucked then your draft will suck.
I am looking for a way to take these 4, 5 , or 6 different ranking lists put them into excel, and see if it can come up with a players average ranking among the lists.
Do you know how to do this?
There are a couple problems, all the lists are formated slightly differently and as the list goes lower some names are on some lists and not on others.
I suppose I could arrange all the lists on separate sheets and put them into alphabetic order and get and average for the players between sheets. but I fear that wouldn't work because as soon as 1 player on 1 list is not in the same order all the averages would be off, and useless.
Any suggestions?
This time of year several sources rank the top baseball players for fantasy baseball. To go into the draft you pretty much have to subscribe to 1 source and stick to it while you draft. If the source that you picked sucked then your draft will suck.
I am looking for a way to take these 4, 5 , or 6 different ranking lists put them into excel, and see if it can come up with a players average ranking among the lists.
Do you know how to do this?
There are a couple problems, all the lists are formated slightly differently and as the list goes lower some names are on some lists and not on others.
I suppose I could arrange all the lists on separate sheets and put them into alphabetic order and get and average for the players between sheets. but I fear that wouldn't work because as soon as 1 player on 1 list is not in the same order all the averages would be off, and useless.
Any suggestions?