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?
--
Regards,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Pools" wrote in
message ...
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
--
Pools
------------------------------------------------------------------------
Pools's Profile:
http://www.excelforum.com/member.php...o&userid=35961
View this thread: http://www.excelforum.com/showthread...hreadid=557630