View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Marcello do Guzman Marcello do Guzman is offline
external usenet poster
 
Posts: 22
Default How do you extract the top ten values in a table?

I have a table that includes five columns as follows:

Col 1 Col 2 Col 3 Col 4 Col 5

Lifestyle Cluster Radius 1 Radius 2 Radius 3 Combined

The table has 62 rows. Columns 2 through 5 are values (numbers). I
would like to be able extract from this table the top 9 values and
lump the sum of the other 53 values from column 5 and list them in
descending order without using the Data, Sort features in Excel. How
can I program this so that it performs this function and prodes a
listing?

Please respond via email: