Ranking and sorting a number with a dash, but not logically

Hello again.

Still to do with this cricket thing I have bugging me. I need to rank and sort a TOP 10 Best Bowling Figures, for some players. The 1st number before the "-" in Col B represents wickets. The higher the better so the highest here would always qualify for the list. The 2nd number after the "-" represents the number of runs given(against). The lower number here should appear above the higher number if it has the same number wickets taken to someone else.

EXAMPLE (using 11 names and figures):

Col A Col B
Walt 5-50
Tim 2-22
John 4-34
Hank 4-33
Jabba 3-45
Stuart 4-40
Chris 3-41
Chuck 3-56
Roy 5-49
Paul 2-20
Bob 4-18

What I want the Top 10 to end up as must look like this:

ROY 5-49
Walt 5-50
Bob 4-18
Hank 4-33
John 4-34
Stuart 4-40
Chris 3-41
Jabba 3-45
Chuck 3-56
Paul 2-20

Thanks for your help!

hi, my proposition:

Please Login or Register  to view this content.

Best regards,
Maras

Thanks for you help. In the end I came up with another way although not automated which I would of preferred.

1. I pulled the Top 10 into an automated range.
2. I then pasted values only into a new range.
3. I simply renumbered from 1 to 10 and then sorted manually by using the 1 to 10 numbering

Thanks though.