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.