Ranking Average

[mjw1979]

Hi,

I'm looking to rank Fantasy Football players.

I have the players listed in three columns, one in which order they were drawn in the draft last year, one in which they are expected to be drawn this year and one using their average score from last season.

Is there a way for me to average their position across all three columns into a new column?

Thanks in advance.

 

[Captain_Conman]

Assuming you have the player name in column A, and the data you mentioned is in columns B:D, place the following function in column E.

=AVERAGE(B2,C2,RANK(D2,D:D))

The place this function in Column F and Column F is your new ranking order

=RANK(E2,E:E,1)

Hopefully this helps a little bit? This is tricky because a draft position value is different than the value of a scoring average.