<![CDATA[
<P>엑셀 고수분들 꼭 이것 좀 해결해 주세요</P>
<P> </P>
<P>제가 아무리 생각해도 방법을 못찾겠어요</P>
<P> </P>
<P>인터넷 뒤져도 답이 없는 것 같고요...</P>
<P> </P>
<P>보기1 ----> 데이터 좌측기준으로 오름차순 정렬----> 이 방법은 아주 잘 하는데요...</P>
<P>
<TABLE style="WIDTH: 142pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=189 border=0 x:str="">
<COLGROUP>
<COL style="WIDTH: 142pt; mso-width-source: userset; mso-width-alt: 5376" width=189></COLGROUP>
<TBODY>
<TR style="HEIGHT: 15pt; mso-height-source: userset" height=20>
<TD class=xl26 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver 0.5pt solid; BORDER-LEFT: silver 0.5pt solid; WIDTH: 142pt; BORDER-BOTTOM: silver 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" width=189 height=20>가정법 과거 주절</TD></TR>
<TR style="HEIGHT: 15pt; mso-height-source: userset" height=20>
<TD class=xl26 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver 0.5pt solid; WIDTH: 142pt; BORDER-BOTTOM: silver 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" width=189 height=20>가정법 과거 형식</TD></TR>
<TR style="HEIGHT: 15pt; mso-height-source: userset" height=20>
<TD class=xl26 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver 0.5pt solid; WIDTH: 142pt; BORDER-BOTTOM: silver 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" width=189 height=20>가정법 과거완료</TD></TR>
<TR style="HEIGHT: 15pt; mso-height-source: userset" height=20>
<TD class=xl26 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver 0.5pt solid; WIDTH: 142pt; BORDER-BOTTOM: silver 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" width=189 height=20>가정법 과거완료 주절</TD></TR>
<TR style="HEIGHT: 15pt; mso-height-source: userset" height=20>
<TD class=xl26 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver 0.5pt solid; WIDTH: 142pt; BORDER-BOTTOM: silver 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" width=189 height=20>가정법 과거완료 형식</TD></TR>
<TR style="HEIGHT: 15pt; mso-height-source: userset" height=20>
<TD class=xl26 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver 0.5pt solid; WIDTH: 142pt; BORDER-BOTTOM: silver 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" width=189 height=20>가정법 관용표현</TD></TR>
<TR style="HEIGHT: 15pt; mso-height-source: userset" height=20>
<TD class=xl26 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver 0.5pt solid; WIDTH: 142pt; BORDER-BOTTOM: silver 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" width=189 height=20>가정법 대표적 형식</TD></TR>
<TR style="HEIGHT: 15pt; mso-height-source: userset" height=20>
<TD class=xl26 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver 0.5pt solid; WIDTH: 142pt; BORDER-BOTTOM: silver 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" width=189 height=20>가정법 동사 형태</TD></TR>
<TR style="HEIGHT: 15pt; mso-height-source: userset" height=20>
<TD class=xl26 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver 0.5pt solid; WIDTH: 142pt; BORDER-BOTTOM: silver 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" width=189 height=20>가정법 문장</TD></TR></TBODY></TABLE></P>
<P align=left> </P>
<P align=left>보기2 ----> 데이터 우측기준으로 오름차순 정렬----> 이렇게 정렬하는 방법 없을 까요?</P>
<P align=left></P>
<P>
<TABLE style="WIDTH: 113pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=150 border=0 x:str="">
<COLGROUP>
<COL style="WIDTH: 113pt; mso-width-source: userset; mso-width-alt: 4266" width=150></COLGROUP>
<TBODY>
<TR style="HEIGHT: 15pt; mso-height-source: userset" height=20>
<TD class=xl26 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver 0.5pt solid; BORDER-LEFT: silver 0.5pt solid; WIDTH: 113pt; BORDER-BOTTOM: silver 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" width=150 height=20> 가정법 과거완료</TD></TR>
<TR style="HEIGHT: 15pt; mso-height-source: userset" height=20>
<TD class=xl26 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver 0.5pt solid; WIDTH: 113pt; BORDER-BOTTOM: silver 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" width=150 height=20> 가정법 과거 형식</TD></TR>
<TR style="HEIGHT: 15pt; mso-height-source: userset" height=20>
<TD class=xl26 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver 0.5pt solid; WIDTH: 113pt; BORDER-BOTTOM: silver 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" width=150 height=20> 가정법 과거완료 형식</TD></TR>
<TR style="HEIGHT: 15pt; mso-height-source: userset" height=20>
<TD class=xl26 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver 0.5pt solid; WIDTH: 113pt; BORDER-BOTTOM: silver 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" width=150 height=20> 가정법 대표적 형식</TD></TR>
<TR style="HEIGHT: 15pt; mso-height-source: userset" height=20>
<TD class=xl26 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver 0.5pt solid; WIDTH: 113pt; BORDER-BOTTOM: silver 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" width=150 height=20> 가정법 문장</TD></TR>
<TR style="HEIGHT: 15pt; mso-height-source: userset" height=20>
<TD class=xl26 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver 0.5pt solid; WIDTH: 113pt; BORDER-BOTTOM: silver 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" width=150 height=20> 가정법 과거 주절</TD></TR>
<TR style="HEIGHT: 15pt; mso-height-source: userset" height=20>
<TD class=xl26 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver 0.5pt solid; WIDTH: 113pt; BORDER-BOTTOM: silver 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" width=150 height=20> 가정법 과거완료 주절</TD></TR>
<TR style="HEIGHT: 15pt; mso-height-source: userset" height=20>
<TD class=xl26 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver 0.5pt solid; WIDTH: 113pt; BORDER-BOTTOM: silver 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" width=150 height=20> 가정법 동사 형태</TD></TR>
<TR style="HEIGHT: 15pt; mso-height-source: userset" height=20>
<TD class=xl26 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver 0.5pt solid; WIDTH: 113pt; BORDER-BOTTOM: silver 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" width=150 height=20> 가정법 관용표현</TD></TR></TBODY></TABLE></P>
<P align=left> </P>
<P align=left>보기2 처럼 정렬하는 방법 좀 가르쳐 주세요...</P>
<!-- -->
]]>
첫댓글 일반적인 방법으로는 불가능합니다. 억지로 VBA를 이용하면 가능하겠지만 그 노력 그 시간에 수작업하는 것이 빠르죠...데이터가 엄청 많다면 모르겠지만...하지만 이런 것이 현생활에 일어날까하는 의문은 듭니다.
아 그렇군요, 감사합니다.