Top 50 Customers

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

Have you tried data>filter>autofilter>

--
Don Guillett
SalesAid Software
donaldb@281.com
"Nigel" <nigelben@belmontpines.com> wrote in message
news:79E18677-D8E4-4B32-9CC5-73E98CE93D43@microsoft.com...
> 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

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