Filtering and Sorting

[Abilio]

I' d like to ask if someone has a macro routine to sort and filter a numeric
column h, I need to find the highest 25 values and organize them in
descending order.

I really appreciate the help,

Abilio

[Ron de Bruin]

Why don't you use formulas in B1:B25

With the numbers in A1:A100

In B1
=LARGE($A$1:$A$100,ROW())

Copy down to B25


This is a array formula, see
http://www.cpearson.com/excel/array.htm



--
Regards Ron de Bruin
http://www.rondebruin.nl


"Abilio" <[email protected]> wrote in message news:[email protected]...
> I' d like to ask if someone has a macro routine to sort and filter a numeric
> column h, I need to find the highest 25 values and organize them in
> descending order.
>
> I really appreciate the help,
>
> Abilio
>

[Ron de Bruin]

Oops

Forget this part, it is a normal formula

> This is a array formula, see
> http://www.cpearson.com/excel/array.htm



--
Regards Ron de Bruin
http://www.rondebruin.nl


"Ron de Bruin" <[email protected]> wrote in message news:O3qhI0n%[email protected]...
> Why don't you use formulas in B1:B25
>
> With the numbers in A1:A100
>
> In B1
> =LARGE($A$1:$A$100,ROW())
>
> Copy down to B25
>
>
> This is a array formula, see
> http://www.cpearson.com/excel/array.htm
>
>
>
> --
> Regards Ron de Bruin
> http://www.rondebruin.nl
>
>
> "Abilio" <[email protected]> wrote in message news:[email protected]...
>> I' d like to ask if someone has a macro routine to sort and filter a numeric
>> column h, I need to find the highest 25 values and organize them in
>> descending order.
>>
>> I really appreciate the help,
>>
>> Abilio
>>
>
>