• Hi Guys,


    I need you help.


    Can you help me getting the top 10:


    For example


    Column A


    I have


    11
    10
    9
    8
    7
    6
    7
    5
    5
    3
    2


    and i need to get the top10 and transfer it to sheet2
    so the output should be


    11
    10
    9
    8
    7
    6
    7
    5
    5
    3
    2


    Thanks for your help

  • Re: Top 10


    pivot table can do that job for you. Reading your question again I see you already have a Top 10 so you can refer to that range in Sheet 1 (if you stand in sheet 2).

  • Re: Top 10


    Hi.


    I want to use VBA.


    For example.


    Sheet1 Column A The value are


    6
    7
    20
    34
    54
    65
    76
    345
    65
    34
    56
    5345


    and then I will add a button in sheet2 so when I click the button the output will be in the column a sheet2 is


    [TABLE="width: 48"]

    [tr]


    [TD="class: xl63, width: 64, bgcolor: transparent, align: right"]5345[/TD]

    [/tr]


    [tr]


    [TD="class: xl63, bgcolor: transparent, align: right"]345[/TD]

    [/tr]


    [tr]


    [TD="class: xl63, bgcolor: transparent, align: right"]76[/TD]

    [/tr]


    [tr]


    [TD="class: xl63, bgcolor: transparent, align: right"]65[/TD]

    [/tr]


    [tr]


    [TD="class: xl63, bgcolor: transparent, align: right"]65[/TD]

    [/tr]


    [tr]


    [TD="class: xl63, bgcolor: transparent, align: right"]56[/TD]

    [/tr]


    [tr]


    [TD="class: xl63, bgcolor: transparent, align: right"]54[/TD]

    [/tr]


    [tr]


    [TD="class: xl63, bgcolor: transparent, align: right"]34[/TD]

    [/tr]


    [tr]


    [TD="class: xl63, bgcolor: transparent, align: right"]34[/TD]

    [/tr]


    [tr]


    [TD="class: xl63, bgcolor: transparent, align: right"]20
    Thanks !!
    [/TD]

    [/tr]


    [/TABLE]

Participate now!

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