HELP! need a top 10 from a list of 100

  • Thread starter Thread starter duffy
  • Start date Start date
D

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
 
Copy the two columns to the separate worksheet and sort by sales, descending.
Then select the top ten entries
 
=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)
 
Back
Top