Formulas: Advanced Filters

  • I have attached a spreadsheet with information that I would like to break down by the top 10 people in three different categories.


    I need to find out the top 10 for people under colums:
    ACTSMTD, PWMTD AND IWMTD


    I hope you can help me design a filter to place these top 10 people to the right of this worksheet

  • Name FirstCol SecondCol ThirdCol 4thCol
    Name One 7 $13 136 $189
    Name Two 3 $10 112 $398
    Name Three 1 $18 158 $115
    .......
    Name TwoThousand etc...


    This is sort of how the data is set up and I need to find out who the top 10 people for each of the four colums are. If this helps great.

  • Hi Cronina,


    Try the following macro - it just uses the built in AutoFilter function with the "Top 10" selection then copy and paste the results to the right. (Assumes your data is in Col A - E)




    .....Ralph

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!