Player Rank Calculation

Dear experts,

I am trying to calculate players ranking based on their weight categories and attempts total, e.g. Category (50kg, 69kg etc..) Rank should be calculated automatically the highest total value of cat. 50kg is 1st second highest is 2nd etc. However, if tow players or more within the same Category have scored same point ranking will be calculated based on Body Weight less comes first and if both have similar weight calculation will be based on Start # first player comes first etc..

Table:

Start #	Name	Body Weight	Team	Category	Total Point	Rank
1	Player #1	49.2	Team #1	50kg	75
2	Player #2	48.1	Team #2	50kg	75
3	Player #3	48.1	Team #3	50kg	75
4	Player #4	49.5	Team #4	50kg	77
5	Player #5	66.5	Team #1	69kg	94
6	Player #5	67.5	Team #1	69kg	95
7	Player #5	67.5	Team #1	69kg	95
8	Player #5	67.5	Team #1	69kg	98

thanks.

Thanks Wayne, couldn't solve it with suggested link, it provides ranking based on sorting only whereas my formula should compare four columns (Category, Total Point, Body Weight and Start). I'm currently using SUMPRODUCT() comparing (Category and Total Point) and looking to add the rest (Weight and Start)

=IF(F2>0,SUMPRODUCT(--(E2=E$2:E9))-SUMPRODUCT(--(((E2*F2)>(E$2:E9*F$2:F9))*(E2=E$2:E:9))),0)

Note: category in my original sheet is a number 50, 69..