How about a pivot table? You can do an advanced field setting for to retrun
the top 50...
--
HTH...

Jim Thomlinson


"Nigel" wrote:

I have a spreadsheet with Customers in Col A and Sales for 2005 in Column B.
What I want to be able to do is look thru Column B and find the top 50
Customers and then return the results into a new worksheet.

ANyone know how I would be able to do it

Thanks