Selecting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Thanks. I'll try to string the functions together and if I have any problems
I will get back to you.
 
Back
Top