Sorting issue

[Maggie]

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.

 

[meh2030]

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