Live League table

hello

Please see attahed

I want to create a league table that automatically updates when data is entered,

Table needs to display highest points 1st, but also needs to count the number of submissions


Paul

OR,

Try the following:

In L3:

Please Login or Register  to view this content.

In K3:

Please Login or Register  to view this content.

In J3:

Please Login or Register  to view this content.

See the attached file.

I've added a helper column (E) to segregate the total points.

In E3:

Please Login or Register  to view this content.

See the attached file.

i'm not sure what i've done wrong.. i've pasted the formula down and seems to have gone wrong

i thought it would automatically work out the rest

Hi,

Modify the formula in J3 as following:

Please Login or Register  to view this content.

array entered - press CTRL+SHIFT+ENTER to confirm.