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