<div style="text-align:left;"> <table border="0" cellpadding="0" cellspacing="0" width="128" style="border-collapse:collapse;width:96pt;"><colgroup><col width="64" span="2" style="width:48pt;"></colgroup><tbody><tr height="18" style="height:13.5pt;"><td height="18" class="xl64" width="64" style="height:13.5pt;width:48pt;">판매자</td> <td class="xl64" width="64" style="border-left:none;width:48pt;">판매품목</td> </tr><tr height="18" style="height:13.5pt;"><td height="18" class="xl63" style="height:13.5pt;border-top:none;">유재석</td> <td class="xl63" style="border-top:none;border-left:none;">사과</td> </tr><tr height="18" style="height:13.5pt;"><td height="18" class="xl63" style="height:13.5pt;border-top:none;">김종국</td> <td class="xl63" style="border-top:none;border-left:none;">사과</td> </tr><tr height="18" style="height:13.5pt;"><td height="18" class="xl63" style="height:13.5pt;border-top:none;">김종국</td> <td class="xl63" style="border-top:none;border-left:none;">사과</td> </tr><tr height="18" style="height:13.5pt;"><td height="18" class="xl63" style="height:13.5pt;border-top:none;">유재석</td> <td class="xl63" style="border-top:none;border-left:none;">사과</td> </tr><tr height="18" style="height:13.5pt;"><td height="18" class="xl63" style="height:13.5pt;border-top:none;">김종국</td> <td class="xl63" style="border-top:none;border-left:none;">귤</td> </tr><tr height="18" style="height:13.5pt;"><td height="18" class="xl63" style="height:13.5pt;border-top:none;">김종국</td> <td class="xl63" style="border-top:none;border-left:none;">귤</td> </tr><tr height="18" style="height:13.5pt;"><td height="18" class="xl63" style="height:13.5pt;border-top:none;">김종국</td> <td class="xl63" style="border-top:none;border-left:none;">배</td> </tr><tr height="18" style="height:13.5pt;"><td height="18" class="xl63" style="height:13.5pt;border-top:none;">유재석</td> <td class="xl63" style="border-top:none;border-left:none;">배</td> </tr><tr height="18" style="height:13.5pt;"><td height="18" class="xl63" style="height:13.5pt;border-top:none;">유재석</td> <td class="xl63" style="border-top:none;border-left:none;">배</td> </tr><tr height="18" style="height:13.5pt;"><td height="18" class="xl63" style="height:13.5pt;border-top:none;">유재석</td> <td class="xl63" style="border-top:none;border-left:none;">배</td> </tr><tr height="18" style="height:13.5pt;"><td height="18" class="xl63" style="height:13.5pt;border-top:none;">유재석</td> <td class="xl63" style="border-top:none;border-left:none;">귤</td> </tr><tr height="18" style="height:13.5pt;"><td height="18" class="xl63" style="height:13.5pt;border-top:none;">유재석</td> <td class="xl63" style="border-top:none;border-left:none;">사과</td> </tr><tr height="18" style="height:13.5pt;"><td height="18" class="xl63" style="height:13.5pt;border-top:none;">유재석</td> <td class="xl63" style="border-top:none;border-left:none;">귤</td> </tr><tr height="18" style="height:13.5pt;"><td height="18" class="xl63" style="height:13.5pt;border-top:none;">유재석</td> <td class="xl63" style="border-top:none;border-left:none;">망고</td> </tr><tr height="18" style="height:13.5pt;"><td height="18" class="xl63" style="height:13.5pt;border-top:none;">유재석</td> <td class="xl63" style="border-top:none;border-left:none;">망고</td> </tr><tr height="18" style="height:13.5pt;"><td height="18" class="xl63" style="height:13.5pt;border-top:none;">유재석</td> <td class="xl63" style="border-top:none;border-left:none;">딸기</td> </tr><tr height="18" style="height:13.5pt;"><td height="18" class="xl63" style="height:13.5pt;border-top:none;">유재석</td> <td class="xl63" style="border-top:none;border-left:none;">딸기</td> </tr><tr height="18" style="height:13.5pt;"><td height="18" class="xl63" style="height:13.5pt;border-top:none;">김종국</td> <td class="xl63" style="border-top:none;border-left:none;">딸기</td> </tr><tr height="18" style="height:13.5pt;"><td height="18" class="xl63" style="height:13.5pt;border-top:none;">김종국</td> <td class="xl63" style="border-top:none;border-left:none;">딸기</td> </tr><tr height="18" style="height:13.5pt;"><td height="18" class="xl63" style="height:13.5pt;border-top:none;">유재석</td> <td class="xl63" style="border-top:none;border-left:none;">오렌지</td> </tr><tr height="18" style="height:13.5pt;"><td height="18" class="xl63" style="height:13.5pt;border-top:none;">유재석</td> <td class="xl63" style="border-top:none;border-left:none;">오렌지</td> </tr><tr height="18" style="height:13.5pt;"><td height="18" class="xl63" style="height:13.5pt;border-top:none;">김종국</td> <td class="xl63" style="border-top:none;border-left:none;">오렌지</td> </tr><tr height="18" style="height:13.5pt;"><td height="18" class="xl63" style="height:13.5pt;border-top:none;">유재석</td> <td class="xl63" style="border-top:none;border-left:none;">오렌지</td> </tr></tbody></table><br></div> <div>위와 같은 표가 있습니다.</div> <div>저는 유재석, 김종국 별로 어떤 종류의 과일을 팔았는지 카운트 하고 싶어요. </div> <div><span style="font-size:9pt;">유재석은 6가지, 김종국은 5가지를 팔았다는 결과가 제가 원하는 값입니다. </span></div> <div><br></div> <div>문제는 제가 이걸 중복데이터 제거 후 필터링해서 개수를 헤아리는데요. </div> <div><br></div> <div>좀 더 간단히 해결할수 있는 수식이 있을까요?</div> <div> <div style="text-align:left;"><img src="http://thimg.todayhumor.co.kr/upfile/201706/1496620900e2bd1056c193494ba5e5abaf8dbde268__mn74774__w171__h475__f30838__Ym201706.jpg" width="171" height="475" alt="과일2.jpg" style="border:none;" filesize="30838"></div><br></div>
댓글 분란 또는 분쟁 때문에 전체 댓글이 블라인드 처리되었습니다.