Ranking/Points

[Saxman]

I have the following figures in columns A,B,C,D,G and H.

53 42 82 25 1 25
74 82 72 20 2 20
71 70 71 15 3 15
72 72 68 10 4 10
65 68 63 5 5 5
63 63 53
52 51 52
45 45 45

The above finds the highest of adjacent cells in A and B. Column C sorts the highest
from A and B. Points are awarded in column D from columns G and H.

The following function is in cell C1.

=LARGE(IF($A$1:$A$8>$B$1:$B$8,$A$1:$A$8,$B$1:$B$8),ROW(A1))

The following function is in cell D1.

=IF(ISERROR(VLOOKUP(RANK(C1,C$1:C$8),G$1:H$5,2,FALSE)),"",VLOOKUP(RANK(C1,C$1:C$8),G$
1:H$5,2,FALSE))

Is it possible to not sort column C and award points in column D as they appear?
--

 

[Saxman]

I have the following figures in columns A,B,C,D,G and H.

53 42 82 25 1 25
74 82 72 20 2 20
71 70 71 15 3 15
72 72 68 10 4 10
65 68 63 5 5 5
63 63 53
52 51 52
45 45 45

The above finds the highest of adjacent cells in A and B. Column C sorts the
highest from A and B. Points are awarded in column D from columns G and H.

The following function is in cell C1.

=LARGE(IF($A$1:$A$8>$B$1:$B$8,$A$1:$A$8,$B$1:$B$8),ROW(A1))

The following function is in cell D1.

=IF(ISERROR(VLOOKUP(RANK(C1,C$1:C$8),G$1:H$5,2,FALSE)),"",VLOOKUP(RANK(C1,C$1:C$8),
G$ 1:H$5,2,FALSE))

Is it possible to not sort column C and award points in column D as they appear?

I just did it myself!

Replaced the first function with this.

=(IF($A$1:$A$8>$B$1:$B$8,$A$1:$A$8,$B$1:$B$8))

--