<div style="text-align:left;"><img width="800" height="250" class="chimg_photo" alt="화면 캡쳐012.jpg" src="http://thimg.todayhumor.co.kr/upfile/201505/1431128334rS9nMULsyFHyg8.jpg"></div> <div> </div> <div><strong>※ 사용한 함수</strong></div> <div>D2셀 : =IF(B2=B3, "", B2)</div> <div>E2셀 : =IF(D2="", "", C2)</div> <div>F2셀 : =IF(D2="", "", COUNTIF(B:B,D2))</div> <div>G2셀 : =IF(C2=C3, "", IF(B2=B3, "다중이", ""))</div> <div>H2셀 : =IF(C2=C3, "", C2)</div> <div>I2셀 : =IF(H2="", "", B2)</div> <div>J2셀 : =IF(I2="", "", COUNTIF(C:C,H2))</div> <div>K2셀 : =IF(B2=B3, "", IF(C2=C3, "다중이", ""))</div> <div> </div> <div> </div> <div>※ 한 아이피로 다중아이디를 사용한 경우도 있고 (하늘색)</div> <div> 한 아이디로 다중아이피를 사용한 경우도 있어서 (분홍색) 수식을 2종류 넣었습니다.</div> <div>즉, <font>자동필터링후 IP(B열)로 오름차순정렬시 하늘색만 </font>참이고, <font>ID(C열)로 오름차순 정렬시 붉은셀만 </font>참입니다.</div> <div> </div> <div> </div> <div> </div> <div> </div> <div><strong><font>※ IP로 정렬해서 10회 이상인 값만 필터링시 </font></strong></div> <div><strong></strong> </div> <div style="text-align:left;"><img width="271" height="415" alt="화면 캡쳐013.jpg" src="http://thimg.todayhumor.co.kr/upfile/201505/1431129085qyrPG7vTNU.jpg"></div> <div style="text-align:left;"> </div> <div><font>IP필터링_IP IP필터링_ID IP필터링_횟수</font><br>ZF9kZ2ZjZ6unkpeq aGRjbGdr 13<br>ZF9kZmljaaadlZKy amNqaGQ= 10<br>ZF9kZmVjaamdlpOr ZGZqamlo 13<br>ZGhnYWVma6KjnY+rYms= aGRoZWhu 10<br>ZGhnYWVna6KhlJOnZWk= ZWRnY2ts 11<br>ZGhnYWZlbKKgm5WnZGo= ZWFkZGZr 21<br>ZGJkYWVrb6KglpmnY2ts aWJmZmdm 19<br>ZGJkYWZnZ6KhlpenY2po aGRoaGVl 16<br>ZGJmYWZla6KgnJOnY2Nt a2VnZ2w= 10<br>ZGJpYWloZKqokpKqZA== ZWJiZGhp 11<br>ZGJpYWVmZ6KgnI+qaGQ= ZmhoZGZo 17<br>ZGJrYWpsZKaikpOq aGZnbG1u 19<br>ZGlkYWVsaKKgmJmnZ2U= aGRiamdr 21<br>ZGllYW1sZKaklo+xaw== ZWNnY2Q= 14<br>ZGNjYWVoaqKgmJKnaGY= Z2dnZGho 16<br>ZGNlYWVpaaKml4+qZ2g= ZmFlbG1o 14<br>ZGNmYWhuZKaklY+rYmU= ZmVia2dm 13<br>ZGNrYWZqaqKgm5Wna2U= ZGVjamZt 12<br>ZGVgZ2pjZ6WokpKsZg== Z2ZkaGRo 15<br>ZGVgZmtjZ6qmkpOpag== aGdjZWdt 11<br>ZWFlYWZoaKKgnI+yZw== Zmdra2Rr 10<br>ZWJjYWVub6KhlZOnZ2c= ZGRmaWVn 36<br>ZWJjYWZmb6KhmJKnZGs= ZGVoZmlu 10<br>ZWJjYWZna6KlmI+raA== aGpjZGdq 10<br>ZWJjYWZnaKKinI+tYg== ZmdiZmlm 24<br>ZWJrYWZpZqKgmpinZmo= ZGlrY2Vs 10<br>ZWNiYWtlZKmkkpKx aGRpbGVu 10<br>ZWNiYWVmbaKglJOnZGRt ZGpnamdt 16</div> <div> </div> <div><br><strong><font color="#ff0000"></font></strong> </div> <div><font color="#ff0000"><strong>※ ID로 정렬해서 10회 이상인 값만 필터링시 </strong></font><font>(IP로 필터링한 것 다시 원복 필요)</font></div> <div> </div> <div><font>ID필터링_ID ID필터링_IP ID필터링_횟수</font><br>a2VnZ2w= ZGJmYWZla6KgnJOnZWU= 14<br>aGdjZWdt ZGVgZmtjZ6qmkpOpag== 14<br>aGdpa21n ZWNlYWVoa6KgnJanY2tl 17<br>aGpjZGdq ZWJjYWZna6KlmI+raA== 15<br>aGRiamdr ZWNlYWpnZKagmo+qaWU= 24<br>aGRjbGdr ZF9kZ2ZjZ6unkpeq 13<br>aGRoaGVl ZGJkYWZnZ6KhlpenY2po 16<br>aGRoZWhu ZGhnYWVma6KjnY+rYms= 10<br>aGRpbGVu ZWNiYWtlZKmkkpKx 10<br>aGZnbG1n ZGNnYWVuZ6KhlpinZGo= 10<br>aGZnbG1u ZGJrYWpsZKaikpOq 19<br>amNqaGQ= ZF9kZmljaaadlZKy 10<br>ampnamg= ZGNjYWVraqKhmJGna2s= 24<br>aWJkaWdu ZWJqYWhtZKifkpKuZw== 12<br>aWJmZmdm ZGJkYWVrb6KglpmnY2ts 19<br>Z2dnZGho ZGNjYWVoaqKgmJKnaGY= 16<br>Z2ppbGZm ZGJkYWVqa6KgmZKnaA== 10<br>Z2ZkaGRo ZGVgZ2pjZ6WokpKsZg== 15<br>ZGdqY2to ZGJjYWpqZKWjlI+qa2w= 13<br>ZGJoamxr ZGJpYWVmZ6Khkpqy 10<br>ZGlrY2Vs ZWJrYWZpZqKgmpinZmo= 10<br>ZGpnamdt ZWNiYWVmbaKglJOnZGRt 16<br>ZGRmaWVn ZWJjYWVub6KhlZOnZ2c= 36<br>ZGVjamZt ZGNrYWZqaqKgm5Wna2U= 12<br>ZGVoZmlu ZWJjYWZmb6KhmJKnZGs= 10<br>ZGZpbGVp ZWNjYWVqb6Khl5mnamw= 10<br>ZGZqamlo ZGliYWptZKankpOu 14<br>ZmdiZmlm ZWJjYWZnaKKinI+tYg== 25<br>ZmdnbG1l ZWNlYWpnZKahlo+rZGk= 16<br>Zmdra2Rr ZWFlYWZoaKKgnI+yZw== 10<br>ZmFlbG1o ZGNlYWVpaaKml4+qZ2g= 14<br>ZmFoaWpp a2pgZGZjbqWdlZax 14<br>ZmFqamxt ZGJkYWVra6Knm4+xYg== 11<br>ZmhoZGZo ZGliYWVtb6KglJKnY2hs 20<br>ZmNoZ2Vp ZWJjYWVuaaKjl4+qaGY= 10<br>ZmVia2dm ZGNmYWhuZKaklY+rYmU= 13<br>ZWFkZGZr ZGhnYWZnaaKinI+qamY= 26<br>ZWJiZGhp ZGJpYWloZKqokpKqZA== 11<br>ZWJjZmVm ZGdnYWVoaKKgl5inZGVm 10<br>ZWNnY2Q= ZWNlYWpnZKWml4+qYmo= 15<br>ZWRnY2ts ZGhnYWVna6KhlJOnZWk= 11</div> <div><br> </div> <div> </div> <div>다중아이피는 다른 기기로 접속시 아이피 변동이 생길 수 있기에 다중아이디를 사용한 아이피만 나열합니다.</div> <div>ZGJkYWVraaKjl4+qaWc=<br>ZGJkYWVsa6KgnJinY2k=<br>ZGJqYWhlZKmlkpKtZA==<br>ZGJrYWtlZK2okpSv<br>ZGliYWpsZKWhnY+qa2k=<br>ZGNjYWVraqKikpOpaQ==<br>ZGNmYWVmZ6Kgl5KnZGc=<br>ZGNnYWVsb6KgmZWnY2ls<br>ZGVgZm1jZ6yhkpKpZQ==<br>ZWJiYW1pZKigkpmy<br>ZWNiYWVmbqKgm5anZmY=<br>ZWNlYWpnZKWml4+waA==</div>
댓글 분란 또는 분쟁 때문에 전체 댓글이 블라인드 처리되었습니다.