Custom auto-sorting...possible?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Pools - 02 Jul 2006 03:23 GMT

Is there a way to have excel auto-sort (cutom) by criteria in 3 columns?
I think it might be easier to explain by viewing the workbook
http://poolgod.zftp.com/predictions.xls.
The picture shows how I need it to sort. I found some information on
auto-sort in help and also on the net, but I don't know how to
incorporate the multiple criteria or if it's even possible. Any ideas?

Thanks,
Steve

Signature

Pools

Reply to this Message

Otto Moehrbach - 02 Jul 2006 17:42 GMT

What do you mean by "auto-sort"? What do you want to do? When do you want
this to happen? HTH Otto

> Is there a way to have excel auto-sort (cutom) by criteria in 3 columns?
> I think it might be easier to explain by viewing the workbook
[quoted text clipped - 5 lines]
> Thanks,
> Steve

Reply to this Message

Pools - 02 Jul 2006 21:43 GMT

Thanks for the reply. I'd like for it to sort when a value changed in
the wins column, or if that's not possible, to have a button that would
sort by all 3 criteria when pressed.

Thanks again,
Steve

Signature

Pools

Reply to this Message

Ragdyer - 03 Jul 2006 02:25 GMT

When you say, "Sort by 3 criteria",
What exactly do you mean?

You mention wins.
So, I picture a 3 column datalist, with team names in Column A, wins in
Column B, losses in Column C.
Perhaps a fourth column with a formula that calculates a percentage which
determines the placement of the teams, the highest percentage being first,
the next highest being second, and so on.

So, where does auto sort on 3 criteria come in?

Signature

Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

> Thanks for the reply. I'd like for it to sort when a value changed in
> the wins column, or if that's not possible, to have a button that would
> sort by all 3 criteria when pressed.
>
> Thanks again,
> Steve

Reply to this Message

Pools - 03 Jul 2006 06:03 GMT

By 3 criteria, I meant sort by set (which is the only way I could think
of to keep the teams in their own divisions) (lowest to highest), then
sort by wins (highest to lowest), then sort by team (A-Z) ... the team
sort is only to keep an alphabetical order among tied records in the
same division. There is no need for a winning percentage, highest win
total is sufficient.

In the xls link I have in the post is a picture of exactly how I'd
like for it to sort.

Thanks for the interest in helping,
Steve

Signature

Pools

Reply to this Message