Selecting

[Hutchy]

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

 

[Pete_UK]

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

 

[Hutchy]

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

 

[Pete_UK]

You're welcome.

Pete

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






- Show quoted text -