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

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

Thanks. I'll try to string the functions together and if I have any problems
I will get back to you.
--
H


"Pete_UK" wrote:

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

You're welcome.

Pete

On Oct 12, 11:10 am, Hutchy wrote:
Thanks. I'll try to string the functions together and if I have any problems
I will get back to you.
--
H



"Pete_UK" wrote:
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- Hide quoted text -

- Show quoted text -