<![CDATA[
<P>
<TABLE style="WIDTH: 96pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=128 border=0>
<COLGROUP>
<COL style="WIDTH: 42pt; mso-width-source: userset; mso-width-alt: 1792" width=56>
<COL style="WIDTH: 54pt" width=72>
<TBODY>
<TR style="HEIGHT: 16.5pt" height=22>
<TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 42pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 16.5pt; BACKGROUND-COLOR: transparent" width=56 height=22><FONT face="맑은 고딕" color=#000000 size=3>1</FONT></TD>
<TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=72><FONT face="맑은 고딕" color=#000000 size=3>가</FONT></TD></TR>
<TR style="HEIGHT: 16.5pt" height=22>
<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; HEIGHT: 16.5pt; BACKGROUND-COLOR: transparent" height=22><FONT face="맑은 고딕" color=#000000 size=3>2</FONT></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: transparent"><FONT face="맑은 고딕" color=#000000 size=3>나</FONT></TD></TR>
<TR style="HEIGHT: 16.5pt" height=22>
<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; HEIGHT: 16.5pt; BACKGROUND-COLOR: transparent" height=22><FONT face="맑은 고딕" color=#000000 size=3>3</FONT></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: transparent"><FONT face="맑은 고딕" color=#000000 size=3>다</FONT></TD></TR>
<TR style="HEIGHT: 16.5pt" height=22>
<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; HEIGHT: 16.5pt; BACKGROUND-COLOR: transparent" height=22><FONT face="맑은 고딕" color=#000000 size=3>4</FONT></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: transparent"><FONT face="맑은 고딕" color=#000000 size=3>라</FONT></TD></TR>
<TR style="HEIGHT: 16.5pt" height=22>
<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; HEIGHT: 16.5pt; BACKGROUND-COLOR: transparent" height=22><FONT face="맑은 고딕" color=#000000 size=3>5</FONT></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: transparent"><FONT face="맑은 고딕" color=#000000 size=3>마</FONT></TD></TR></TBODY></TABLE> </P>
<P>여기서 제가 궁금한것은 번호 매기기 할때 채우기 핸들을 사용하지 않고 </P>
<P> </P>
<P>row함수를 사용하면은 만약에 3번에 있는 행을 삭제해도 자동적으로 4번과 5번이 3번 4번으로 되어지는데..</P>
<P> </P>
<P>한행일 경우에는 어떻게 하는지는 알아서 괜찮은데요..</P>
<P> </P>
<P>문제는 여러행의 경우일경우에 어떻게 하는지 몰라서요. 아무리 엑셀 책 찾아봐도 그에 따른 설명은 없어서요..</P>
<P> </P>
<P>
<TABLE style="WIDTH: 108pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=144 border=0>
<COLGROUP>
<COL style="WIDTH: 54pt" span=2 width=72>
<TBODY>
<TR style="HEIGHT: 16.5pt" height=22>
<TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 16.5pt; BACKGROUND-COLOR: transparent" width=72 height=22><FONT face="맑은 고딕" color=#000000 size=3>1</FONT></TD>
<TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=72><FONT face="맑은 고딕" color=#000000 size=3>가</FONT></TD></TR>
<TR style="HEIGHT: 16.5pt" height=22>
<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; HEIGHT: 16.5pt; BACKGROUND-COLOR: transparent" height=22><FONT face="맑은 고딕" color=#000000 size=3> </FONT></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: transparent"><FONT face="맑은 고딕" color=#000000 size=3> </FONT></TD></TR>
<TR style="HEIGHT: 16.5pt" height=22>
<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; HEIGHT: 16.5pt; BACKGROUND-COLOR: transparent" height=22><FONT face="맑은 고딕" color=#000000 size=3> </FONT></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: transparent"><FONT face="맑은 고딕" color=#000000 size=3> </FONT></TD></TR>
<TR style="HEIGHT: 16.5pt" height=22>
<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; HEIGHT: 16.5pt; BACKGROUND-COLOR: transparent" height=22><FONT face="맑은 고딕" color=#000000 size=3>2</FONT></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: transparent"><FONT face="맑은 고딕" color=#000000 size=3>나</FONT></TD></TR>
<TR style="HEIGHT: 16.5pt" height=22>
<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; HEIGHT: 16.5pt; BACKGROUND-COLOR: transparent" height=22><FONT face="맑은 고딕" color=#000000 size=3> </FONT></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: transparent"><FONT face="맑은 고딕" color=#000000 size=3> </FONT></TD></TR>
<TR style="HEIGHT: 16.5pt" height=22>
<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; HEIGHT: 16.5pt; BACKGROUND-COLOR: transparent" height=22><FONT face="맑은 고딕" color=#000000 size=3> </FONT></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: transparent"><FONT face="맑은 고딕" color=#000000 size=3> </FONT></TD></TR>
<TR style="HEIGHT: 16.5pt" height=22>
<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; HEIGHT: 16.5pt; BACKGROUND-COLOR: transparent" height=22><FONT face="맑은 고딕" color=#000000 size=3>3</FONT></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: transparent"><FONT face="맑은 고딕" color=#000000 size=3>다</FONT></TD></TR>
<TR style="HEIGHT: 16.5pt" height=22>
<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; HEIGHT: 16.5pt; BACKGROUND-COLOR: transparent" height=22><FONT face="맑은 고딕" color=#000000 size=3> </FONT></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: transparent"><FONT face="맑은 고딕" color=#000000 size=3> </FONT></TD></TR>
<TR style="HEIGHT: 16.5pt" height=22>
<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; HEIGHT: 16.5pt; BACKGROUND-COLOR: transparent" height=22><FONT face="맑은 고딕" color=#000000 size=3> </FONT></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: transparent"><FONT face="맑은 고딕" color=#000000 size=3> </FONT></TD></TR>
<TR style="HEIGHT: 16.5pt" height=22>
<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; HEIGHT: 16.5pt; BACKGROUND-COLOR: transparent" height=22><FONT face="맑은 고딕" color=#000000 size=3>4</FONT></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: transparent"><FONT face="맑은 고딕" color=#000000 size=3>라</FONT></TD></TR>
<TR style="HEIGHT: 16.5pt" height=22>
<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; HEIGHT: 16.5pt; BACKGROUND-COLOR: transparent" height=22><FONT face="맑은 고딕" color=#000000 size=3> </FONT></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: transparent"><FONT face="맑은 고딕" color=#000000 size=3> </FONT></TD></TR>
<TR style="HEIGHT: 16.5pt" height=22>
<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; HEIGHT: 16.5pt; BACKGROUND-COLOR: transparent" height=22><FONT face="맑은 고딕" color=#000000 size=3> </FONT></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: transparent"><FONT face="맑은 고딕" color=#000000 size=3> </FONT></TD></TR>
<TR style="HEIGHT: 16.5pt" height=22>
<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; HEIGHT: 16.5pt; BACKGROUND-COLOR: transparent" height=22><FONT face="맑은 고딕" color=#000000 size=3>5</FONT></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: transparent"><FONT face="맑은 고딕" color=#000000 size=3>마</FONT></TD></TR>
<TR style="HEIGHT: 16.5pt" height=22>
<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; HEIGHT: 16.5pt; BACKGROUND-COLOR: transparent" height=22><FONT face="맑은 고딕" color=#000000 size=3> </FONT></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: transparent"><FONT face="맑은 고딕" color=#000000 size=3> </FONT></TD></TR>
<TR style="HEIGHT: 16.5pt" height=22>
<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; HEIGHT: 16.5pt; BACKGROUND-COLOR: transparent" height=22><FONT face="맑은 고딕" color=#000000 size=3> </FONT></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: transparent"><FONT face="맑은 고딕" color=#000000 size=3> </FONT></TD></TR></TBODY></TABLE></P>
<P> </P>
<P>이런식의 표일 경우에는 어떻게 해야 하는 건지요?</P>
<P>1번 2번 3번 4번 5번 각각 3행씩 들어가지는 건데요. 이럴경우 row함수는 어떻게 써야지..</P>
<P>여러행에도 순차적인 번호를 매기며, 하나의 번호를 삭제해도 다시 차례대로 번호가 매겨지는 건가요?</P>
<!-- -->
]]>
카페 게시글
Q&A게시판
여러행단위로 번호 매기기.. 단 삭제해도 번호가 이어지는거요
으하하
추천 0
조회 223
09.01.27 18:40
댓글 5
다음검색
첫댓글 =ROW()-COUNTBLANK($A$1:A3)
현재열 순번에서 자기위에 공백셀을 빼버리면 원하는값이 나올거에요..
죄송한데.. 저 수식을 넣으면 0으로 나와요.. ㅜㅜㅜ 두번째말이 뭔말인지 모르겠어요.. ㅠㅠ
흠.. 먼저 a1셀에 1이라고 일단 입력하고,a3셀에 위에 함수를 그대로 입력해 보세요.. 그리고 a3셀에 입력한 값을 아래로 2칸식 띠어서 복사해서 붙이기 하시면 순번되로 입력될거에요.. 그럼 중간에 행을 삭제하던지 추가하더라도 순번이 자동으로 변경될겁니다
답변감사합니다..^^ 조금 변형해서 하니깐 또 저 수식이 안되더라구요.. 이리저리해보다가 해결되었습니다. 정말정말 감사드립니다.*^^* 공백 빼기 함수군요..!! 지식검색하다가 보니 나오네요^^