Okay sorry - I spoke too soon... LoL... Here is the obstacle I have found... Was hoping someone with some experience could either help me or give me some advice on how to make this more simple cuz I think I've complicated it considerably. I'm an armature clearly - as it took me about 45 minutes to figure out how to Paste Special to get the standing/etc to work.

Here's what I can't figure out:

1) How to get rid of the Ties from the standings (cuz it's baseball we don't have any tie games - I'll live with it if it's complicated tho.)
2) How can I calculate Runs For/ Runs Against / +/- run's in a simple way. What I'd like to do is imput the score once and have it record somehow but the way I have it set up makes that impossible (I think)... I just can't for the life of me figure it out without actually going in there and typing it in each week... Which I guess would be fine...
3) When two teams have the exact same record, is there a way to adjust the formula to take the +/- as the tiebreaker and rank teams accordingly?


Ahhhhh... Sorry so back to the 45 minutes to figure out how to paste the standings from sheet 2 into sheet 1... What a mess... I "paste special" and paste "Values & Number Format" and only just realized that I've lost the formula and when I make changes nothing happens to the standing... What am I supposed to paste (Sheet 2 to Sheet 1)

Thanks a lot for any help/advice you might be able to provide... AD Softball League Schedule & Results - May%2FJuly 2013.xlsx