FreakyGirl
Member
hello
i run a monthly contest that has ties that need to be broken down further.
i am down to the last column & having trouble getting it to work properly.
column AC: rank 1 sum of 6 high scores
column AD: rank 2 the indiv. scores that make the sum of 6
column AE: rank 3 columns AC & AD concentated
column AF: rank 4 check for num of games played. if same number then put total score at end of number. else put a 00
column AG: rank 5 add a players raw score to end of prev column number.
column AH: rank 6 check the raw score for any ties. if tied put the number shown in AL. else put a 00
column AI: rank 7 add a players lowest score to end of prev column number.
to this point everything seems to be working correctly.
column AJ: rank 8 add a players 2nd lowest score to end of prev column number
the problem with this column is its not picking up the number in column AN for some reason.
its a very simple formula
& works correctly in the prev column.
as always any help would be appreciated.
thanks,
FreakyGirl
i run a monthly contest that has ties that need to be broken down further.
i am down to the last column & having trouble getting it to work properly.
column AC: rank 1 sum of 6 high scores
column AD: rank 2 the indiv. scores that make the sum of 6
column AE: rank 3 columns AC & AD concentated
column AF: rank 4 check for num of games played. if same number then put total score at end of number. else put a 00
column AG: rank 5 add a players raw score to end of prev column number.
column AH: rank 6 check the raw score for any ties. if tied put the number shown in AL. else put a 00
column AI: rank 7 add a players lowest score to end of prev column number.
to this point everything seems to be working correctly.
column AJ: rank 8 add a players 2nd lowest score to end of prev column number
the problem with this column is its not picking up the number in column AN for some reason.
its a very simple formula
Code:
=VALUE(AI22*10+AN22)
as always any help would be appreciated.
thanks,
FreakyGirl
Attachments

345 KB Views: 8