| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
List in order of greatest to least
I need to be able to extract from a table of data and list on a seperate page
the top 10 Agents. I need the list to show name and how many times. I need this based on the top 10 agents. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
List in order of greatest to least
Have you tried using AutoFilter, located on the DATA option of the Excel menu
-- Kevin Backmann "Mike F." wrote: I need to be able to extract from a table of data and list on a seperate page the top 10 Agents. I need the list to show name and how many times. I need this based on the top 10 agents. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
List in order of greatest to least
Thanks for the advice but I need the data to appear on a seperate sheet and
in order from the greatest to the least, autoffilter does not sort the information in that order. Mike F "Kevin B" wrote: Have you tried using AutoFilter, located on the DATA option of the Excel menu -- Kevin Backmann "Mike F." wrote: I need to be able to extract from a table of data and list on a seperate page the top 10 Agents. I need the list to show name and how many times. I need this based on the top 10 agents. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
List in order of greatest to least
Try Advanced Filter.
-- Brevity is the soul of wit. "Mike F." wrote: Thanks for the advice but I need the data to appear on a seperate sheet and in order from the greatest to the least, autoffilter does not sort the information in that order. Mike F "Kevin B" wrote: Have you tried using AutoFilter, located on the DATA option of the Excel menu -- Kevin Backmann "Mike F." wrote: I need to be able to extract from a table of data and list on a seperate page the top 10 Agents. I need the list to show name and how many times. I need this based on the top 10 agents. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
List in order of greatest to least
Not sure what data determines the top 10 but look at the LARGE function to
see whether that will meet your need. "Mike F." wrote: Thanks for the advice but I need the data to appear on a seperate sheet and in order from the greatest to the least, autoffilter does not sort the information in that order. Mike F "Kevin B" wrote: Have you tried using AutoFilter, located on the DATA option of the Excel menu -- Kevin Backmann "Mike F." wrote: I need to be able to extract from a table of data and list on a seperate page the top 10 Agents. I need the list to show name and how many times. I need this based on the top 10 agents. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
List in order of greatest to least
Use COUNTIF on the criteria of your agents. Are you looking for the agents
who are listed the most? You'll need to run a COUNTIF on all the names of the agents. Delineate your source list to a new worksheet that lists each agent once. Run a COUNTIF for each cell (agent), then sort by the column that holds the numbers for each agent...in descending order. "Mike F." wrote: I need to be able to extract from a table of data and list on a seperate page the top 10 Agents. I need the list to show name and how many times. I need this based on the top 10 agents. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Subtotals in a list | Excel Discussion (Misc queries) | |||
| Need help with mailing list | Excel Discussion (Misc queries) | |||
| update data validation list with new entries?? | Excel Discussion (Misc queries) | |||
| How may I make a list display in alphabetical order in Excel? | Excel Discussion (Misc queries) | |||
| How do you sort a list of dates into date order | Excel Discussion (Misc queries) | |||
Linear Mode
