Automatic Table Updating

[LSF]

Hi,

i'm using excel to keep track of our poker tournament,
how do i get the table to automaticaly put the person who has the most points on top, 2nd most 2nd etc..

NE time i update it I have to go to >sort, sort by...

its something like a football table where you fill in results and it does the table for you



Any help much appriciated

[ravishankar]

Hi
if your data is in col A, B1= large(A:A,1) change 1 to 2,3,4.... etc
Ravi