Help with Radio buttons please for a footy tipping comp workbook

[AusSteelMan]

Hi everyone,

Below is an extract of a footy tipping spreadsheet that I am running with some friends and family.
Cols D,E,G and H are usually hidden.
Note: Yes, these are my tips for round 1 of the Australian NRL. As you can see, my footy expertise is poor...I am really only running it so I can learn and practice Excel.

Currently when each played gives me their tips, I go to their tab (which is generated by copying a blank sheet using some VBA on the scoresheet tab) and use a validation drop box in Col F to enter their selection. (This is an improvement from last year where I was entering H for home team, A for away, D for draw or NONE if they did not enter tips) This initial improvement should reduce errors since I see the team name, not just a letter.

Their selection is used in the Col I calc to determine if they were correct. I know this formula seems pretty convoluted, but it was an evolution!! and it works!!

However, my latest thought is using radio buttons instead to speed up entering tips. (Last year was prone to error, but could be entered faster than using the validation drop box)


Darren

<TABLE style="PADDING-RIGHT: 2pt; PADDING-LEFT: 2pt; FONT-SIZE: 10pt; FONT-FAMILY: Arial,Arial; BACKGROUND-COLOR: #ffffff" cellSpacing=0 cellPadding=0 border=1><COLGROUP><COL style="FONT-WEIGHT: bold; WIDTH: 30px"><COL style="WIDTH: 83px"><COL style="WIDTH: 84px"><COL style="WIDTH: 84px"><COL style="WIDTH: 84px"><COL style="WIDTH: 84px"><COL style="WIDTH: 119px"><COL style="WIDTH: 85px"><COL style="WIDTH: 85px"><COL style="WIDTH: 99px"></COLGROUP><TBODY><TR style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center"><TD></TD><TD>A</TD><TD>B</TD><TD>C</TD><TD>D</TD><TD>E</TD><TD>F</TD><TD>G</TD><TD>H</TD><TD>I</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">8</TD><TD style="TEXT-ALIGN: center">Round 1</TD><TD style="TEXT-ALIGN: center">12-Mar-10</TD><TD></TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: center">Multiplier Bonus</TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: center">1</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">9</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">10</TD><TD></TD><TD style="TEXT-ALIGN: center">Eels</TD><TD style="TEXT-ALIGN: center">Dragons</TD><TD style="TEXT-ALIGN: center">Draw</TD><TD style="TEXT-ALIGN: center">None</TD><TD style="BACKGROUND-COLOR: #ffff99; TEXT-ALIGN: center">Dragons</TD><TD style="BACKGROUND-COLOR: #c0c0c0; TEXT-ALIGN: center">Dragons</TD><TD style="BACKGROUND-COLOR: #c0c0c0; TEXT-ALIGN: center">Dragons</TD><TD style="BACKGROUND-COLOR: #c0c0c0; TEXT-ALIGN: center">1</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">11</TD><TD></TD><TD style="TEXT-ALIGN: center">Broncos</TD><TD style="TEXT-ALIGN: center">Cowboys</TD><TD style="TEXT-ALIGN: center">Draw</TD><TD></TD><TD style="BACKGROUND-COLOR: #ffff99; TEXT-ALIGN: center">Broncos</TD><TD style="BACKGROUND-COLOR: #c0c0c0; TEXT-ALIGN: center">Broncos</TD><TD style="BACKGROUND-COLOR: #c0c0c0; TEXT-ALIGN: center">Broncos</TD><TD style="BACKGROUND-COLOR: #c0c0c0; TEXT-ALIGN: center">1</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">12</TD><TD></TD><TD style="TEXT-ALIGN: center">Bulldogs</TD><TD style="TEXT-ALIGN: center">Knights</TD><TD style="TEXT-ALIGN: center">Draw</TD><TD></TD><TD style="BACKGROUND-COLOR: #ffff99; TEXT-ALIGN: center">Bulldogs</TD><TD style="BACKGROUND-COLOR: #c0c0c0; TEXT-ALIGN: center">Knights</TD><TD style="BACKGROUND-COLOR: #c0c0c0; TEXT-ALIGN: center">Knights</TD><TD style="BACKGROUND-COLOR: #c0c0c0; TEXT-ALIGN: center">0</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">13</TD><TD></TD><TD style="TEXT-ALIGN: center">Sharks</TD><TD style="TEXT-ALIGN: center">Storm</TD><TD style="TEXT-ALIGN: center">Draw</TD><TD></TD><TD style="BACKGROUND-COLOR: #ffff99; TEXT-ALIGN: center">Sharks</TD><TD style="BACKGROUND-COLOR: #c0c0c0; TEXT-ALIGN: center">Storm</TD><TD style="BACKGROUND-COLOR: #c0c0c0; TEXT-ALIGN: center">Storm</TD><TD style="BACKGROUND-COLOR: #c0c0c0; TEXT-ALIGN: center">0</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">14</TD><TD></TD><TD style="TEXT-ALIGN: center">Panthers</TD><TD style="TEXT-ALIGN: center">Raiders</TD><TD style="TEXT-ALIGN: center">Draw</TD><TD></TD><TD style="BACKGROUND-COLOR: #ffff99; TEXT-ALIGN: center">Raiders</TD><TD style="BACKGROUND-COLOR: #c0c0c0; TEXT-ALIGN: center">Panthers</TD><TD style="BACKGROUND-COLOR: #c0c0c0; TEXT-ALIGN: center">Panthers</TD><TD style="BACKGROUND-COLOR: #c0c0c0; TEXT-ALIGN: center">0</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">15</TD><TD></TD><TD style="TEXT-ALIGN: center">Titans</TD><TD style="TEXT-ALIGN: center">Warriors</TD><TD style="TEXT-ALIGN: center">Draw</TD><TD></TD><TD style="BACKGROUND-COLOR: #ffff99; TEXT-ALIGN: center">Titans</TD><TD style="BACKGROUND-COLOR: #c0c0c0; TEXT-ALIGN: center">Titans</TD><TD style="BACKGROUND-COLOR: #c0c0c0; TEXT-ALIGN: center">Titans</TD><TD style="BACKGROUND-COLOR: #c0c0c0; TEXT-ALIGN: center">1</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">16</TD><TD></TD><TD style="TEXT-ALIGN: center">Rabbits</TD><TD style="TEXT-ALIGN: center">Roosters</TD><TD style="TEXT-ALIGN: center">Draw</TD><TD></TD><TD style="BACKGROUND-COLOR: #ffff99; TEXT-ALIGN: center">Rabbits</TD><TD style="BACKGROUND-COLOR: #c0c0c0; TEXT-ALIGN: center">Roosters</TD><TD style="BACKGROUND-COLOR: #c0c0c0; TEXT-ALIGN: center">Roosters</TD><TD style="BACKGROUND-COLOR: #c0c0c0; TEXT-ALIGN: center">0</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">17</TD><TD></TD><TD style="TEXT-ALIGN: center">West Tigers</TD><TD style="TEXT-ALIGN: center">Sea Eagles</TD><TD style="TEXT-ALIGN: center">Draw</TD><TD></TD><TD style="BACKGROUND-COLOR: #ffff99; TEXT-ALIGN: center">Sea Eagles</TD><TD style="BACKGROUND-COLOR: #c0c0c0; TEXT-ALIGN: center">West Tigers</TD><TD style="BACKGROUND-COLOR: #c0c0c0; TEXT-ALIGN: center">West Tigers</TD><TD style="BACKGROUND-COLOR: #c0c0c0; TEXT-ALIGN: center">0</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">18</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: center">Bonus Points</TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: center">0</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">19</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: center">Total</TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: center">3</TD></TR></TBODY></TABLE>
<TABLE style="FONT-SIZE: 10pt; BORDER-LEFT-COLOR: #00ff00; BORDER-BOTTOM-COLOR: #00ff00; COLOR: #000000; BORDER-TOP-STYLE: groove; BORDER-TOP-COLOR: #00ff00; FONT-FAMILY: Arial; BORDER-RIGHT-STYLE: groove; BORDER-LEFT-STYLE: groove; BACKGROUND-COLOR: #fffcf9; BORDER-RIGHT-COLOR: #00ff00; BORDER-BOTTOM-STYLE: groove"><TBODY><TR><TD>Spreadsheet Formulas</TD></TR><TR><TD><TABLE style="FONT-SIZE: 9pt; FONT-FAMILY: Arial" cellSpacing=0 cellPadding=2 border=1><TBODY><TR style="FONT-SIZE: 10pt; BACKGROUND-COLOR: #cacaca"><TD>Cell</TD><TD>Formula</TD></TR><TR><TD>B17</TD><TD>=IF('Actual Scores'!B17="","",'Actual Scores'!B17)</TD></TR><TR><TD>C17</TD><TD>=IF('Actual Scores'!C17="","",'Actual Scores'!C17)</TD></TR><TR><TD>G17</TD><TD>='Actual Scores'!G17</TD></TR><TR><TD>H17</TD><TD>='Actual Scores'!J17</TD></TR><TR><TD>I17</TD><TD>=IF(H17="","",(IF(AND(F17='Actual Scores'!G17,'Actual Scores'!G17='Actual Scores'!J17,'Actual Scores'!J17=D17),DrawGP,IF(AND(F17='Actual Scores'!G17,'Actual Scores'!G17=D17),Draw80,IF(F17='Actual Scores'!J17,WinTip,0)))))</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>
<TABLE style="FONT-SIZE: 10pt; BORDER-LEFT-COLOR: #0000ff; BORDER-BOTTOM-COLOR: #0000ff; COLOR: #000000; BORDER-TOP-STYLE: groove; BORDER-TOP-COLOR: #0000ff; FONT-FAMILY: Arial; BORDER-RIGHT-STYLE: groove; BORDER-LEFT-STYLE: groove; BACKGROUND-COLOR: #fffcf9; BORDER-RIGHT-COLOR: #0000ff; BORDER-BOTTOM-STYLE: groove"><TBODY><TR><TD>Data Validation in Spreadsheet</TD></TR><TR><TD><TABLE style="FONT-SIZE: 9pt; FONT-FAMILY: Arial" cellSpacing=0 cellPadding=2 border=1><TBODY><TR style="FONT-SIZE: 10pt; BACKGROUND-COLOR: #cacaca"><TD>Cell</TD><TD>Allow</TD><TD>Datas</TD><TD>Input 1</TD><TD>Input 2</TD></TR><TR><TD>F17</TD><TD>List</TD><TD></TD><TD>=B17:E17</TD><TD></TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>

