Help to automate ranking of tied teams in sports scoring program

**alan_stephen75@** · 06-11-2012, 08:50 AM

Thanks again for your clever idea and sorry to be slow in coming back to you but it is starting to get a bit too complicated and I don't think it is worth it going down this route

In an earlier file (V7?) you put in actual scores and I think you said that worked apart, from x = #value, so I wondered if instead of saying JPN beat SUI 7-5 why can't we put in JPN 1 SUI 0 as I said earlier in other words a 1=W & 0=loss which is the same thing as putting in the score, would that work?

I will try that out in the next few hours by changing scores in V7 to 1 or 0 and see what happens and upload it to you if you think this might work. Please let me know what you think. Alan

**micope21** · 06-11-2012, 10:41 AM

Hi Alan

Not a problem. I rather see you happy with workbook.

It won't make any different even you put in 1 vs 0!!!
As W vs L does count as 1 vs 0 or -1 what you got with v2 to v6.

There is no other way. I have look clear with workbook. It the same problem I had in the past when I first starting doing tied break.
I have come up with my last idea.

Lookin back what you say with this forum. You want see W or L in grid!
What I done put in other grid for W or L.

This time you put in score other grid will come up automatic W or L.
I have sort the X out too. There no ~VALUE! or anything. That done.

Have a look and see what I done. This is a last idea. I can't think anything else with W or L same as 1 for W L for O without the score.

Workbook v8

Help to automate ranking of tied teams in sports scoring program

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Re: Help to automate ranking of tied teams in sports scoring program

Re: Help to automate ranking of tied teams in sports scoring program

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions