Hi aza,

I first entered data into the table to show every possible combination to check the query worked correctly

ID SN U C S TS STS
1 Alia 20 12 35 35 20
2 Vikram 14 28 3 28 14
3 Farah 17 23 29 29 23
4 Test 50 20 30 50 30
5 Test2 50 30 20 50 30
6 a1 1 2 3 3 2
7 a2 1 3 2 3 2
8 a3 2 1 3 3 2
9 a4 2 3 1 3 2
10 a5 3 1 2 3 2
11 a6 3 2 1 3 2
12 1 1 1 1 1

I then used Richard's Top Score

TopScore: IIf(([Uniform]>[Club] And [Uniform]>[Sports]),[Uniform],IIf(([Club]>[Uniform] And [Club]>[Sports]),[Club],[Sports]))

Now for the Second Top Score

IIf([Uniform]=[TopScore],IIf([Club]>[Sports],[Club],[Sports]),IIf([Club]=[TopScore],IIf([Uniform]>[Sports],[Uniform],[Sports]),IIf([Sports]=[TopScore],IIf([Uniform]>[Club],[Uniform],[Club]))))

This does quite a few checks.

Firstly is Uniform already the Top Score, if so check which is the highest out of the remaining two values and return that,
Then do the same for Club and Sports.
There is probably a better logical way of doing this, I'll keep working on it and post again if I figure it out,

Regards
Alex