Hi, I am trying to fix a formula. I have the below but when I attempt to change the cells it will not populate the position rank. Can someone help with my formula? =IFERROR(RANK(E2731,$E2731:$O2731)&LOOKUP(RANK(E2731,$E2731:$O2731),{0,1,2,3,4;"th","st","nd","rd","th"}),"")
D F G H I J K L M N O p q
<tbody>
</tbody>
D F G H I J K L M N O p q
ROW 2730: Season W/L % | 50.00% | 70.00% | 50.00% | 70.00% | 60.00% | 70.00% | 50.00% | 50.00% | 60.00% | #DIV/0! | 60.00% | #DIV/0! | #DIV/0! |
ROW 2731:SeasonWinning% | 50.00% | 70.00% | 50.00% | 70.00% | 60.00% | 70.00% | 50.00% | 50.00% | 60.00% | 0.00% | 60.00% | 0.00% | 0.00% |
ROW 2732: Season Rank | 7th | 1st | 7th | 1st | 4th | 1st | 7th | 7th | 4th | 11th | 4th | 11th | 11th |
<tbody>
</tbody>
Last edited: