Top 10

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

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]