I would appreciate some help on the following formula problem. I have a game where some teams have wins, losses and draws. My problem arises when teams have the same number of wins as others but with a goal difference (as in football leagues). I need to determine a ranking order not only based upon wins but also taking into account goal difference. Is there a formula that can do this for me? Any help will be very welcome. Thank you.
Thank you for your response. I tried your solution and it worked for which "Thank you". I must say that I find your remark(question) somewhat hurtful and unnecessary as I always, without fail, say thank you to those people that help me as you have done here. I cannot speak for others that do not. You may or may not remember that just over a year ago you were kind enough to help me with a difficult problem on " Replacing Duplicates". I was grateful for your help then (and said so) as I am now. I hope you will continue to provide an excellent service to this community. Once again --Thank you.
Thank for your response. You are gracious enough to apologise and I appreciate that. We can move forward on a positive note. I can understand your frustration as I have seen it many times in dealings with other people. It reminds me of an incident I saw many years ago on a crowded train on the London underground. A man got up from his seat and offered it to a woman who then sat down. A few seconds later....... the man said to the woman --"Pardon". The woman responded --" I did not say anything". The man replied --"Oh, I thought you said Thank you"!!
Perhaps you can persuade the "Moderators" of this forum to display the request for politeness etc. more prominently than it is so that it cannot be ignored.