I am running a league where players score points for the position they finish. I am trying to generate a formula so I can show their current standings off to the side based on their current total points. Each column is headed by their name and below their names are the points they earn each week and at the bottom of the column is their total points accumulated. The names are in cells B1 to J1. The players corresponding total points are in cells B37 to J37 respectively. Here is the function I have been trying to tweak:=INDEX($B$1:$J$1,,MATCH(SMALL(RANK(B37,$B$37:$J$37,0)+COLUMN($B$1:$J$1)/1000,COLUMNS($L13:L13)),RANK(B37,$B$37:$J$37,0)+COLUMN($B$1:$J$1)/1000,0)). It seems to work (not getting any errors), but it doesn't put them in rank order of highest to lowest. I added in the (+column($B$1:$J$1)/1000) part so that ties wouldn't cause a problem. Also, the other issue I am having with this formula is that I have to click and drag the cells horizontally to get the names to transfer. If I try to click and drag the formula vertically (which is how I would like it to display) it gives me a duplicate in the 2nd cell and then the "#VALUE!" in the rest.
Bookmarks