Multiple Column Conditional Formulas

[Axial]

I have been struggling with a problem regarding conditional formulas. My data looks like this:

Identifier1, Code1, Code8, Code3, Code67,
Identifier2, Code9, Code34, Code31, Code3
Identifier3, Code4, Code6, Code67, Code5
etc

I want to use a conditonal forumla to return a 1 or 0 to a single column if eg Code4 is present in any of the 20 code columns. I can work out conditional formulas for 1 column, but not sure how to expand it into multiple columns. So my Data for code67 would look like: (with the column to show results added after identifier column)

Identifier1, 1, Code1, Code8, Code3, Code67
Identifier2, 0, Code9, Code34, Code31, Code3
Identifier3, 1, Code4, Code6, Code67, Code5

Any help people can give would be greatly appreciated.

 

[AlphaFrog]

<b>Excel 2003</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #A6AAB6"><colgroup><col width="25px" style="background-color: #E0E0F0" /><col /><col /><col /><col /><col /><col /></colgroup><thead><tr style=" background-color: #E0E0F0;text-align: center;color: #161120"><th></th><th>A</th><th>B</th><th>C</th><th>D</th><th>E</th><th>F</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">1</td><td style=";">Identifier1</td><td style="text-align: right;;">1</td><td style=";">Code1</td><td style=";">Code8</td><td style=";">Code3</td><td style=";">Code67</td></tr><tr ><td style="color: #161120;text-align: center;">2</td><td style=";">Identifier2</td><td style="text-align: right;;">0</td><td style=";">Code9</td><td style=";">Code34</td><td style=";">Code31</td><td style=";">Code3</td></tr><tr ><td style="color: #161120;text-align: center;">3</td><td style=";">Identifier3</td><td style="text-align: right;;">1</td><td style=";">Code4</td><td style=";">Code6</td><td style=";">Code67</td><td style=";">Code5</td></tr></tbody></table><p style="width:3.6em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #A6AAB6;border-top:none;text-align: center;background-color: #E0E0F0;color: #161120">Sheet1</p><br /><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: #FFFFFF" ><tr><td style="padding:6px" ><b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: #FFFFFF;border-collapse: collapse; border-color: #A6AAB6"><thead><tr style=" background-color: #E0E0F0;color: #161120"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">B1</th><td style="text-align:left">=1*(<font color="Blue">COUNTIF(<font color="Red">C1:F1,"Code67"</font>)>0</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">B2</th><td style="text-align:left">=1*(<font color="Blue">COUNTIF(<font color="Red">C2:F2,"Code67"</font>)>0</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">B3</th><td style="text-align:left">=1*(<font color="Blue">COUNTIF(<font color="Red">C3:F3,"Code67"</font>)>0</font>)</td></tr></tbody></table></td></tr></table><br />

 

[Axial]

That is just brilliant, thank you so much. I really appreciate it.