update league table

**stevesunfold** · 08-17-2008, 03:04 AM

good morning everyone
im here to pick the intelligent brains here as this wally cant work it out

i have a sheet labelled totals and wish to make a league table that automatically puts people in points order

in cell a1 i have a name and in b1 i have there total
cell a4 a name and b4 a total
cell a7 a name and b7 a total
cell a10 a name and b10 a total
cell a13 a name and b13 a total
cell a16 a name and b16 a total

i want to make a sheet named table and have these automatically updated so that i can see who id top and bottom etc

is this possible?

thanks in advance
there is something else to this but best not to go further yet unless this is possible

**Simon Lloyd** · 08-17-2008, 04:28 AM

You need to take a look at the RANK function.

**stevesunfold** · 08-17-2008, 04:31 AM

ive never used that simon so dont know where to start.
care to elaborate?

**Simon Lloyd** · 08-17-2008, 04:36 AM

It's explained really well here

**stevesunfold** · 08-17-2008, 04:38 AM

out of my league that but thanks

**Simon Lloyd** · 08-17-2008, 04:44 AM

Seriously, it isn't out of your league, follow Chips examples carefully one by one, you will see how the results unfold and allow you to apply it to your situation.

**stevesunfold** · 08-17-2008, 04:51 AM

cheers simon
think i will get confused cos the data i need is on another sheet though

**ratcat** · 08-17-2008, 07:03 AM

G'day guys,

If I may......

I've attached an example.

Look at 'Votes Leaderboard' col G it looks at col Q.

And all the data for the competiton ladder comes for another spreadsheet.

Also there is a macro (click on 'competition Ladder' heading) to sort the ranking after entering the weekend scores.

Cheers

**stevesunfold** · 08-17-2008, 07:24 AM

thanks rat
now going to take a look

update league table

LinkBack

Thread Tools

Rate This Thread

Display

update league table

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions