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
 
Back
Top