Your first issue sounds like an absolute problem, when you sort the
numbers stay in one spot is that right? do you have the cells as a
relative or absolute value from the data sheet??

So you are sorting each individual catagory one at a time, and then at
the far right total up the rankings to get the total placements of your
league.

I remember having this type of problem in a hocky fantasy draft
many,many years ago, I am sure it has to do with relative or absolute
values, if it is an absolute problem, you need the $A$ signs, goto edit
(say the refernce row is A)
find A
replace with $A$
do this in the sheet that you are doing your sorting do a test run
first to make sure that is the problem


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=517432