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

Copy the two columns to the separate worksheet and sort by sales, descending.
Then select the top ten entries
--
Gary''s Student


"duffy" wrote:

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

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

=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