This post presents "how to" rank and sort market data using Excel's SORTBY, CHOOSECOLS, and TAKE functions. This method is a replacement for applying RANK and VLOOKUP functions for ranking and sorting market data.
This post "Dynamic Ranking in Excel," detailed the steps to ranking net %… more