=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)

"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