http://www.cpearson.com/excel/rank.htm


--

Regards,

Peo Sjoblom

"duffy" <u17038@uwe wrote in message news:5985298a7057b@uwe...
help required. i need to establish a top 10 from a list of 100 sellers.
for example,
seller sales
bob 5
ann 8
tim 7
etc etc
the top 10 needs to be automatically updated on a seperate worksheet when
the
sales column is updated.
any help appreciated.
duffy