Hi All

I'm getting there with a lot of help from users of this forum , but need more
I have a list of 20 names in column C and corresponding scores in column E, preview below


Roy Smith 1st 20
Allan Morley 2nd 19
Gwen Yates 4th 17
Eddie Telford 6th 15
John Lyon 7th 14
Allan Morley 8th 13
Rhonda Moodley 9th 12
Graeme Eccles 10th 11
David Blatchford 11th 10
Gwen Yates 12th 9
Gwen Yates 13th 8
Allan Morley 14th 7
Graeme Eccles 15th 6
John Donaldson 16th 5
David Blatchford 17th 4
Graham Taylor 19th 2
Graham Taylor 20th 1

As you can see the same member has more than 1 score, what I need is to populate other columns with members name and individual scores, as below

Allan Morley 19 7
Gwen Yates 9 8

Is this possible

Thanks in advance

Johnny