Order a list according to a range of values

[Mitchchimp]

Hi, I want to have my league table adjust itself so that the person in column A with the highest value of points in column B ( or C if that's easier)? What may be complicating things is that I already have the following formulas in:

A: =another cell reference to pull the persons name through from another worksheet
B: =SUM(of that persons points from another worksheet)
C: =RANK(B2,$B$2:$B$19,0)

what I have been trying (and failing) to do is have the name appear in column A, but also have A2:A19 to sort themselves based on the values in B (or C)

any help gratefully received. thanks folks

[AliGW]

Thanks for changing the title.

[FlameRetired]

Do you mean something like this?

In E2 filled down and across.

Please Login or Register  to view this content.

	A	B	C	D	E	F
1	Punter	Points	Current Position		Punter	Points
2	Mitch	18	2		John Young 0304	19
3	John Young 0304	19	1		Mitch	18
4	Tom & Will Leedy	17	3		Tom & Will Leedy	17
5	Player 4	16	4		Player 4	16
6	Player 12	8	12		Player 5	15
7	Player 8	12	8		Player 6	14
8	Player 16	4	16		Player 7	13
9	Player 10	10	10		Player 8	12
10	Player 7	13	7		Player 9	11
11	Player 19	1	18		Player 10	10
12	Player 9	11	9		Player 11	9
13	Player 14	6	14		Player 12	8
14	Player 11	9	11		Player 13	7
15	Player 18	2	17		Player 14	6
16	Player 13	7	13		Player 15	5
17	Player 15	5	15		Player 16	4
18	Player 5	15	5		Player 18	2
19	Player 6	14	6		Player 19	1

[Mitchchimp]

Perfect! Thanks so much.

[FlameRetired]

You are welcome. Thank you for the feedback.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.