Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Reapeting Numbers From A Formula
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Change Row Numbers in Formula with Macro | Excel Discussion (Misc queries) | |||
Re What is the formula for adding multiple numbers in a cell | Excel Discussion (Misc queries) | |||
Is there a formula to convert numbers to written text in Excel? | Excel Worksheet Functions | |||
How to Replace numbers and text with numbers only? | Excel Worksheet Functions |