Dynamic Ranking

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

Guest

I have 8 columns that need to be "re-sorted" everytime
there is a real-time stocl price change. I am using the
Large function to sort the price change, then using
Index/match to associate the stock to that price. For 8
different sorts, it is very taxing on the PC. Any
suggestions to maybe sort price change and stock together
in one formula instead of two?
 
It's probably faster to use multiple formulas than one giant..

--
For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

What's the best way to set this formula up? 0
Find last date of sold stock and sold price. 2
Last value in row 5
Using a new column to flag changes in other fields 1
Nested IF Function 7
Incorporating the first 40 out of 250 rows in column values 3
auto sorting help needed thank you! 2
auto sort 6

Back
Top