Selecting

H

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
 
P

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
 
H

Hutchy

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