I have multiple lists ranking people. I have put them in an excel spreadsheet, each list occupying 1 column
A=washington Post B=Yahoo C=Fox D=NFL.com
These lists are ranking the same individuals, so their names are on every list, but each list has them ranked differently. All the names are in the same format.
I want the names that appear highest on these lists most consistently to appear in order in a separate final column. The idea is rank the people that most sources rank highest most consistently.
So if there are 4 lists, and Joe Davidson is ranked 1,2,1,3 respectively, He would get a composite score of 7 (1+2+1+3). The person with the lowest composite score would appear highest in the final column, and the next lowest composite score would rank second, and so on down the column.