Please Help Excel Rank Dilemma

Here's one way: The SORTBY function will sort the entire table, listing the names (and remaining columns) in the desired order. (By the way, you didn't specify that the rankings are by low score, not high; that's a key part of the definition of the problem; you perhaps took it for granted),

=SORTBY(A4:D10,B4:B10,-1,C4:C10,-1,D4:D10,-1)

Here's what it looks like (absent headers)

See attached for the working example.