Register

Reply to thread

Message: <blockquote data-quote="Artist 2004" data-source="post: 226553" data-attributes="member: 177270"><p>Anyone using this will note that it has started entering the wrong team names in the quarter finals! Here's how to fix it:</p><p></p><p><span style="font-family: 'Arial'"><span style="font-size: 10px"><span style="color: #0000ff">In Tools / Options turn on row and column headings.</span></span></span></p><p><span style="font-family: 'Arial'"><span style="font-size: 10px"><span style="color: #0000ff">Note that columns J and K are hidden.</span></span></span></p><p><span style="font-family: 'Arial'"><span style="font-size: 10px"><span style="color: #0000ff">Unhide them: highlight columns either side and do Format / Column / Unhide</span></span></span></p><p><span style="font-family: 'Arial'"><span style="font-size: 10px"><span style="color: #0000ff">There are simple errors in cells J60 to J86</span></span></span></p><p> </p><p><span style="font-family: 'Arial'"><span style="font-size: 10px"><span style="color: #0000ff">Click in J60, it contains a formula:</span></span></span></p><p><span style="font-family: 'Arial'"><span style="font-size: 10px"><span style="color: #0000ff">=IF(E60<>"",IF(E60>F60,<strong><span style="color: #ff0000">D64</span></strong>,IF(F60>E60,G60,"Draw")),"Second Rd 1")</span></span></span></p><p><span style="font-family: 'Arial'"><span style="font-size: 10px"><span style="color: #0000ff">All the numeric parts in cell J60 should be 60</span></span></span></p><p><span style="font-family: 'Arial'"><span style="font-size: 10px"><span style="color: #0000ff"><span style="font-family: 'Arial'"><span style="font-size: 10px"><span style="color: #0000ff">All the numeric parts in cell J61 should be 61</span></span></span></span></span></span></p><p><span style="font-family: 'Arial'"><span style="font-size: 10px"><span style="color: #0000ff"><span style="font-family: 'Arial'"><span style="font-size: 10px"><span style="color: #0000ff">All the numeric parts in cell J62 should be 62</span></span></span></span></span></span></p><p><span style="font-family: 'Arial'"><span style="font-size: 10px"><span style="color: #0000ff">and so on.</span></span></span></p><p> </p><p><span style="font-family: 'Arial'"><span style="font-size: 10px"><span style="color: #0000ff">So in J60 change D64 to D60</span></span></span></p><p><span style="font-family: 'Arial'"><span style="font-size: 10px"><span style="color: #0000ff">and so on.</span></span></span></p></blockquote><p></p>

Verification

This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.

Accept Learn more…

Top