Forum Discussion
Excel 2016: Calculate the median of the 20 peers that are closest in terms of total assets
similar question than last time. I'm trying to calculate the median P/E ratio of the 20 firms that are closest to the firm to be valued in terms of total assets. I got all my company (S&P 500) ticke...
Got one more question. Now I want to combine TA and ROE. The objective is to find the 5 companies closest to the target company in terms of TA and then the 3 companies from those 5 which are closest in terms of ROE!
Any idea how to solve that problem?
Test file available here: https://we.tl/rNIrgWL9h8
Thank you so much for helping out guys!