MAX Score From Multiple Column & Reference

[sifoo8]

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]C[/TD]
[TD="align: center"]D[/TD]
[TD="align: center"]E[/TD]
[TD="align: center"]F[/TD]
[TD="align: center"]G[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]NAME
[/TD]
[TD]CAT.
[/TD]
[TD]GROUP
[/TD]
[TD]G1
[/TD]
[TD]G2
[/TD]
[TD]G3
[/TD]
[TD]TOTAL
[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Norm[/TD]
[TD]W[/TD]
[TD]UPA[/TD]
[TD]180[/TD]
[TD]112[/TD]
[TD]100[/TD]
[TD]392[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Amir[/TD]
[TD]W[/TD]
[TD]UPA[/TD]
[TD]150[/TD]
[TD]128[/TD]
[TD]150[/TD]
[TD]428[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]John[/TD]
[TD]L[/TD]
[TD]PADS[/TD]
[TD]125[/TD]
[TD]89[/TD]
[TD]150[/TD]
[TD]364[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]Mariah[/TD]
[TD]W[/TD]
[TD]PADS[/TD]
[TD]123[/TD]
[TD]90[/TD]
[TD]125[/TD]
[TD]338[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]Bob[/TD]
[TD]L[/TD]
[TD]LUCKY[/TD]
[TD]200[/TD]
[TD]145[/TD]
[TD]98[/TD]
[TD]443[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]Frank[/TD]
[TD]L[/TD]
[TD]LUCKY[/TD]
[TD]96[/TD]
[TD]123[/TD]
[TD]110[/TD]
[TD]329[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]Ann[/TD]
[TD]W[/TD]
[TD]TOPX[/TD]
[TD]89[/TD]
[TD]185[/TD]
[TD]150[/TD]
[TD]424[/TD]
[/TR]
</tbody>[/TABLE]

Need help. What is the excel formula for:
1) Who got the highest total marks from CAT.(W)
2) Who are the Top 3 highest marks

tq..

 

[estevaoba]

What are expected results in your sample?

 

[sifoo8]

expected result:
1) Amir from CAT.[W] 428
2) Top 3:
- Bob 443
- Amir 428
- Ann 424

 

[estevaoba]

For the first part, I type W in I1 and array enter this in I2 (or in other cells of your choosing, just to use a cell reference and not hard coding).
Array enter means, press and hold ctrl+shift keys while hitting enter key.

[TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64"]=MAX(IF(B2:B8=I1,G2:G8))[/TD]
[/TR]
</tbody>[/TABLE]

Then I enter this in J2 and copy across to L2:

[TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64"]=LARGE($G$2:$G$8,COLUMN(A$1))[/TD]
[/TR]
</tbody>[/TABLE]

Finally, I enter this in J1 and copy across to L1:

[TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64"]=IFERROR(INDEX($A$2:$A$8,MATCH(J2,$G$2:$G$8,0)),"")[/TD]
[/TR]
</tbody>[/TABLE]

 

[sifoo8]

Ok tq. But how to make Name & Total as result for question (1).