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.