Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sorting issue
I have two worksheets, one that has data and the other is a summary
of the data. In one column have states and I want the summary sheet to give me the top five states and their percentages. This data changes all the time so I cannot do a simple data sort. Please help. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sorting issue
On Feb 20, 11:34*am, Maggie wrote:
I have two worksheets, one that has data and the other is a summary of the data. *In one column have states and I want the summary sheet to give me the top five states and their percentages. *This data changes all the time so I cannot do a simple data sort. *Please help. Maggie, Do you have some more information for this? Is the data automatically updated (i.e. a set number of records), is the data the result of a query wherein the range expands/contracts based on new entries over time, etc.? Have you tried using the RANK function and then sort the data via the rank column? Or use the RANK function to return the respective rank and then use a VLOOKUP (lookup_value = 1 - 5, table_array = left column of the table is the column with the RANK function, ....) based on the rank numbers to create a table for numbers 1 - 5? Matt |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting issue | Excel Worksheet Functions | |||
Sorting Issue - Any help? | Excel Worksheet Functions | |||
Sorting issue | Excel Programming | |||
Sorting Issue | Excel Discussion (Misc queries) | |||
Sorting issue | Excel Programming |