Excel tables to the web >> http://www.excel-jeanie-html.de/index.php?f=1" target="_blank"> Excel Jeanie HTML 4



What I am checking here is that if I have the tips with radio buttons, can I still end up with the selection displayed so it can used in the calculation.

It is worth stating that the winner is of a match is determined by the 'Actual Scores' tab when the score is entered as shown below

Actual Scores

<TABLE style="PADDING-RIGHT: 2pt; PADDING-LEFT: 2pt; FONT-SIZE: 10pt; FONT-FAMILY: Arial,Arial; BACKGROUND-COLOR: #ffffff" cellSpacing=0 cellPadding=0 border=1><COLGROUP><COL style="FONT-WEIGHT: bold; WIDTH: 30px"><COL style="WIDTH: 64px"><COL style="WIDTH: 84px"><COL style="WIDTH: 84px"><COL style="WIDTH: 60px"><COL style="WIDTH: 60px"><COL style="WIDTH: 77px"><COL style="WIDTH: 60px"><COL style="WIDTH: 60px"><COL style="WIDTH: 77px"></COLGROUP><TBODY><TR style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center"><TD></TD><TD>A</TD><TD>B</TD><TD>C</TD><TD>E</TD><TD>F</TD><TD>G</TD><TD>H</TD><TD>I</TD><TD>J</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">8</TD><TD style="TEXT-ALIGN: center">Round 1</TD><TD style="TEXT-ALIGN: center">12-Mar-10</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">9</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">10</TD><TD></TD><TD style="TEXT-ALIGN: center">Eels</TD><TD style="TEXT-ALIGN: center">Dragons</TD><TD style="BACKGROUND-COLOR: #ccffcc; TEXT-ALIGN: center">12</TD><TD style="BACKGROUND-COLOR: #ccffcc; TEXT-ALIGN: center">18</TD><TD style="BACKGROUND-COLOR: #c0c0c0; TEXT-ALIGN: center">Dragons</TD><TD style="BACKGROUND-COLOR: #ccffcc"></TD><TD style="BACKGROUND-COLOR: #ccffcc"></TD><TD style="BACKGROUND-COLOR: #c0c0c0; TEXT-ALIGN: center">Dragons</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">11</TD><TD></TD><TD style="TEXT-ALIGN: center">Broncos</TD><TD style="TEXT-ALIGN: center">Cowboys</TD><TD style="BACKGROUND-COLOR: #ccffcc; TEXT-ALIGN: center">30</TD><TD style="BACKGROUND-COLOR: #ccffcc; TEXT-ALIGN: center">24</TD><TD style="BACKGROUND-COLOR: #c0c0c0; TEXT-ALIGN: center">Broncos</TD><TD style="BACKGROUND-COLOR: #ccffcc"></TD><TD style="BACKGROUND-COLOR: #ccffcc"></TD><TD style="BACKGROUND-COLOR: #c0c0c0; TEXT-ALIGN: center">Broncos</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">12</TD><TD></TD><TD style="TEXT-ALIGN: center">Bulldogs</TD><TD style="TEXT-ALIGN: center">Knights</TD><TD style="BACKGROUND-COLOR: #ccffcc; TEXT-ALIGN: center">16</TD><TD style="BACKGROUND-COLOR: #ccffcc; TEXT-ALIGN: center">20</TD><TD style="BACKGROUND-COLOR: #c0c0c0; TEXT-ALIGN: center">Knights</TD><TD style="BACKGROUND-COLOR: #ccffcc"></TD><TD style="BACKGROUND-COLOR: #ccffcc"></TD><TD style="BACKGROUND-COLOR: #c0c0c0; TEXT-ALIGN: center">Knights</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">13</TD><TD></TD><TD style="TEXT-ALIGN: center">Sharks</TD><TD style="TEXT-ALIGN: center">Storm</TD><TD style="BACKGROUND-COLOR: #ccffcc; TEXT-ALIGN: center">10</TD><TD style="BACKGROUND-COLOR: #ccffcc; TEXT-ALIGN: center">14</TD><TD style="BACKGROUND-COLOR: #c0c0c0; TEXT-ALIGN: center">Storm</TD><TD style="BACKGROUND-COLOR: #ccffcc"></TD><TD style="BACKGROUND-COLOR: #ccffcc"></TD><TD style="BACKGROUND-COLOR: #c0c0c0; TEXT-ALIGN: center">Storm</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">14</TD><TD></TD><TD style="TEXT-ALIGN: center">Panthers</TD><TD style="TEXT-ALIGN: center">Raiders</TD><TD style="BACKGROUND-COLOR: #ccffcc; TEXT-ALIGN: center">34</TD><TD style="BACKGROUND-COLOR: #ccffcc; TEXT-ALIGN: center">16</TD><TD style="BACKGROUND-COLOR: #c0c0c0; TEXT-ALIGN: center">Panthers</TD><TD style="BACKGROUND-COLOR: #ccffcc"></TD><TD style="BACKGROUND-COLOR: #ccffcc"></TD><TD style="BACKGROUND-COLOR: #c0c0c0; TEXT-ALIGN: center">Panthers</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">15</TD><TD></TD><TD style="TEXT-ALIGN: center">Titans</TD><TD style="TEXT-ALIGN: center">Warriors</TD><TD style="BACKGROUND-COLOR: #ccffcc; TEXT-ALIGN: center">24</TD><TD style="BACKGROUND-COLOR: #ccffcc; TEXT-ALIGN: center">18</TD><TD style="BACKGROUND-COLOR: #c0c0c0; TEXT-ALIGN: center">Titans</TD><TD style="BACKGROUND-COLOR: #ccffcc"></TD><TD style="BACKGROUND-COLOR: #ccffcc"></TD><TD style="BACKGROUND-COLOR: #c0c0c0; TEXT-ALIGN: center">Titans</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">16</TD><TD></TD><TD style="TEXT-ALIGN: center">Rabbits</TD><TD style="TEXT-ALIGN: center">Roosters</TD><TD style="BACKGROUND-COLOR: #ccffcc; TEXT-ALIGN: center">10</TD><TD style="BACKGROUND-COLOR: #ccffcc; TEXT-ALIGN: center">36</TD><TD style="BACKGROUND-COLOR: #c0c0c0; TEXT-ALIGN: center">Roosters</TD><TD style="BACKGROUND-COLOR: #ccffcc"></TD><TD style="BACKGROUND-COLOR: #ccffcc"></TD><TD style="BACKGROUND-COLOR: #c0c0c0; TEXT-ALIGN: center">Roosters</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">17</TD><TD></TD><TD style="TEXT-ALIGN: center">West Tigers</TD><TD style="TEXT-ALIGN: center">Sea Eagles</TD><TD style="BACKGROUND-COLOR: #ccffcc; TEXT-ALIGN: center">26</TD><TD style="BACKGROUND-COLOR: #ccffcc; TEXT-ALIGN: center">22</TD><TD style="BACKGROUND-COLOR: #c0c0c0; TEXT-ALIGN: center">West Tigers</TD><TD style="BACKGROUND-COLOR: #ccffcc"></TD><TD style="BACKGROUND-COLOR: #ccffcc"></TD><TD style="BACKGROUND-COLOR: #c0c0c0; TEXT-ALIGN: center">West Tigers</TD></TR></TBODY></TABLE>
<TABLE style="FONT-SIZE: 10pt; BORDER-LEFT-COLOR: #00ff00; BORDER-BOTTOM-COLOR: #00ff00; COLOR: #000000; BORDER-TOP-STYLE: groove; BORDER-TOP-COLOR: #00ff00; FONT-FAMILY: Arial; BORDER-RIGHT-STYLE: groove; BORDER-LEFT-STYLE: groove; BACKGROUND-COLOR: #fffcf9; BORDER-RIGHT-COLOR: #00ff00; BORDER-BOTTOM-STYLE: groove"><TBODY><TR><TD>Spreadsheet Formulas</TD></TR><TR><TD><TABLE style="FONT-SIZE: 9pt; FONT-FAMILY: Arial" cellSpacing=0 cellPadding=2 border=1><TBODY><TR style="FONT-SIZE: 10pt; BACKGROUND-COLOR: #cacaca"><TD>Cell</TD><TD>Formula</TD></TR><TR><TD>G17</TD><TD>=IF(F17="","",(IF(E17>F17,B17,(IF(E17<F17,C17,D17)< font>))))</TD></TR><TR><TD>J17</TD><TD>=IF(G17="","",(IF(G17=D17,(IF(H17>I17,B17,(IF(H17<I17,C17,D17)< font>))),G17)))</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>

