HELP! need a top 10 from a list of 100
 

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

HELP! need a top 10 from a list of 100
 

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

HELP! need a top 10 from a list of 100
 

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

HELP! need a top 10 from a list of 100
 

=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