View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.newusers
RagDyeR RagDyeR is offline
external usenet poster
 
Posts: 3,572
Default Custom auto-sorting...possible?

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