Excel tables to the web >> http://www.excel-jeanie-html.de/index.php?f=1" target="_blank"> Excel Jeanie HTML 4

Edit:
The formulas have not displayed properly in Jeanie, so here they are:
G17 is

=IF(F17="","",(IF(E17>F17,B17,(IF(E17<F17,C17,D17)))))

J17 is

=IF(G17="","",(IF(G17=D17,(IF(H17>I17,B17,(IF(H17<I17,C17,D17)))),G17)))

Using the scores is not essential and I could use a radio button here too. The reason I enter the scores is that it allows me to further expand functionality to include picking the score and or picking the margin.

I have not ever used radio buttons in Excel before.

Just looking for some guidance and suggestions/improvments

I am willing to give the code a go if it is possible.

Any help will be very much appreciated.

Thanks,
Darren

 

[AusSteelMan]

I don't know what is going on here.

The edit on the last post did the same truncating as Jeanie did.

So I'll try here instead


G17 is =IF(F17="","",(IF(E17>F17,B17,(IF(E17<F17,C17,D17)))))< p>
J17 is =IF(G17="","",(IF(G17=D17,(IF(H17>I17,B17,(IF(H17<I17,C17,D17)))),G17)))<I17,C17,D17)))),G17)))< p>

OK, getting a little upset now

It seems to be that a "is less than" sign truncates the rest of the line. Is this an already known fact???

Here it is again, just replace "less than" with a proper sign

G17 is =IF(F17="","",(IF(E17>F17,B17,(IF(E17"is less than"F17,C17,D17)))))
J17 is =IF(G17="","",(IF(G17=D17,(IF(H17>I17,B17,(IF(H17"is less than"I17,C17,D17)))),G17)))

(Well this works in preview anyway)

Regards,
Darren

 

[AusSteelMan]

Many people seemed to have read this thread, but no-one has any replies yet.

Is it a case of the question is too difficult
or [more probable]
I have not actually been clear in what I would like to do.

I'll go with clarity, and have a go at restating what I want to do.

Basically, I'd like to have the team lists for each round that are selectable via a radio button [or similar].
So there would be 8 sets of radio buttons per round, for 26 rounds. each set would contain "Home team, Away team, Draw and None"

Thanks,
ASM

 

[WaydeM]

Have you thought about using a userform to just dropdown the team names?
I'm just not sure how to get the data to write across multiple sheets!