Forum Discussion
Smarter way to identify the top n in a list of stocks
Hi Can anyone suggest a smarter way to do this? I am using Excel 2019 My Goal: Keep track of Stocks, ETFs and Mutual funds, based on dividends and an amount to invest. I have a Database excel ...
Unfortunately I do not have Excel 365.
All I am trying to do is make sublists of a Bigger list and then identify the top 10 rows of each sublist. I need to be able to add new elements to the Big List and have the sublists be updated accordingly
All I am trying to do is make sublists of a Bigger list and then identify the top 10 rows of each sublist. I need to be able to add new elements to the Big List and have the sublists be updated accordingly
- Do I need to create 3 pivot tables ?