HELP! need a top 10 from a list of 100

[duffy]

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

 

[Guest]

Copy the two columns to the separate worksheet and sort by sales, descending.
Then select the top ten entries

 

[Peo Sjoblom]

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

 

[Bob Phillips]

=INDEX(Sheet1!$A$1:$A$100,MATCH(LARGE(Sheet1!$B$1:$B$100,ROW(A1)),Sheet1!$B$
1:$B$100,0))

and copy down

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)