make an automated leaderboard

[ImDavQc]

I Want to make automated leaderboard, when i enter data its chance beetween rank like :


David - 7
Jeff - 10
Sylvain - 3
Paul - 1
Carl - 6

want it appears like
Rank 1 - Jeff - 10
Rank 2 - David - 7
Rank 3 - Carl - 6
Rank 4 - Sylvain - 3
Rank 5 - Paul - 1

if i had a new score like 3 poitns for Carl... want it go automatically

Rank 1 - Jeff - 10
Rank 2 - Carl - 9
Rank 3 - David - 7
Rank 4 - Sylvain - 3
Rank 5 - Paul - 1

[BlindAlley]

You should find everything you need in here and adapt it to what you require.

[FlameRetired]

With your data in columns A and B:
Enter this in E2 and fill down.

Please Login or Register  to view this content.

Then array-enter this formula in D2 and fill down.

Please Login or Register  to view this content.

If you aren’t familiar with array-entered formulas array enter means the formula must be committed from edit mode by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.

It does this.

Row\Col	A	B	C	D	E	F
2	David	7		Jeff	10	In E2 :=LARGE($B$2:$B$6,ROWS($1:1))
3	Jeff	10		David	7	In D2 :{=INDEX($A$2:$A$6,SMALL(IF($E2=$B$2:$B$6,ROW($A$2:$A$6)-MIN(ROW($A$2:$A$6))+1),COUNTIF($E$2:$E2,$E2)))}
4	Sylvain	3		Carl	6
5	Paul	1		Sylvain	3
6	Carl	6		Paul	1

Try changing Carl's score ... even making it a duplicate score.

[FlameRetired]

Withdrawn by FR

[ImDavQc]

found many thing usefull. thx

Now i want to had a 3rd columns with Position like :

Rank 1 - Jeff - 10 - Left Helper
Rank 2 - David - 7 - Right Helper
Rank 3 - Carl - 6 - Center
Rank 4 - Sylvain - 3 - Rigth Defense
Rank 5 - Paul - 1 - Left Defense

if i had a new score like 3 poitns for Carl... want it go automatically

Rank 1 - Jeff - 10 - Left Helper
Rank 2 - Carl - 9 - Center
Rank 3 - David - 7 - Right Helper
Rank 4 - Sylvain - 3 - Rigth Defense
Rank 5 - Paul - 1 - Left Defense

[newdoverman]

Column C enter and fill down:

Please Login or Register  to view this content.

Column G enter and fill down:

Please Login or Register  to view this content.

Column H enter and fill down:

Please Login or Register  to view this content.

Column I enter and fill down:

Please Login or Register  to view this content.

Result:

	A	B	C	D	E	F	G	H	I
1	Player	Position	Rank	Score			Leaderboard
2	Carl	Center	2	-5			Player	Score	Position
3	David	Right Helper	3	-4			Jeff	-9	Left Helper
4	Jeff	Left Helper	1	-9			Carl	-5	Center
5	Paul	Left Defense	5	0			David	-4	Right Helper
6	Sylvain	Right Defense	4	-2			Sylvain	-2	Right Defense
7							Paul	0	Left Defense

[ImDavQc]

tried it and every position place it write ?NOM..

I heard something too with =MATCH ........... but i dont know this function

[newdoverman]

You have made a spelling mistake in the formula.

[ImDavQc]

i have excel 2010, can it be the porblem.?

[newdoverman]

You don't say what solution that you are trying and failing with.

What I gave you was done with Excel 2010.