Hi all,
<tbody>
A
C
D
E
R
S
T
1
Paper
Rank
Div Rank 1
Div Rank 2
Score
Diversity Score 1
Diversity Score 2
2
Andover
1
#REF !
#REF !
80
80
#REF !
3
Andover
2
#REF !
#REF !
64
54
#REF !
4
Andover
3
#REF !
#REF !
62
62
#REF !
</tbody>
In Column C, the formula is...