ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Sort function (https://www.excelbanter.com/excel-worksheet-functions/145920-sort-function.html)

Yan

Sort function
 
Hi!

I need to do sort function automatically,

Ex: Team 1 = 10200 pinfall and 450pts
Team 2 = 10245 pinfall and 413pts

I need when i made a sort that the Team2 become 1st since he had more
pnifall then pts...for a bowling program, i know i can do it with the sort
function itself, but is their a way that according to the result of each
week, this is done automatically ....

Thx you!

Billy Liddel

Sort function
 
Yan

Record a macro when you do the sort through the data menu. You can then draw
a command button on the sheet and assign the macro to the button.

Regards
Peter

"Yan" wrote:

Hi!

I need to do sort function automatically,

Ex: Team 1 = 10200 pinfall and 450pts
Team 2 = 10245 pinfall and 413pts

I need when i made a sort that the Team2 become 1st since he had more
pnifall then pts...for a bowling program, i know i can do it with the sort
function itself, but is their a way that according to the result of each
week, this is done automatically ....

Thx you!



All times are GMT +1. The time now is 12:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com