| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Top 50 Customers
Have you tried datafilterautofilter
-- Don Guillett SalesAid Software "Nigel" wrote in message ... I have a spreadsheet with Customers in Col A and Sales for 2005 in Column B. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Top 50 Customers
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count my Customers | Excel Worksheet Functions | |||
| Listen to Your Customers | Excel Discussion (Misc queries) | |||
| summary of customers? | Excel Worksheet Functions | |||
| How many new customers every month? | Excel Programming | |||
| Top 5 customers | Excel Programming | |||
Linear Mode
