You can use the LARGE function to find the top-10 values, and then use
INDEX/MATCH to return the names of those stocks. Give details of your
data layout if you want help with the actual formulas.

Hope this helps.

Pete

On Oct 12, 10:22 am, Hutchy wrote:
Hi

I have a list of sixty stocks with the corresponding market value of each
holding. Is there a way to extract the shares that have the top 10 market
values from this list?

Thanks
--
H