1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Create average rank from two disparate but overlapping ranking lists

I can't figure out how to create an average rank from two lists of baseball prospect rankings. Importantly, one list has 600 players and the other has 500 players, and while something like 300-400 players appear on both lists, many appear on only one because there is such a wide range of opinions among the two scouts, especially after you get past the top 100 or so. There are guys ranked 115th on one that don't even make the other list. So I can't just sort by name and create an average based on position.

submitted by /u/RhamkatteWrangler
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#rows.com
#Excel compatibility
#cloud-based spreadsheet applications
#Excel alternatives for data analysis
#average rank
#baseball prospect
#ranking lists
#players
#scouts
#overlapping
#600 players
#500 players
#opinions
#top 100
#ranked
#disparate
#list comparison
#not ranked
#sort by name
#average position