[{"keyword":"\ube14\ub8e8\uc544\uce74","rank":0},{"keyword":"\ubc84\ud29c\ubc84","rank":0},{"keyword":"\uc2a4\ud0c0\ub808\uc77c","rank":1},{"keyword":"\ub9d0\ub538","rank":1},{"keyword":"@","rank":2},{"keyword":"\ub864","rank":-3},{"keyword":"\uc720\ud76c\uc655","rank":-1},{"keyword":"\ub2c8\ucf00","rank":0},{"keyword":"\uadfc\ud29c\ubc84","rank":13},{"keyword":"\uac74\ub2f4","rank":0},{"keyword":"\uc6d0\uc2e0","rank":-2},{"keyword":"\uc2a4\ud154\ub77c","rank":7},{"keyword":"\ub9bc\ubc84\uc2a4","rank":2},{"keyword":"\uc6d0\ud53c\uc2a4","rank":0},{"keyword":"\ub4dc\ub798\uace4\ubcfc","rank":-3},{"keyword":"\uc778\ubc29","rank":5},{"keyword":"\ub358\ud30c","rank":-1},{"keyword":"\ud2b8\ub9ad\uceec","rank":"new"},{"keyword":"\uac00\uba74\ub77c\uc774\ub354","rank":1},{"keyword":"\uc77c\ubcf8","rank":"new"},{"keyword":"\ud1a0\ub9ac\ucf54","rank":"new"},{"keyword":"\ube14\ub8e8","rank":"new"}]
(IP보기클릭)175.200.***.***
(IP보기클릭)61.78.***.***
아하! 이제야 이해가 가네요. 생각해보니 공백빼곤 다 찾아내는 DCOUNTA 함수가 있는데도 문제서 DCOUNT를 쓰라고 해서 약간 헷갈렸던거 같아요. 굳이 DCOUNT를 쓰라고 지시하면 숫자값이 있는 필드를 대신 찾도록 유도하는 문제였네요.. | 17.09.20 19:59 | |