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. |
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 |
All times are GMT +1. The time now is 10:56 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com