<span style="color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1000003814697px;">머리속으로 생각하는 구조가 있는데 엑셀로 구현할줄 모르겠습니다..ㅠ</span> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1000003814697px;">엑셀로 구현하기 어려운건가도 모르겠어요..</div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1000003814697px;"><br></div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1000003814697px;">13 </div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1000003814697px;">40</div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1000003814697px;">19</div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1000003814697px;">40</div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1000003814697px;">12</div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1000003814697px;">40</div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1000003814697px;">5</div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1000003814697px;">10</div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1000003814697px;">20</div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1000003814697px;">21</div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1000003814697px;">100</div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1000003814697px;">19</div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1000003814697px;">100</div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1000003814697px;">60</div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1000003814697px;">19</div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1000003814697px;">61</div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1000003814697px;">40</div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1000003814697px;">100</div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1000003814697px;">40</div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1000003814697px;"><br style="margin:0px;padding:0px;"></div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1000003814697px;">이런 데이터가 있는데 여기에서 결과값이</div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1000003814697px;"><br style="margin:0px;padding:0px;"></div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1000003814697px;">19 -> 3개</div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1000003814697px;">40 -> 5개</div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1000003814697px;"><br style="margin:0px;padding:0px;"></div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1000003814697px;">이렇게 나오게 하고 싶습니다.</div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1000003814697px;"><br style="margin:0px;padding:0px;"></div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1000003814697px;">자세한 조건은</div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1000003814697px;">3개이상 중복된 수를 표시하고, 그 수<span style="margin:0px;padding:0px;line-height:1.5;">의 갯수를 표시</span></div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1000003814697px;">단 100은 제외한다.</div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1000003814697px;"><span style="margin:0px;padding:0px;line-height:1.5;"><br style="margin:0px;padding:0px;"></span></div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1000003814697px;"><span style="margin:0px;padding:0px;line-height:1.5;">능력자님들 도와주세요ㅜㅜ</span></div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1000003814697px;"><span style="margin:0px;padding:0px;line-height:1.5;">아무리 책을 봐도 빙글빙글...돌겠네요 ㅠㅠ</span></div>
댓글 분란 또는 분쟁 때문에 전체 댓글이 블라인드 처리되었습니다.