auto sorting

[njlevi49]

If I have a sheet with (see below) this is 2 columns lets say z and aa. aa has a formula to pull data from within this sheet I would like it to automatically sort largest to smallest. can someone give me a clue?[TABLE="width: 167"]
<tbody>[TR]
[TD]4 Ponkey/Levi[/TD]
[TD="align: right"]18[/TD]
[/TR]
[TR]
[TD]2 Fitch/Poet[/TD]
[TD="align: right"]15[/TD]
[/TR]
[TR]
[TD]1 Isbister/Howe[/TD]
[TD="align: right"]12[/TD]
[/TR]
[TR]
[TD]3 Hanlon/Dougherty[/TD]
[TD="align: right"]8[/TD]
[/TR]
[TR]
[TD]5 Raukar/Itami[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD]6 Emeott/Hahn[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]7 Grodzicki/Campau[/TD]
[TD="align: right"]0[/TD]
[/TR]
</tbody><colgroup><col><col></colgroup>[/TABLE]

 

[Armando Montes]

One way here:
Sorting Text Alphabetically using Excel Formulas | Chandoo.org - Learn Microsoft Excel Online