I am using the following formula to rank some sesults. I am getting some
reapeting numbers.(In the "Place" column)
{=SUM(1*(D7$D$7:$D$22))+1+IF(ROW(D7)-ROW($D$7)=0,0,SUM(1*(D7=OFFSET($D$1,0,0,INDEX(ROW( D7)-ROW($D$7)+1,1)-1,1))))} Is ther any way for this not happen?
Goat Tail Tying Stake Race

Time Points Place Time Points Place

12.00 7 1 74.00 10
45.00 #### 7 85.00 11
NT #### 13 NT 13
89.00 #### 10 14.00 2
56.00 #### 8 25.00 4
23.00 4 3 36.00 6
12.00 7 1 14.00 2
25.00 3 4 NT 13
36.00 2 5 12.00 1
NT #### 14 32.00 5
NT #### 14 65.00 8
96.00 #### 12 98.00 12
82.00 #### 9 NT 14
NT #### 14 71.00 9
93.00 #### 11 NT 15
39.00 1 6 55.00 7

Secondly, I am using the following forula to calculate the "points" column.
=IF(F7=1,7,IF(F7=2,5,IF(F7=3,4,IF(F7=4,3,IF(F7=5,2 ,IF(F7=6,1)))))) Is there
any way to not have the #### in the rest of the column? Any help with this
would be great.
Thanks
J.W.