Forum Discussion

PV398's avatar
PV398
Copper Contributor
May 13, 2023

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 ...
Excel
Formulas and Functions
Detlef_Lewin's avatar
Detlef_Lewin
Silver Contributor

PV398 

I would suggest a pivot table with Top10 filter.

 

PV398's avatar
PV398
Copper Contributor
May 14, 2023
Do I need to create 3 pivot tables ?
  • Detlef_Lewin's avatar
    Detlef_Lewin
    Silver Contributor
    May 14, 2023

    PV398 

    At least two pivot tables.

    One for ALL and one for the other two categories.

     

Resources