<![CDATA[
<P>안녕하세요. 엑사전 회원 여러분!</P>
<P>제가 RANDBETWEEN을 이용하여 경품추첨 프로그램을 만들었는데</P>
<P>한가지 문제가 있습니다.</P>
<P>보시는 것처럼 각 번호대가 분리되어 있는데 이것을</P>
<P>하나의 열에 통합을 하고 싶습니다.</P>
<P align=left><a href='javascript:fileFilterViewer("http://pds64.cafe.daum.net/attach/16/cafe/2008/04/16/20/56/4805e96d7af2e?.xls", "/pds64_disk16/20080416/2056_4805e96d7af2e", "경품추첨프로그램.xls", "grpid%3Dt62Z%26fldid%3D5qTv%26dataid%3D707%26fileid%3D1%26regdt%3D20080416205815&url=http%3A%2F%2Fpds64.cafe.daum.net%2Fattach%2F16%2Fcafe%2F2008%2F04%2F16%2F20%2F56%2F4805e96d7af2e%3F.xls")'><img src="https://t1.daumcdn.net/cafe_image/cf_img2/bbs2/p_xls_s.gif" border="0" alt="첨부파일" class="vam"/> 경품추첨프로그램.xls</a></P>
<P>즉, 아래에 4개의 열로 분리되어 있는 행운번호를 하나의 열로 통합을 하려면 어떻게 해야 할지</P>
<P>답변 부탁드립니다. 감사합니다.</P>
<P> </P>
<P> </P>
<P>
<TABLE style="WIDTH: 339pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=452 border=0>
<COLGROUP>
<COL style="WIDTH: 57pt; mso-width-source: userset; mso-width-alt: 2161" width=76>
<COL style="WIDTH: 65pt; mso-width-source: userset; mso-width-alt: 2474" width=87>
<COL style="WIDTH: 81pt; mso-width-source: userset; mso-width-alt: 3072" width=108>
<COL style="WIDTH: 73pt; mso-width-source: userset; mso-width-alt: 2759" width=97>
<COL style="WIDTH: 63pt; mso-width-source: userset; mso-width-alt: 2389" width=84>
<TBODY>
<TR style="HEIGHT: 14.25pt" height=19>
<TD class=xl68 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 57pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent" width=76 height=19>
<P align=center><FONT face=돋움 color=#000000>행운번호</FONT></P></TD>
<TD class=xl69 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 65pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffc000" width=87>
<P align=center><FONT face=돋움 color=#000000>1~448</FONT></P></TD>
<TD class=xl70 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 81pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #0070c0" width=108>
<P align=center><FONT face=돋움 color=#000000>2000~3158</FONT></P></TD>
<TD class=xl71 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 73pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #c0504d" width=97>
<P align=center><FONT face=돋움 color=#000000>9001~10673</FONT></P></TD>
<TD class=xl72 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 63pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #00b050" width=84>
<P align=center><FONT face=돋움 color=#000000>5001-7487</FONT></P></TD></TR>
<TR style="HEIGHT: 13.5pt" height=18>
<TD class=xl67 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>
<P align=center><FONT face=돋움 color=#000000>1</FONT></P></TD>
<TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffc000">
<P align=center><FONT face=돋움 color=#000000>240</FONT></P></TD>
<TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #4f81bd">
<P align=center><FONT face=돋움 color=#000000>2379</FONT></P></TD>
<TD class=xl64 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #c0504d">
<P align=center><FONT face=돋움 color=#000000>9232</FONT></P></TD>
<TD class=xl63 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #00b050">
<P align=center><FONT face=돋움 color=#000000>5182</FONT></P></TD></TR>
<TR style="HEIGHT: 13.5pt" height=18>
<TD class=xl67 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>
<P align=center><FONT face=돋움 color=#000000>2</FONT></P></TD>
<TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffc000">
<P align=center><FONT face=돋움 color=#000000>391</FONT></P></TD>
<TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #4f81bd">
<P align=center><FONT face=돋움 color=#000000>2793</FONT></P></TD>
<TD class=xl64 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #c0504d">
<P align=center><FONT face=돋움 color=#000000>10564</FONT></P></TD>
<TD class=xl63 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #00b050">
<P align=center><FONT face=돋움 color=#000000>5141</FONT></P></TD></TR>
<TR style="HEIGHT: 13.5pt" height=18>
<TD class=xl67 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>
<P align=center><FONT face=돋움 color=#000000>3</FONT></P></TD>
<TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffc000">
<P align=center><FONT face=돋움 color=#000000>92</FONT></P></TD>
<TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #4f81bd">
<P align=center><FONT face=돋움 color=#000000>2409</FONT></P></TD>
<TD class=xl64 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #c0504d">
<P align=center><FONT face=돋움 color=#000000>10005</FONT></P></TD>
<TD class=xl63 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #00b050">
<P align=center><FONT face=돋움 color=#000000>6978</FONT></P></TD></TR>
<TR style="HEIGHT: 13.5pt" height=18>
<TD class=xl67 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>
<P align=center><FONT face=돋움 color=#000000>4</FONT></P></TD>
<TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffc000">
<P align=center><FONT face=돋움 color=#000000>28</FONT></P></TD>
<TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #4f81bd">
<P align=center><FONT face=돋움 color=#000000>3002</FONT></P></TD>
<TD class=xl64 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #c0504d">
<P align=center><FONT face=돋움 color=#000000>9041</FONT></P></TD>
<TD class=xl63 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #00b050">
<P align=center><FONT face=돋움 color=#000000>6887</FONT></P></TD></TR>
<TR style="HEIGHT: 13.5pt" height=18>
<TD class=xl67 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>
<P align=center><FONT face=돋움 color=#000000>5</FONT></P></TD>
<TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffc000">
<P align=center><FONT face=돋움 color=#000000>391</FONT></P></TD>
<TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #4f81bd">
<P align=center><FONT face=돋움 color=#000000>2779</FONT></P></TD>
<TD class=xl64 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #c0504d">
<P align=center><FONT face=돋움 color=#000000>10556</FONT></P></TD>
<TD class=xl63 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #00b050">
<P align=center><FONT face=돋움 color=#000000>6529</FONT></P></TD></TR>
<TR style="HEIGHT: 13.5pt" height=18>
<TD class=xl67 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>
<P align=center><FONT face=돋움 color=#000000>6</FONT></P></TD>
<TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffc000">
<P align=center><FONT face=돋움 color=#000000>140</FONT></P></TD>
<TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #4f81bd">
<P align=center><FONT face=돋움 color=#000000>2250</FONT></P></TD>
<TD class=xl64 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #c0504d">
<P align=center><FONT face=돋움 color=#000000>9820</FONT></P></TD>
<TD class=xl63 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #00b050">
<P align=center><FONT face=돋움 color=#000000>7385</FONT></P></TD></TR>
<TR style="HEIGHT: 13.5pt" height=18>
<TD class=xl67 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>
<P align=center><FONT face=돋움 color=#000000>7</FONT></P></TD>
<TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffc000">
<P align=center><FONT face=돋움 color=#000000>83</FONT></P></TD>
<TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #4f81bd">
<P align=center><FONT face=돋움 color=#000000>2326</FONT></P></TD>
<TD class=xl64 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #c0504d">
<P align=center><FONT face=돋움 color=#000000>9180</FONT></P></TD>
<TD class=xl63 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #00b050">
<P align=center><FONT face=돋움 color=#000000>5439</FONT></P></TD></TR>
<TR style="HEIGHT: 13.5pt" height=18>
<TD class=xl67 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>
<P align=center><FONT face=돋움 color=#000000>8</FONT></P></TD>
<TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffc000">
<P align=center><FONT face=돋움 color=#000000>336</FONT></P></TD>
<TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #4f81bd">
<P align=center><FONT face=돋움 color=#000000>2022</FONT></P></TD>
<TD class=xl64 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #c0504d">
<P align=center><FONT face=돋움 color=#000000>9708</FONT></P></TD>
<TD class=xl63 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #00b050">
<P align=center><FONT face=돋움 color=#000000>5251</FONT></P></TD></TR>
<TR style="HEIGHT: 13.5pt" height=18>
<TD class=xl67 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>
<P align=center><FONT face=돋움 color=#000000>9</FONT></P></TD>
<TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffc000">
<P align=center><FONT face=돋움 color=#000000>434</FONT></P></TD>
<TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #4f81bd">
<P align=center><FONT face=돋움 color=#000000>2069</FONT></P></TD>
<TD class=xl64 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #c0504d">
<P align=center><FONT face=돋움 color=#000000>9643</FONT></P></TD>
<TD class=xl63 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #00b050">
<P align=center><FONT face=돋움 color=#000000>7456</FONT></P></TD></TR>
<TR style="HEIGHT: 13.5pt" height=18>
<TD class=xl67 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>
<P align=center><FONT face=돋움 color=#000000>10</FONT></P></TD>
<TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffc000">
<P align=center><FONT face=돋움 color=#000000>158</FONT></P></TD>
<TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #4f81bd">
<P align=center><FONT face=돋움 color=#000000>2931</FONT></P></TD>
<TD class=xl64 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #c0504d">
<P align=center><FONT face=돋움 color=#000000>10297</FONT></P></TD>
<TD class=xl63 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #00b050">
<P align=center><FONT face=돋움 color=#000000>5809</FONT></P></TD></TR>
<TR style="HEIGHT: 13.5pt" height=18>
<TD class=xl67 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>
<P align=center><FONT face=돋움 color=#000000>11</FONT></P></TD>
<TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffc000">
<P align=center><FONT face=돋움 color=#000000>63</FONT></P></TD>
<TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #4f81bd">
<P align=center><FONT face=돋움 color=#000000>2208</FONT></P></TD>
<TD class=xl64 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #c0504d">
<P align=center><FONT face=돋움 color=#000000>10199</FONT></P></TD>
<TD class=xl63 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #00b050">
<P align=center><FONT face=돋움 color=#000000>7058</FONT></P></TD></TR>
<TR style="HEIGHT: 13.5pt" height=18>
<TD class=xl67 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>
<P align=center><FONT face=돋움 color=#000000>12</FONT></P></TD>
<TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffc000">
<P align=center><FONT face=돋움 color=#000000>276</FONT></P></TD>
<TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #4f81bd">
<P align=center><FONT face=돋움 color=#000000>2921</FONT></P></TD>
<TD class=xl64 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #c0504d">
<P align=center><FONT face=돋움 color=#000000>9968</FONT></P></TD>
<TD class=xl63 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #00b050">
<P align=center><FONT face=돋움 color=#000000>5051</FONT></P></TD></TR>
<TR style="HEIGHT: 13.5pt" height=18>
<TD class=xl67 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>
<P align=center><FONT face=돋움 color=#000000>13</FONT></P></TD>
<TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffc000">
<P align=center><FONT face=돋움 color=#000000>298</FONT></P></TD>
<TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #4f81bd">
<P align=center><FONT face=돋움 color=#000000>3081</FONT></P></TD>
<TD class=xl64 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #c0504d">
<P align=center><FONT face=돋움 color=#000000>10000</FONT></P></TD>
<TD class=xl63 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #00b050">
<P align=center><FONT face=돋움 color=#000000>6048</FONT></P></TD></TR>
<TR style="HEIGHT: 13.5pt" height=18>
<TD class=xl67 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>
<P align=center><FONT face=돋움 color=#000000>14</FONT></P></TD>
<TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffc000">
<P align=center><FONT face=돋움 color=#000000>65</FONT></P></TD>
<TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #4f81bd">
<P align=center><FONT face=돋움 color=#000000>2597</FONT></P></TD>
<TD class=xl64 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #c0504d">
<P align=center><FONT face=돋움 color=#000000>9690</FONT></P></TD>
<TD class=xl63 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #00b050">
<P align=center><FONT face=돋움 color=#000000>6813</FONT></P></TD></TR>
<TR style="HEIGHT: 13.5pt" height=18>
<TD class=xl67 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>
<P align=center><FONT face=돋움 color=#000000>15</FONT></P></TD>
<TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffc000">
<P align=center><FONT face=돋움 color=#000000>362</FONT></P></TD>
<TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #4f81bd">
<P align=center><FONT face=돋움 color=#000000>2585</FONT></P></TD>
<TD class=xl64 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #c0504d">
<P align=center><FONT face=돋움 color=#000000>9663</FONT></P></TD>
<TD class=xl63 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #00b050">
<P align=center><FONT face=돋움 color=#000000>6680</FONT></P></TD></TR>
<TR style="HEIGHT: 13.5pt" height=18>
<TD class=xl67 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>
<P align=center><FONT face=돋움 color=#000000>16</FONT></P></TD>
<TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffc000">
<P align=center><FONT face=돋움 color=#000000>345</FONT></P></TD>
<TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #4f81bd">
<P align=center><FONT face=돋움 color=#000000>2040</FONT></P></TD>
<TD class=xl64 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #c0504d">
<P align=center><FONT face=돋움 color=#000000>9924</FONT></P></TD>
<TD class=xl63 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #00b050">
<P align=center><FONT face=돋움 color=#000000>7146</FONT></P></TD></TR>
<TR style="HEIGHT: 13.5pt" height=18>
<TD class=xl67 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>
<P align=center><FONT face=돋움 color=#000000>17</FONT></P></TD>
<TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffc000">
<P align=center><FONT face=돋움 color=#000000>322</FONT></P></TD>
<TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #4f81bd">
<P align=center><FONT face=돋움 color=#000000>2755</FONT></P></TD>
<TD class=xl64 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #c0504d">
<P align=center><FONT face=돋움 color=#000000>10531</FONT></P></TD>
<TD class=xl63 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #00b050">
<P align=center><FONT face=돋움 color=#000000>7445</FONT></P></TD></TR>
<TR style="HEIGHT: 13.5pt" height=18>
<TD class=xl67 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>
<P align=center><FONT face=돋움 color=#000000>18</FONT></P></TD>
<TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffc000">
<P align=center><FONT face=돋움 color=#000000>47</FONT></P></TD>
<TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #4f81bd">
<P align=center><FONT face=돋움 color=#000000>3135</FONT></P></TD>
<TD class=xl64 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #c0504d">
<P align=center><FONT face=돋움 color=#000000>9455</FONT></P></TD>
<TD class=xl63 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #00b050">
<P align=center><FONT face=돋움 color=#000000>5395</FONT></P></TD></TR>
<TR style="HEIGHT: 13.5pt" height=18>
<TD class=xl67 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>
<P align=center><FONT face=돋움 color=#000000>19</FONT></P></TD>
<TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffc000">
<P align=center><FONT face=돋움 color=#000000>443</FONT></P></TD>
<TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #4f81bd">
<P align=center><FONT face=돋움 color=#000000>2681</FONT></P></TD>
<TD class=xl64 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #c0504d">
<P align=center><FONT face=돋움 color=#000000>9612</FONT></P></TD>
<TD class=xl63 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #00b050">
<P align=center><FONT face=돋움 color=#000000>7356</FONT></P></TD></TR>
<TR style="HEIGHT: 13.5pt" height=18>
<TD class=xl67 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>
<P align=center><FONT face=돋움 color=#000000>20</FONT></P></TD>
<TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffc000">
<P align=center><FONT face=돋움 color=#000000>304</FONT></P></TD>
<TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #4f81bd">
<P align=center><FONT face=돋움 color=#000000>3000</FONT></P></TD>
<TD class=xl64 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #c0504d">
<P align=center><FONT face=돋움 color=#000000>10393</FONT></P></TD>
<TD class=xl63 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #00b050">
<P align=center><FONT face=돋움 color=#000000>5966</FONT></P></TD></TR>
<TR style="HEIGHT: 13.5pt" height=18>
<TD class=xl67 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>
<P align=center><FONT face=돋움 color=#000000>21</FONT></P></TD>
<TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffc000">
<P align=center><FONT face=돋움 color=#000000>383</FONT></P></TD>
<TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #4f81bd">
<P align=center><FONT face=돋움 color=#000000>2655</FONT></P></TD>
<TD class=xl64 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #c0504d">
<P align=center><FONT face=돋움 color=#000000>9604</FONT></P></TD>
<TD class=xl63 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #00b050">
<P align=center><FONT face=돋움 color=#000000>6523</FONT></P></TD></TR>
<TR style="HEIGHT: 13.5pt" height=18>
<TD class=xl67 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>
<P align=center><FONT face=돋움 color=#000000>22</FONT></P></TD>
<TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffc000">
<P align=center><FONT face=돋움 color=#000000>71</FONT></P></TD>
<TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #4f81bd">
<P align=center><FONT face=돋움 color=#000000>3019</FONT></P></TD>
<TD class=xl64 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #c0504d">
<P align=center><FONT face=돋움 color=#000000>10368</FONT></P></TD>
<TD class=xl63 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #00b050">
<P align=center><FONT face=돋움 color=#000000>5188</FONT></P></TD></TR></TBODY></TABLE></P>
<!-- -->
]]>
카페 게시글
질의 & 답변
경품추첨 프로그램을 만들었습니다. 그리고 질문 있습니다.
최종섭
추천 0
조회 886
08.04.16 20:58
댓글 6
북마크 번역하기 공유하기 기능 더보기
다음검색
첫댓글 ^^; 안녕하세요 최종섭님 ! 질문주신 내용이 잘 이해가 되질 않습니다. 구체적으로 어떻게 나와야 하는지 예시를 주시면 아마도 카페에 계신분들로 부터 도움을 받으실수 있을것 같습니다.
안녕하세요. 경품번호가 연속되지 않고 4개의 그룹으로 분리되어 있어서 당첨번호추출 열도 4열로 되어있는데요. 4개의 열을 1개의 열에서 처리하고 싶다는 것이 문제의 요지입니다. 감사합니다.
제 답변이 너무 무성의 하게 들릴지도 모르겠습니다만, 그냥 4개의 열로 되어있는 내용을 제일 첫째열 아래로 계속 누적해서 잘라낸후 붙혀 넣으면 안되는건지요? 물론 제가 정확히 내용을 이해하지 못하겠다 한것두 너무 단순한걸 원하시는것 같아서 그게 아닌것 같다는 생각에서 말씀 드렸던 것 입니다.
현재 화면에 보이는 번호는 당첨된 번호입니다. 맨 위에 1~448, 2000~3158, 9001~10673, 5001~7487 번의 행운번호 중에서 뽑혔다는 의미입니다. F9 키를 누르면 새로운 당첨번호가 생성됩니다. 각각의 번호대가 분리되어서 추첨되는데 그것은 한 칸에서 처리하고 싶다는 뜻입니다. 고맙습니다.
복사합니다. 그리고 원하는 위치에 선택하여 붙여넣기해서 "연결하여 붙여넣기"하시면 됩니다. 마라톤 하시든 최선생 맞죠... 오랜만입니다. 반갑습니다.
네..안녕하셨어요. 마라톤 하던 최종섭입니다. 새로 내신 책에 카페 주소가 있어서 반갑게 가입했습니다. 앞으로도 자주 인사드리겠습니다. 감사합니다.