Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sort and Extract
I would like to perform the following functions within a macro:
- I start with a long list of rows listing securities within various portfolios; Column A identifies the name of the portfolio, Column B lists the name of the underlying security, and Column C lists its weight in the portfolio - I wish to sort the list as follows: primary key as Col A (the name of the portfolio), then descending order of Column C - I then wish to extract the "top 10" securities of each portfolio in a simple list Rather than seeing the entire list of ALL securities in the portfolio, is there a way to simply extract the "TOP 10"? Thanks in advance. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sort and Extract
On Wed, 25 Feb 2009 02:09:01 -0800, Eric_G
wrote: I would like to perform the following functions within a macro: - I start with a long list of rows listing securities within various portfolios; Column A identifies the name of the portfolio, Column B lists the name of the underlying security, and Column C lists its weight in the portfolio - I wish to sort the list as follows: primary key as Col A (the name of the portfolio), then descending order of Column C - I then wish to extract the "top 10" securities of each portfolio in a simple list Rather than seeing the entire list of ALL securities in the portfolio, is there a way to simply extract the "TOP 10"? Thanks in advance. After sorting, you could use Filter or Advanced Filter. In XL2007, Filter has an option for Top 10; but I think even the older versions have an option for values greater or equal. If you are using the regular filter, after creating the list, in order to "extract" it; select the table. Then execute GoTo Special "Visible cells only". Then Edit/Copy ; select a destination ; edit/paste --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sort and Extract Macro | Excel Programming | |||
Sort and Extract Macro | Excel Programming | |||
Data Extract and sort | Excel Programming | |||
extract data after sort | Excel Programming | |||
extract and sort dates | Excel Discussion (Misc queries) |