Season Ranking based on Season Winning %

[bamaguy]

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

[TABLE="width: 1678"]
<tbody>[TR]
[TD]ROW 2730: Season W/L %[/TD]
[TD]50.00%[/TD]
[TD]70.00%[/TD]
[TD]50.00%[/TD]
[TD]70.00%[/TD]
[TD]60.00%[/TD]
[TD]70.00%[/TD]
[TD]50.00%[/TD]
[TD]50.00%[/TD]
[TD]60.00%[/TD]
[TD]#DIV/0![/TD]
[TD]60.00%[/TD]
[TD]#DIV/0![/TD]
[TD]#DIV/0![/TD]
[/TR]
[TR]
[TD]ROW 2731:SeasonWinning%[/TD]
[TD]50.00%[/TD]
[TD]70.00%[/TD]
[TD]50.00%[/TD]
[TD]70.00%[/TD]
[TD]60.00%[/TD]
[TD]70.00%[/TD]
[TD]50.00%[/TD]
[TD]50.00%[/TD]
[TD]60.00%[/TD]
[TD]0.00%[/TD]
[TD]60.00%[/TD]
[TD]0.00%[/TD]
[TD]0.00%[/TD]
[/TR]
[TR]
[TD]ROW 2732: Season Rank[/TD]
[TD]7th[/TD]
[TD]1st[/TD]
[TD]7th[/TD]
[TD]1st[/TD]
[TD]4th[/TD]
[TD]1st[/TD]
[TD]7th[/TD]
[TD]7th[/TD]
[TD]4th[/TD]
[TD]11th[/TD]
[TD]4th[/TD]
[TD]11th[/TD]
[TD]11th[/TD]
[/TR]
</tbody>[/TABLE]