G
Guest
I have a range of data that I input into Sheet 1, range A1:B11:
Name Score
Allan 10
Jane 9
Gary 7
Steven 5
Robert 10
June 7
Sheila 8
Diane 4
Laura 9
Carolyn 5
And I want to be able to return, in an order, the following data (displayed
in Sheet 2, Range A1:C11):
Rank Name Score
1 Allan 10
1 Robert 10
3 Jane 9
3 Laura 9
5 Sheila 8
6 Gary 7
6 June 7
8 Steven 5
8 Carolyn 5
10 Diane 4
What formulae would I put into cells A2, B2 and C2 in Sheet 2 that I could
then copy and paste down to cells A11, B11 and C11 respectively that would
allow me to return the data as I intend?
Regards
Name Score
Allan 10
Jane 9
Gary 7
Steven 5
Robert 10
June 7
Sheila 8
Diane 4
Laura 9
Carolyn 5
And I want to be able to return, in an order, the following data (displayed
in Sheet 2, Range A1:C11):
Rank Name Score
1 Allan 10
1 Robert 10
3 Jane 9
3 Laura 9
5 Sheila 8
6 Gary 7
6 June 7
8 Steven 5
8 Carolyn 5
10 Diane 4
What formulae would I put into cells A2, B2 and C2 in Sheet 2 that I could
then copy and paste down to cells A11, B11 and C11 respectively that would
allow me to return the data as I intend?
Regards