| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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: |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| extract duplicat values | Excel Discussion (Misc queries) | |||
| Extract values off a chart??? | Charts and Charting in Excel | |||
| Filter records in a table to extract to another table | Excel Discussion (Misc queries) | |||
| Extract values from formulas | Excel Discussion (Misc queries) | |||
| Extract Unique Values, Then Extract Again to Remove Suffixes | Excel Discussion (Misc queries) | |||
Threaded Mode
