Dear All:
I have attached an excel file for reference.
I have a data set of stock names and price and change in prices which updates itself everyday and need top 5 gainers of the day.
steps i did:
1.ranked them by rank formula.
2. applied index and match formula to pick the names of and prices of those stocks based on the ranks.
it seem to be working fine when all stocks % change in prices are different, but, when some stocks increase by same %, it gives them the same rank then my table doesnt work properly as it will display only 1 from the rank.
I want it to show all the companies in that rank.
I have attached a file to illustrate the issue.
plus any suggestions if there is a more efficient way of doing this.
Bookmarks