3 league tables (f1)

[pmw19800]

Hello
I’m struggling to work out how you create a live league table on a different worksheet.

League Table tab
I would like this tab to automatically work out the points from Races Scores tab and then ultimately put the table in order of highest points 1st and so on. Without manual intervention


Please see attached

[JohnTopley]

Please add some sample results to your file.

[pmw19800]

hello John

Sample results added

[JohnTopley]

Try

in G3

=INDEX('Race Scores'!$F$17:$F$34,MATCH(LARGE('Race Scores'!$F$17:$F$34,ROWS($1:1)),'Race Scores'!$F$17:$F$34,0))

copy down

in B3

=INDEX('Race Scores'!A$17:A$34,MATCH($G3,'Race Scores'!$F$17:$F$34,0))

copy across to F and down

format columns C to F to suppress (hide) zeros

as CUSTOM

0;0;;@

Repeat similar formulae for other tables

See sheet "League table2" in attached

[FlameRetired]

In Driver A League Table there is need to settle ties.

Do the LARGE formula again in L3 and fill down.

Then array enter this formula in K3 and fill down. 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.

=INDEX('Race Scores'!$A$17:$A$34,MATCH(LARGE('Race Scores'!$D$17:$D$34-(ROW($A$3:$A$20)-MIN(ROW($A$3:$A$20))+1)/10^5,ROWS($3:3)),'Race Scores'!$D$17:$D$34-(ROW($A$3:$A$20)-MIN(ROW($A$3:$A$20))+1)/10^5,0))

[JohnTopley]

Re Dave's reply: applies to ALL tables.

The attached has Dave's formula applied to all tables.