<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>New Page 1</title>
</head>
<body>
</p>
<span class="largetext">I have 3 columns in a spreadsheet and I want to write
a simple formula or script that will allow me to create the new columb given the
values in column 1, 2, and 3.
</span></p>
<table>
<col width="90" style="mso-width-source:userset;mso-width-alt:3214;width:68pt">
<col width="64" span="2" style="width:48pt">
<col width="64" span="2" style="width:48pt">
<tr height="18" style="height:13.2pt">
<td height="18" class="xl22" width="90" style="height:13.2pt;width:68pt">A</td>
<td class="xl22" width="64" style="width:48pt">B</td>
<td class="xl22" width="64" style="width:48pt">C</td>
<td width="64" style="width:48pt"></td>
<td class="xl22" width="64" style="width:48pt">New Column</td>
</tr>
<tr height="18" style="height:13.2pt">
<td height="18" class="xl22" style="height:13.2pt" x:num>11002</td>
<td class="xl22" x:num>11001</td>
<td class="xl22"></td>
<td></td>
<td align="right" x:num>11002</td>
</tr>
<tr height="18" style="height:13.2pt">
<td height="18" class="xl22" style="height:13.2pt" x:num>32322</td>
<td class="xl22" x:num>21221</td>
<td class="xl22" x:num>11011</td>
<td></td>
<td class="xl23" x:num>
<p align="right">32322</p>
</td>
</tr>
<tr height="18" style="height:13.2pt">
<td height="18" class="xl22" style="height:13.2pt" x:num>12133</td>
<td class="xl22"></td>
<td class="xl22"></td>
<td></td>
<td align="right" x:num>12133</td>
</tr>
<tr height="18" style="height:13.2pt">
<td height="18" class="xl22" style="height:13.2pt"></td>
<td class="xl22" x:num>43233</td>
<td class="xl22" x:num>44332</td>
<td></td>
<td align="right" x:num>43233</td>
</tr>
<tr height="18" style="height:13.2pt">
<td height="18" class="xl22" style="height:13.2pt"></td>
<td class="xl22"></td>
<td class="xl22" x:num>12112</td>
<td></td>
<td align="right" x:num>12112</td>
</tr>
<tr height="18" style="height:13.2pt">
<td height="18" class="xl22" style="height:13.2pt"></td>
<td class="xl22" x:num>43222</td>
<td class="xl22"></td>
<td></td>
<td align="right" x:num>43222</td>
</tr>
<tr height="18" style="height:13.2pt">
<td height="18" class="xl22" style="height:13.2pt"></td>
<td class="xl22"></td>
<td class="xl22" x:num>11212</td>
<td></td>
<td align="right" x:num>11212</td>
</tr>
</table>
Is there any way for the new column to look at columns 1,2,3 and give the
value of column 1 if there is anything present, if not look at column 2, etc....
Thank you very much for any help
Steve</p>
</body>
</html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>New Page 1</title>
</head>
<body>
</p>
<span class="largetext">I have 3 columns in a spreadsheet and I want to write
a simple formula or script that will allow me to create the new columb given the
values in column 1, 2, and 3.
</span></p>
<table>
<col width="90" style="mso-width-source:userset;mso-width-alt:3214;width:68pt">
<col width="64" span="2" style="width:48pt">
<col width="64" span="2" style="width:48pt">
<tr height="18" style="height:13.2pt">
<td height="18" class="xl22" width="90" style="height:13.2pt;width:68pt">A</td>
<td class="xl22" width="64" style="width:48pt">B</td>
<td class="xl22" width="64" style="width:48pt">C</td>
<td width="64" style="width:48pt"></td>
<td class="xl22" width="64" style="width:48pt">New Column</td>
</tr>
<tr height="18" style="height:13.2pt">
<td height="18" class="xl22" style="height:13.2pt" x:num>11002</td>
<td class="xl22" x:num>11001</td>
<td class="xl22"></td>
<td></td>
<td align="right" x:num>11002</td>
</tr>
<tr height="18" style="height:13.2pt">
<td height="18" class="xl22" style="height:13.2pt" x:num>32322</td>
<td class="xl22" x:num>21221</td>
<td class="xl22" x:num>11011</td>
<td></td>
<td class="xl23" x:num>
<p align="right">32322</p>
</td>
</tr>
<tr height="18" style="height:13.2pt">
<td height="18" class="xl22" style="height:13.2pt" x:num>12133</td>
<td class="xl22"></td>
<td class="xl22"></td>
<td></td>
<td align="right" x:num>12133</td>
</tr>
<tr height="18" style="height:13.2pt">
<td height="18" class="xl22" style="height:13.2pt"></td>
<td class="xl22" x:num>43233</td>
<td class="xl22" x:num>44332</td>
<td></td>
<td align="right" x:num>43233</td>
</tr>
<tr height="18" style="height:13.2pt">
<td height="18" class="xl22" style="height:13.2pt"></td>
<td class="xl22"></td>
<td class="xl22" x:num>12112</td>
<td></td>
<td align="right" x:num>12112</td>
</tr>
<tr height="18" style="height:13.2pt">
<td height="18" class="xl22" style="height:13.2pt"></td>
<td class="xl22" x:num>43222</td>
<td class="xl22"></td>
<td></td>
<td align="right" x:num>43222</td>
</tr>
<tr height="18" style="height:13.2pt">
<td height="18" class="xl22" style="height:13.2pt"></td>
<td class="xl22"></td>
<td class="xl22" x:num>11212</td>
<td></td>
<td align="right" x:num>11212</td>
</tr>
</table>
Is there any way for the new column to look at columns 1,2,3 and give the
value of column 1 if there is anything present, if not look at column 2, etc....
Thank you very much for any help
Steve</p>
</body>
</html>