Automatic Sorting

**paulwelburn** · 05-11-2007, 05:33 AM

I have a table which holds scores as well as other data for players. Is it possible to automatically sort a table based on their points score to see who is top of the league?

**oldchippy** · 05-11-2007, 06:17 AM

Put headings to your data if you haven't already, then select your data, go to Data > Filter > Autofilter

**paulwelburn** · 05-11-2007, 07:29 AM

Tried that already. Sorry should have mentioned that the league table takes it's data from other worksheets therefore I want the league table to adjust automatically preventing me from having to filter manually using drop list options.
Any ideas?
Thanx for ur help anyway.

**Flintstone** · 05-11-2007, 05:09 PM

Hello Paulwelburn:

Assuming the names are in column A, range A2:A20 and their scores are in column B, range B2:B20.

Paste this formula in cell D2 and copy down to row 20.

=IF(B2="","",RANK(B2,B$2:B$20,1)+ROW()/100000)

Paste this formula in cell E2 and copy down to row 20.

=IF(ISERR(LARGE(D:D,ROW(1:1))),"",OFFSET(A$1,MID(LARGE(D:D,ROW(1:1)),FIND(".",LARGE(D:D,ROW(1:1))),6)*100000-1,0))

Paste this formula in cell F2 and copy down to row 20.

=IF(ISERR(LARGE(D:D,ROW(1:1))),"",OFFSET(B$1,MID(LARGE(D:D,ROW(1:1)),FIND(".",LARGE(D:D,ROW(1:1))),6)*100000-1,0))

Hide column D.

Matt

**paulwelburn** · 05-12-2007, 07:30 PM

Thanks for your help but the above doesn't seem to work. The automatic sorting needs to take all the data in the particular players' row into consideration when sorting on the Stableford Points (see file attached). I haven't delved into the functions and need to get to understand how they work. Can you change the function to fit the criteria in the sheet? Thanks in advance.

**Flintstone** · 05-14-2007, 03:38 PM

Sorry Paul Im afraid I don't know much about golf, I have no idea what you want sorted.

You stated, "The automatic sorting needs to take all the data in the particular players' row", I only see one particular player here. I need more info.