Re:많은 데이터에서 중복개수와 해당 중복값 찾기

<p style="margin: 0px; padding: 0px; text-align: left; color: rgb(92, 92, 92); text-transform: none; text-indent: 0px; letter-spacing: normal; font-family: gulim; font-size: 12px; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; word-spacing: 0px; white-space: normal; orphans: 2; -webkit-text-stroke-width: 0px;"> <p style="margin: 0px; padding: 0px; text-align: left; color: rgb(92, 92, 92); text-transform: none; text-indent: 0px; letter-spacing: normal; font-family: gulim; font-size: 12px; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; word-spacing: 0px; white-space: normal; orphans: 2; -webkit-text-stroke-width: 0px;">안녕하세요?   [광개토대왕담덕]님...<p style="margin: 0px; padding: 0px; text-align: left; color: rgb(92, 92, 92); text-transform: none; text-indent: 0px; letter-spacing: normal; font-family: gulim; font-size: 12px; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; word-spacing: 0px; white-space: normal; orphans: 2; -webkit-text-stroke-width: 0px;"> <p style="margin: 0px; padding: 0px; text-align: left; color: rgb(92, 92, 92); text-transform: none; text-indent: 0px; letter-spacing: normal; font-family: gulim; font-size: 12px; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; word-spacing: 0px; white-space: normal; orphans: 2; -webkit-text-stroke-width: 0px;">VBA와 SQL을 전혀 모르신다고 하시니 엑셀 2016버젼부터 내장된 파워쿼리를 권합니다.<p style="margin: 0px; padding: 0px; text-align: left; color: rgb(92, 92, 92); text-transform: none; text-indent: 0px; letter-spacing: normal; font-family: gulim; font-size: 12px; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; word-spacing: 0px; white-space: normal; orphans: 2; -webkit-text-stroke-width: 0px;">일단 데이터를 표로 지정하시고 파워쿼리 편집기로 해당 데이터를 넘기고 피벗 해제합니다.<p style="margin: 0px; padding: 0px; text-align: left; color: rgb(92, 92, 92); text-transform: none; text-indent: 0px; letter-spacing: normal; font-family: gulim; font-size: 12px; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; word-spacing: 0px; white-space: normal; orphans: 2; -webkit-text-stroke-width: 0px;">그리고 다시 닫기 및 로드를 통해 엑셀창으로 넘겨 피벗테이블을 활용하면 됩니다.<p style="margin: 0px; padding: 0px; text-align: left; color: rgb(92, 92, 92); text-transform: none; text-indent: 0px; letter-spacing: normal; font-family: gulim; font-size: 12px; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; word-spacing: 0px; white-space: normal; orphans: 2; -webkit-text-stroke-width: 0px;"> <p style="margin: 0px; padding: 0px; text-align: left; color: rgb(92, 92, 92); text-transform: none; text-indent: 0px; letter-spacing: normal; font-family: gulim; font-size: 12px; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; word-spacing: 0px; white-space: normal; orphans: 2; -webkit-text-stroke-width: 0px;">첨부한 자료는 질문한 자료의 결과입니다.<p style="margin: 0px; padding: 0px; text-align: left; color: rgb(92, 92, 92); text-transform: none; text-indent: 0px; letter-spacing: normal; font-family: gulim; font-size: 12px; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; word-spacing: 0px; white-space: normal; orphans: 2; -webkit-text-stroke-width: 0px;">데이터가 더 크다면 다중시트나 다중파일로 처리하세요.<p style="margin: 0px; padding: 0px; text-align: left; color: rgb(92, 92, 92); text-transform: none; text-indent: 0px; letter-spacing: normal; font-family: gulim; font-size: 12px; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; word-spacing: 0px; white-space: normal; orphans: 2; -webkit-text-stroke-width: 0px;"> <p style="margin: 0px; padding: 0px; text-align: left; color: rgb(92, 92, 92); text-transform: none; text-indent: 0px; letter-spacing: normal; font-family: gulim; font-size: 12px; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; word-spacing: 0px; white-space: normal; orphans: 2; -webkit-text-stroke-width: 0px;">그럼 잘 해결되시길...   ^^*<p style="margin: 0px; padding: 0px; text-align: left; color: rgb(92, 92, 92); text-transform: none; text-indent: 0px; letter-spacing: normal; font-family: gulim; font-size: 12px; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; word-spacing: 0px; white-space: normal; orphans: 2; -webkit-text-stroke-width: 0px;"> <p style="margin: 0px; padding: 0px; text-align: left; color: rgb(92, 92, 92); text-transform: none; text-indent: 0px; letter-spacing: normal; font-family: gulim; font-size: 12px; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; word-spacing: 0px; white-space: normal; orphans: 2; -webkit-text-stroke-width: 0px;">================================================================================<p style="margin: 0px; padding: 0px; text-align: left; color: rgb(92, 92, 92); text-transform: none; text-indent: 0px; letter-spacing: normal; font-family: gulim; font-size: 12px; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; word-spacing: 0px; white-space: normal; orphans: 2; -webkit-text-stroke-width: 0px;">첨부파일<p style="margin: 0px; padding: 0px; text-align: left; color: rgb(92, 92, 92); text-transform: none; text-indent: 0px; letter-spacing: normal; font-family: gulim; font-size: 12px; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; word-spacing: 0px; white-space: normal; orphans: 2; -webkit-text-stroke-width: 0px;"> <p style="margin: 0px; padding: 0px; text-align: left; color: rgb(92, 92, 92); text-transform: none; text-indent: 0px; letter-spacing: normal; font-family: gulim; font-size: 12px; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; word-spacing: 0px; white-space: normal; orphans: 2; -webkit-text-stroke-width: 0px;"><a href='javascript:fileFilterViewer("http://cfile246.uf.daum.net/attach/9960C2455CFE6612192D6D", "/cfile246/99/60C2455CFE6612192D6D", "190610_800만 데이터_중복값과 중복개수찾기_결과.xlsx", "grpid%3D1GIVp%26fldid%3DK4Nh%26dataid%3D3681%26fileid%3D1%26regdt%3D20190610231557&url=http%3A%2F%2Fcfile246.uf.daum.net%2Fattach%2F9960C2455CFE6612192D6D")'><img src="https://t1.daumcdn.net/daumtop_deco/icon/icon.hanmail.net/editor/p_etc_s.gif" border="0" alt="첨부파일" class="vam"/> 190610_800만 데이터_중복값과 중복개수찾기_결과.xlsx</a><p style="margin: 0px; padding: 0px; text-align: left; color: rgb(92, 92, 92); text-transform: none; text-indent: 0px; letter-spacing: normal; font-family: gulim; font-size: 12px; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; word-spacing: 0px; white-space: normal; orphans: 2; -webkit-text-stroke-width: 0px;"><p style="margin: 0px; padding: 0px; text-align: left; color: rgb(92, 92, 92); text-transform: none; text-indent: 0px; letter-spacing: normal; font-family: gulim; font-size: 12px; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; word-spacing: 0px; white-space: normal; orphans: 2; -webkit-text-stroke-width: 0px;"><p style="margin: 0px; padding: 0px; text-align: left; color: rgb(92, 92, 92); text-transform: none; text-indent: 0px; letter-spacing: normal; font-family: gulim; font-size: 12px; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; word-spacing: 0px; white-space: normal; orphans: 2; -webkit-text-stroke-width: 0px;">================================================================================<p style="margin: 0px; padding: 0px; text-align: left; color: rgb(92, 92, 92); text-transform: none; text-indent: 0px; letter-spacing: normal; font-family: gulim; font-size: 12px; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; word-spacing: 0px; white-space: normal; orphans: 2; -webkit-text-stroke-width: 0px;"> <p style="margin: 0px; padding: 0px; text-align: left; color: rgb(92, 92, 92); text-transform: none; text-indent: 0px; letter-spacing: normal; font-family: gulim; font-size: 12px; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; word-spacing: 0px; white-space: normal; orphans: 2; -webkit-text-stroke-width: 0px;">