Dynamic Ranking

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?
 
P

Peo Sjoblom

It's probably faster to use multiple formulas than one giant..

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

Regards,

Peo Sjoblom
 

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

Find last date of sold stock and sold price. 2
Set up and printing a 4-up mail merged postcard 0
Incorporating the first 40 out of 250 rows in column values 3
auto sorting help needed thank you! 2
Nested IF Function 7
Solution to tricky problem of showing exactly Top N rows in Pivottable 0
INDEX function array causes problem when attempting to use LARGEfunction to sort positive and negati 10
Ranking - Not Sorting Properly. 16

Top