{"id":439,"date":"2026-09-30T06:41:59","date_gmt":"2026-09-30T06:41:59","guid":{"rendered":"https:\/\/tips-for-office.com\/?p=439"},"modified":"2026-09-04T06:46:24","modified_gmt":"2026-09-04T06:46:24","slug":"%ec%97%91%ec%85%80-%ec%a4%91%eb%b3%b5%ea%b0%92-%ec%a0%9c%ea%b1%b0-%ec%b4%9d%ec%a0%95%eb%a6%ac-%ec%a4%91%eb%b3%b5%ea%b0%92-%ec%b0%be%ea%b8%b0%eb%b6%80%ed%84%b0-unique-%ed%95%a8%ec%88%98","status":"publish","type":"post","link":"https:\/\/tips-for-office.com\/?p=439","title":{"rendered":"\uc5d1\uc140 \uc911\ubcf5\uac12 \uc81c\uac70 \ucd1d\uc815\ub9ac \u2013 \uc911\ubcf5\uac12 \ucc3e\uae30\ubd80\ud130 UNIQUE \ud568\uc218\uae4c\uc9c0"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">\uc5ec\ub7ec \uacf3\uc5d0\uc11c \ubaa8\uc740 \uc790\ub8cc\ub97c \uc815\ub9ac\ud558\ub2e4 \ubcf4\uba74 \uac19\uc740 \uac12\uc774 \ub450\uc138 \ubc88\uc529 \ub4e4\uc5b4\uac00\uace4 \ud569\ub2c8\ub2e4. \uc774\ub7f4 \ub54c \ud544\uc694\ud55c \uc791\uc5c5\uc774 \uc5d1\uc140 \uc911\ubcf5\uac12 \uc81c\uac70\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc774 \uae00\uc5d0\uc11c\ub294 \ub370\uc774\ud130 \ud0ed\uc758 \uc911\ubcf5\ub41c \ud56d\ubaa9 \uc81c\uac70 \uae30\ub2a5\ubd80\ud130 \uc870\uac74\ubd80 \uc11c\uc2dd\uc73c\ub85c \uc911\ubcf5\uac12 \ucc3e\uae30, UNIQUE \ud568\uc218\ub97c \uc774\uc6a9\ud55c \uc911\ubcf5 \uc81c\uac70\uae4c\uc9c0 \ub2e8\uacc4\ubcc4\ub85c \uc815\ub9ac\ud588\uc2b5\ub2c8\ub2e4. \uc0c1\ud669\uc5d0 \ub9de\ub294 \ubc29\ubc95\uc744 \uace8\ub77c \ubc14\ub85c \uc2e4\ubb34\uc5d0 \uc801\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_88 ez-toc-wrap-center counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">\ubaa9\ucc28<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"\ubaa9\ucc28 \ud1a0\uae00\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #ffffff;color:#ffffff\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #ffffff;color:#ffffff\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/tips-for-office.com\/?p=439\/#%EC%97%91%EC%85%80_%EC%A4%91%EB%B3%B5%EA%B0%92_%EC%A0%9C%EA%B1%B0%EA%B0%80_%ED%95%84%EC%9A%94%ED%95%9C_%EC%9D%B4%EC%9C%A0\" >\uc5d1\uc140 \uc911\ubcf5\uac12 \uc81c\uac70\uac00 \ud544\uc694\ud55c \uc774\uc720<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/tips-for-office.com\/?p=439\/#%EC%97%91%EC%85%80_%EC%A4%91%EB%B3%B5%EA%B0%92_%EC%A0%9C%EA%B1%B0_3%EA%B0%80%EC%A7%80_%EB%B0%A9%EB%B2%95\" >\uc5d1\uc140 \uc911\ubcf5\uac12 \uc81c\uac70 3\uac00\uc9c0 \ubc29\ubc95<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/tips-for-office.com\/?p=439\/#%EC%A4%91%EB%B3%B5%EB%90%9C_%ED%95%AD%EB%AA%A9_%EC%A0%9C%EA%B1%B0_%EA%B8%B0%EB%8A%A5%EC%9C%BC%EB%A1%9C_%EB%B0%94%EB%A1%9C_%EC%A7%80%EC%9A%B0%EA%B8%B0\" >\uc911\ubcf5\ub41c \ud56d\ubaa9 \uc81c\uac70 \uae30\ub2a5\uc73c\ub85c \ubc14\ub85c \uc9c0\uc6b0\uae30<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/tips-for-office.com\/?p=439\/#%EC%97%AC%EB%9F%AC_%EC%97%B4%EC%9D%84_%EA%B8%B0%EC%A4%80%EC%9C%BC%EB%A1%9C_%EC%82%AD%EC%A0%9C%ED%95%A0_%EB%95%8C\" >\uc5ec\ub7ec \uc5f4\uc744 \uae30\uc900\uc73c\ub85c \uc0ad\uc81c\ud560 \ub54c<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/tips-for-office.com\/?p=439\/#%EC%A1%B0%EA%B1%B4%EB%B6%80_%EC%84%9C%EC%8B%9D%EC%9C%BC%EB%A1%9C_%EC%A4%91%EB%B3%B5%EA%B0%92_%EC%B0%BE%EA%B8%B0\" >\uc870\uac74\ubd80 \uc11c\uc2dd\uc73c\ub85c \uc911\ubcf5\uac12 \ucc3e\uae30<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/tips-for-office.com\/?p=439\/#COUNTIF_%ED%95%A8%EC%88%98%EB%A1%9C_%EC%A4%91%EB%B3%B5_%ED%99%95%EC%9D%B8%ED%95%98%EA%B8%B0\" >COUNTIF \ud568\uc218\ub85c \uc911\ubcf5 \ud655\uc778\ud558\uae30<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/tips-for-office.com\/?p=439\/#%EC%A4%91%EB%B3%B5_%EC%A0%9C%EA%B1%B0_%ED%95%A8%EC%88%98_UNIQUE_%ED%99%9C%EC%9A%A9%ED%95%98%EA%B8%B0\" >\uc911\ubcf5 \uc81c\uac70 \ud568\uc218 UNIQUE \ud65c\uc6a9\ud558\uae30<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/tips-for-office.com\/?p=439\/#%EC%A4%91%EB%B3%B5_%EC%A0%9C%EA%B1%B0%C2%B7%ED%99%95%EC%9D%B8_%ED%95%A8%EC%88%98_%EB%AA%A8%EC%9D%8C\" >\uc911\ubcf5 \uc81c\uac70\u00b7\ud655\uc778 \ud568\uc218 \ubaa8\uc74c<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/tips-for-office.com\/?p=439\/#SORT_%ED%95%A8%EC%88%98%EB%A1%9C_%EC%A0%95%EB%A0%AC%EA%B9%8C%EC%A7%80_%ED%95%9C_%EB%B2%88%EC%97%90\" >SORT \ud568\uc218\ub85c \uc815\ub82c\uae4c\uc9c0 \ud55c \ubc88\uc5d0<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/tips-for-office.com\/?p=439\/#%EC%9E%90%EC%A3%BC_%EB%AC%BB%EB%8A%94_%EC%A7%88%EB%AC%B8_FAQ\" >\uc790\uc8fc \ubb3b\ub294 \uc9c8\ubb38 (FAQ)<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/tips-for-office.com\/?p=439\/#%EC%A4%91%EB%B3%B5%EB%90%9C_%ED%95%AD%EB%AA%A9_%EC%A0%9C%EA%B1%B0%EC%99%80_UNIQUE_%ED%95%A8%EC%88%98_%EC%A4%91_%EB%AC%B4%EC%97%87%EC%9D%84_%EC%8D%A8%EC%95%BC_%ED%95%98%EB%82%98%EC%9A%94\" >\uc911\ubcf5\ub41c \ud56d\ubaa9 \uc81c\uac70\uc640 UNIQUE \ud568\uc218 \uc911 \ubb34\uc5c7\uc744 \uc368\uc57c \ud558\ub098\uc694?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/tips-for-office.com\/?p=439\/#%EC%88%AB%EC%9E%90%EC%9D%B8%EB%8D%B0_%EC%A4%91%EB%B3%B5%EC%9C%BC%EB%A1%9C_%EC%9D%B8%EC%8B%9D%EB%90%98%EC%A7%80_%EC%95%8A%EC%95%84%EC%9A%94\" >\uc22b\uc790\uc778\ub370 \uc911\ubcf5\uc73c\ub85c \uc778\uc2dd\ub418\uc9c0 \uc54a\uc544\uc694.<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/tips-for-office.com\/?p=439\/#%EC%A7%80%EC%9A%B0%EA%B8%B0_%EC%A0%84%EC%97%90_%EC%A4%91%EB%B3%B5%EC%9D%84_%EB%A8%BC%EC%A0%80_%ED%99%95%EC%9D%B8%ED%95%98%EA%B3%A0_%EC%8B%B6%EC%96%B4%EC%9A%94\" >\uc9c0\uc6b0\uae30 \uc804\uc5d0 \uc911\ubcf5\uc744 \uba3c\uc800 \ud655\uc778\ud558\uace0 \uc2f6\uc5b4\uc694.<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/tips-for-office.com\/?p=439\/#%EC%97%91%EC%85%80_%EC%A4%91%EB%B3%B5%EA%B0%92_%EC%A0%9C%EA%B1%B0_%EC%9D%B4%EB%A0%87%EA%B2%8C_%ED%99%9C%EC%9A%A9%ED%95%98%EC%84%B8%EC%9A%94\" >\uc5d1\uc140 \uc911\ubcf5\uac12 \uc81c\uac70, \uc774\ub807\uac8c \ud65c\uc6a9\ud558\uc138\uc694<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%EC%97%91%EC%85%80_%EC%A4%91%EB%B3%B5%EA%B0%92_%EC%A0%9C%EA%B1%B0%EA%B0%80_%ED%95%84%EC%9A%94%ED%95%9C_%EC%9D%B4%EC%9C%A0\"><\/span>\uc5d1\uc140 \uc911\ubcf5\uac12 \uc81c\uac70\uac00 \ud544\uc694\ud55c \uc774\uc720<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<!DOCTYPE html>\n<html lang=\"ko\">\n<head>\n<meta charset=\"UTF-8\">\n<meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\">\n<title>\uc5d1\uc140 \uc911\ubcf5\uac12 \uc81c\uac70 \ubc29\ubc95 \ube44\uad50<\/title>\n<style>\n  :root{\n    --navy:#12233b; --blue:#2f6df6; --sky:#eaf1ff; --line:#dbe4f3;\n    --ink:#1c2a3f; --muted:#5d6b82; --white:#fff; --green:#1a8a4f; --amber:#c47f17;\n  }\n  *{box-sizing:border-box;margin:0;padding:0}\n  body{\n    font-family:\"Pretendard\",\"Malgun Gothic\",-apple-system,sans-serif;\n    background:#f4f7fc; color:var(--ink); padding:24px; line-height:1.6;\n  }\n  .card{\n    max-width:760px; margin:0 auto; background:var(--white);\n    border-radius:18px; overflow:hidden; border:1px solid var(--line);\n    box-shadow:0 10px 34px rgba(18,35,59,.12);\n  }\n  .head{background:linear-gradient(120deg,#2a2f6b,#2f6df6); color:#fff; padding:26px 28px}\n  .head .tag{\n    display:inline-block; font-size:12px; letter-spacing:.12em;\n    background:rgba(255,255,255,.2); padding:5px 12px; border-radius:999px;\n    margin-bottom:12px; font-weight:600;\n  }\n  .head h2{font-size:22px; font-weight:800; line-height:1.35}\n  .head p{font-size:13.5px; opacity:.9; margin-top:8px}\n  .tablewrap{padding:20px 22px 8px; overflow-x:auto}\n  table{width:100%; border-collapse:collapse; font-size:13.5px}\n  thead th{\n    background:var(--sky); color:var(--navy); font-weight:700;\n    padding:12px 10px; text-align:left; border-bottom:2px solid var(--blue); font-size:12.5px;\n  }\n  tbody td{padding:13px 10px; border-bottom:1px solid var(--line); vertical-align:top}\n  tbody tr:last-child td{border-bottom:none}\n  .m-name{font-weight:800; color:var(--navy)}\n  .keep-y{color:var(--green); font-weight:700}\n  .keep-n{color:var(--amber); font-weight:700}\n  .foot{\n    padding:14px 22px 22px; font-size:12px; color:var(--muted);\n    border-top:1px dashed var(--line); margin-top:6px;\n  }\n<\/style>\n<\/head>\n<body>\n  <div class=\"card\">\n    <div class=\"head\">\n      <span class=\"tag\">REMOVE DUPLICATES<\/span>\n      <h2><span class=\"ez-toc-section\" id=\"%EC%97%91%EC%85%80_%EC%A4%91%EB%B3%B5%EA%B0%92_%EC%A0%9C%EA%B1%B0_3%EA%B0%80%EC%A7%80_%EB%B0%A9%EB%B2%95\"><\/span>\uc5d1\uc140 \uc911\ubcf5\uac12 \uc81c\uac70 3\uac00\uc9c0 \ubc29\ubc95<span class=\"ez-toc-section-end\"><\/span><\/h2>\n      <p>\uc9c0\uc6b0\ub294 \ubc29\uc2dd\u00b7\ud655\uc778\ud558\ub294 \ubc29\uc2dd\u00b7\ubcf4\uc874\ud558\ub294 \ubc29\uc2dd\uc73c\ub85c \ub098\ub269\ub2c8\ub2e4.<\/p>\n    <\/div>\n    <div class=\"tablewrap\">\n      <table>\n        <thead>\n          <tr>\n            <th>\ubc29\ubc95<\/th>\n            <th>\uc6d0\ubcf8 \ubcf4\uc874<\/th>\n            <th>\ubc84\uc804 \uc870\uac74<\/th>\n            <th>\uc774\ub7f4 \ub54c \uc801\ud569<\/th>\n          <\/tr>\n        <\/thead>\n        <tbody>\n          <tr>\n            <td class=\"m-name\">\uc911\ubcf5\ub41c \ud56d\ubaa9 \uc81c\uac70<\/td>\n            <td class=\"keep-n\">\uc0ad\uc81c\ub428<\/td>\n            <td>\ubaa8\ub4e0 \ubc84\uc804<\/td>\n            <td>\ubc14\ub85c \uc9c0\uc6cc\ub3c4 \ub420 \ub54c<\/td>\n          <\/tr>\n          <tr>\n            <td class=\"m-name\">\uc870\uac74\ubd80 \uc11c\uc2dd<\/td>\n            <td class=\"keep-y\">\ubcf4\uc874<\/td>\n            <td>\ubaa8\ub4e0 \ubc84\uc804<\/td>\n            <td>\uc9c0\uc6b0\uae30 \uc804 \ud655\uc778\ud560 \ub54c<\/td>\n          <\/tr>\n          <tr>\n            <td class=\"m-name\">UNIQUE \ud568\uc218<\/td>\n            <td class=\"keep-y\">\ubcf4\uc874<\/td>\n            <td>2021\u00b7365 \uc774\uc0c1<\/td>\n            <td>\uace0\uc720\ubaa9\ub85d \uc790\ub3d9 \uac31\uc2e0<\/td>\n          <\/tr>\n        <\/tbody>\n      <\/table>\n    <\/div>\n    <div class=\"foot\">\n      \u203b 1\uacfc 1.00\ucc98\ub7fc \uc11c\uc2dd\uc774 \ub2e4\ub978 \uc22b\uc790\ub294 \ub2e4\ub978 \uac12\uc73c\ub85c \uc778\uc2dd\ub429\ub2c8\ub2e4. \uc791\uc5c5 \uc804 \uc140 \uc11c\uc2dd\uc744 \ud1b5\uc77c\ud558\uc138\uc694. \ucc38\uace0\uc6a9 \uac1c\uc694\uc785\ub2c8\ub2e4.\n    <\/div>\n  <\/div>\n<\/body>\n<\/html>\n\n\n\n<p class=\"wp-block-paragraph\">\uc5d1\uc140 \uc911\ubcf5\uac12 \uc81c\uac70\ub294 \uba85\ub2e8, \uc8fc\ubb38 \ub0b4\uc5ed, \uac70\ub798\ucc98 \ubaa9\ub85d\ucc98\ub7fc \ub370\uc774\ud130\uac00 \ub9ce\uc744\uc218\ub85d \uaf2d \ud544\uc694\ud55c \uc791\uc5c5\uc785\ub2c8\ub2e4. \uc911\ubcf5\uc774 \uc11e\uc5ec \uc788\uc73c\uba74 \uc9d1\uacc4\uac00 \ud2c0\uc5b4\uc9c0\uace0 \ubd84\uc11d \uacb0\uacfc\uac00 \uc65c\uace1\ub418\uae30 \ub54c\ubb38\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ubc29\ubc95\uc740 \ud06c\uac8c \uc138 \uac00\uc9c0\ub85c \ub098\ub269\ub2c8\ub2e4. \uc911\ubcf5\uc744 \ubc14\ub85c \uc9c0\uc6b0\ub294 \ubc29\uc2dd, \uc9c0\uc6b0\uae30 \uc804\uc5d0 \ub208\uc73c\ub85c \ud655\uc778\ud558\ub294 \ubc29\uc2dd, \uc6d0\ubcf8\uc744 \ubcf4\uc874\ud558\uba70 \uace0\uc720\uac12\ub9cc \ubf51\ub294 \ubc29\uc2dd\uc785\ub2c8\ub2e4. \uc0c1\ud669\uc5d0 \ub530\ub77c \uc5b4\uc6b8\ub9ac\ub294 \ubc29\ubc95\uc774 \ub2e4\ub974\ubbc0\ub85c \uac01\uac01\uc758 \ud2b9\uc9d5\uc744 \uc54c\uc544\ub450\uba74 \uc88b\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%EC%A4%91%EB%B3%B5%EB%90%9C_%ED%95%AD%EB%AA%A9_%EC%A0%9C%EA%B1%B0_%EA%B8%B0%EB%8A%A5%EC%9C%BC%EB%A1%9C_%EB%B0%94%EB%A1%9C_%EC%A7%80%EC%9A%B0%EA%B8%B0\"><\/span>\uc911\ubcf5\ub41c \ud56d\ubaa9 \uc81c\uac70 \uae30\ub2a5\uc73c\ub85c \ubc14\ub85c \uc9c0\uc6b0\uae30<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe title=\"Excel \uc911\ubcf5 \uac12 \uc81c\uac70\ud558\ub294 \ubc29\ubc95 \ucd1d\uc815\ub9ac | \uc5d1\uc140\ub7ec \uad8c\ud604\uc6b1\" width=\"1200\" height=\"675\" src=\"https:\/\/www.youtube.com\/embed\/sYjub0otxuM?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\ucd9c\ucc98: <a href=\"https:\/\/www.youtube.com\/watch?v=sYjub0otxuM\" target=\"_blank\" rel=\"noopener\">\uc5d1\uc140\ub7ec \uad8c\ud604\uc6b1<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uac00\uc7a5 \ube60\ub978 \ubc29\ubc95\uc740 \uc5d1\uc140\uc5d0 \ub0b4\uc7a5\ub41c \uc911\ubcf5\ub41c \ud56d\ubaa9 \uc81c\uac70 \uae30\ub2a5\uc785\ub2c8\ub2e4. \uc774 \uae30\ub2a5\uc740 \uc911\ubcf5 \ub370\uc774\ud130\ub97c \ud55c \ubc88\uc5d0 \uc601\uad6c \uc0ad\uc81c\ud558\ubbc0\ub85c, \uc791\uc5c5 \uc804\uc5d0 \uc6d0\ubcf8 \ub370\uc774\ud130\ub97c \ub2e4\ub978 \uc2dc\ud2b8\ub85c \ubcf5\uc0ac\ud574 \ub450\ub294 \uac83\uc774 \uc548\uc804\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uba3c\uc800 \uc911\ubcf5\uc744 \uc5c6\uc568 \uc140 \ubc94\uc704\ub97c \uc120\ud0dd\ud55c \ub4a4 \ub370\uc774\ud130 \ud0ed\uc5d0\uc11c \uc911\ubcf5 \uc81c\uac70\ub97c \ud074\ub9ad\ud569\ub2c8\ub2e4. \uc774\uc5b4\uc11c \ub098\ud0c0\ub098\ub294 \ucc3d\uc5d0\uc11c \uc911\ubcf5 \ud310\ub2e8 \uae30\uc900\uc774 \ub420 \uc5f4\uc744 \uc9c0\uc815\ud558\uace0 \ud655\uc778\uc744 \ub204\ub974\uba74, \uba87 \uac1c\uac00 \uc0ad\uc81c\ub418\uace0 \uba87 \uac1c\uc758 \uace0\uc720\uac12\uc774 \ub0a8\uc558\ub294\uc9c0 \uacb0\uacfc\uac00 \ud45c\uc2dc\ub429\ub2c8\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%EC%97%AC%EB%9F%AC_%EC%97%B4%EC%9D%84_%EA%B8%B0%EC%A4%80%EC%9C%BC%EB%A1%9C_%EC%82%AD%EC%A0%9C%ED%95%A0_%EB%95%8C\"><\/span>\uc5ec\ub7ec \uc5f4\uc744 \uae30\uc900\uc73c\ub85c \uc0ad\uc81c\ud560 \ub54c<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\uc5f4\uc744 \ud558\ub098\ub9cc \uc120\ud0dd\ud558\uba74 \uadf8 \uc5f4\uc758 \uac12\uc774 \uac19\uc740 \ud589\uc774 \uc911\ubcf5\uc73c\ub85c \ucc98\ub9ac\ub429\ub2c8\ub2e4. \ubc18\uba74 \uc5ec\ub7ec \uc5f4\uc744 \ud568\uaed8 \uc120\ud0dd\ud558\uba74 \uc120\ud0dd\ud55c \ubaa8\ub4e0 \uc5f4\uc758 \uac12\uc774 \uc804\ubd80 \uc77c\uce58\ud574\uc57c \uc911\ubcf5\uc73c\ub85c \uc778\uc2dd\ub429\ub2c8\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc608\ub97c \ub4e4\uc5b4 &#8216;\uc774\ub984&#8217;\uacfc &#8216;\uc804\ud654\ubc88\ud638&#8217;\ub97c \ud568\uaed8 \uae30\uc900\uc73c\ub85c \uc7a1\uc73c\uba74 \ub450 \uac12\uc774 \ubaa8\ub450 \uac19\uc740 \ud589\ub9cc \uc0ad\uc81c\ub429\ub2c8\ub2e4. \ub3d9\uba85\uc774\uc778\uc774 \uc11e\uc778 \uba85\ub2e8\uc744 \ub2e4\ub8f0 \ub54c \uc774\ub984\ub9cc\uc73c\ub85c \uc9c0\uc6b0\uba74 \uc2e4\uc81c\ub85c \ub2e4\ub978 \uc0ac\ub78c\uc774 \uc0ad\uc81c\ub420 \uc218 \uc788\uc73c\ubbc0\ub85c, \uc774\ub7f0 \uacbd\uc6b0 \uc5ec\ub7ec \uc5f4\uc744 \ud568\uaed8 \uae30\uc900\uc73c\ub85c \uc0bc\ub294 \uac83\uc774 \uc548\uc804\ud569\ub2c8\ub2e4. \ucc38\uace0\ub85c \ubd80\ubd84\ud569\uc774\ub098 \uc724\uacfd\uc120\uc774 \uc124\uc815\ub3fc \uc788\uc73c\uba74 \uc911\ubcf5 \uc81c\uac70\uac00 \uc791\ub3d9\ud558\uc9c0 \uc54a\uc73c\ub2c8 \uba3c\uc800 \ud574\uc81c\ud574\uc57c \ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%EC%A1%B0%EA%B1%B4%EB%B6%80_%EC%84%9C%EC%8B%9D%EC%9C%BC%EB%A1%9C_%EC%A4%91%EB%B3%B5%EA%B0%92_%EC%B0%BE%EA%B8%B0\"><\/span>\uc870\uac74\ubd80 \uc11c\uc2dd\uc73c\ub85c \uc911\ubcf5\uac12 \ucc3e\uae30<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe title=\"\uc5d1\uc140 \uc5ec\ub7ec \uc5f4 \uc911\ubcf5\uac12 \uc81c\uac70, 10\ucd08\ub9cc\uc5d0 \ud558\ub294 \ubc95\" width=\"1200\" height=\"675\" src=\"https:\/\/www.youtube.com\/embed\/hzG-wN9mFX0?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\ucd9c\ucc98: <a href=\"https:\/\/www.youtube.com\/watch?v=hzG-wN9mFX0\" target=\"_blank\" rel=\"noopener\">\uc624\ube60\ub450\uc5d1\uc140<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc9c0\uc6b0\uae30 \uc804\uc5d0 \uc5b4\ub5a4 \uac12\uc774 \uc911\ubcf5\uc778\uc9c0 \ub208\uc73c\ub85c \uba3c\uc800 \ud655\uc778\ud558\uace0 \uc2f6\ub2e4\uba74 \uc870\uac74\ubd80 \uc11c\uc2dd\uc744 \uc4f0\uba74 \ub429\ub2c8\ub2e4. \uc774 \ubc29\ubc95\uc740 \uc6d0\ubcf8 \ub370\uc774\ud130\ub97c \uc190\uc0c1\uc2dc\ud0a4\uc9c0 \uc54a\uace0 \uc911\ubcf5\ub41c \uc140\uc5d0 \uc0c9\uc0c1\ub9cc \uc785\ud600 \uac15\uc870\ud574 \uc90d\ub2c8\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uba3c\uc800 \ud655\uc778\ud560 \ubc94\uc704\ub97c \uc120\ud0dd\ud55c \ub4a4 \ud648 \ud0ed\uc5d0\uc11c \uc870\uac74\ubd80 \uc11c\uc2dd &gt; \uc140 \uac15\uc870 \uaddc\uce59 &gt; \uc911\ubcf5 \uac12\uc744 \ucc28\ub840\ub85c \uc120\ud0dd\ud569\ub2c8\ub2e4. \uadf8\ub2e4\uc74c \uc801\uc6a9\ud560 \uc11c\uc2dd(\uc608: \uc9c4\ud55c \ube68\uac15 \ud14d\uc2a4\ud2b8)\uc744 \uace0\ub974\uace0 \ud655\uc778\uc744 \ub204\ub974\uba74 \uc911\ubcf5 \uac12\uc774 \ud55c\ub208\uc5d0 \ud45c\uc2dc\ub429\ub2c8\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"COUNTIF_%ED%95%A8%EC%88%98%EB%A1%9C_%EC%A4%91%EB%B3%B5_%ED%99%95%EC%9D%B8%ED%95%98%EA%B8%B0\"><\/span>COUNTIF \ud568\uc218\ub85c \uc911\ubcf5 \ud655\uc778\ud558\uae30<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\uc0c9\uc0c1 \uac15\uc870 \uc678\uc5d0 \ud568\uc218\ub85c \uc911\ubcf5 \uc5ec\ubd80\ub97c \ud310\ubcc4\ud560 \uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4. COUNTIF \ud568\uc218\ub294 \ud2b9\uc815 \uac12\uc774 \ubc94\uc704 \uc548\uc5d0 \uba87 \ubc88 \ub098\ud0c0\ub098\ub294\uc9c0 \uc138\uc5b4 \uc8fc\ub294\ub370, \uc774 \uac12\uc774 1\ubcf4\ub2e4 \ud06c\uba74 \uc911\ubcf5\uc774\ub77c\ub294 \ub73b\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc608\ub97c \ub4e4\uc5b4 \uc606 \uc140\uc5d0 \uac01 \uac12\uc758 \uac1c\uc218\ub97c \uc138\ub294 \uc218\uc2dd\uc744 \ub123\uc73c\uba74 \uc5b4\ub5a4 \ud56d\ubaa9\uc774 \uba87 \ubc88 \uc911\ubcf5\ub410\ub294\uc9c0\uae4c\uc9c0 \ud30c\uc545\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. COUNTIF \ubc29\uc2dd\uc740 \uc5d1\uc140 \ubc84\uc804\uacfc \uad00\uacc4\uc5c6\uc774 \ubaa8\ub4e0 \ubc84\uc804\uc5d0\uc11c \uc791\ub3d9\ud558\ubbc0\ub85c, \uc870\uac74\ubd80 \uc11c\uc2dd\uacfc \ud568\uaed8 \uc4f0\uba74 \uc911\ubcf5\uac12 \ucc3e\uae30\uac00 \ud55c\uacb0 \uc815\ud655\ud574\uc9d1\ub2c8\ub2e4.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%EC%A4%91%EB%B3%B5_%EC%A0%9C%EA%B1%B0_%ED%95%A8%EC%88%98_UNIQUE_%ED%99%9C%EC%9A%A9%ED%95%98%EA%B8%B0\"><\/span>\uc911\ubcf5 \uc81c\uac70 \ud568\uc218 UNIQUE \ud65c\uc6a9\ud558\uae30<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<!DOCTYPE html>\n<html lang=\"ko\">\n<head>\n<meta charset=\"UTF-8\">\n<meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\">\n<title>\uc911\ubcf5 \uc81c\uac70 \ud568\uc218 \uc815\ub9ac<\/title>\n<style>\n  :root{\n    --navy:#12233b; --blue:#2f6df6; --sky:#eaf1ff; --line:#dbe4f3;\n    --ink:#1c2a3f; --muted:#5d6b82; --white:#fff; --code:#0b3a82;\n  }\n  *{box-sizing:border-box;margin:0;padding:0}\n  body{\n    font-family:\"Pretendard\",\"Malgun Gothic\",-apple-system,sans-serif;\n    background:#f4f7fc; color:var(--ink); padding:24px; line-height:1.6;\n  }\n  .card{\n    max-width:720px; margin:0 auto; background:var(--white);\n    border-radius:18px; overflow:hidden; border:1px solid var(--line);\n    box-shadow:0 10px 34px rgba(18,35,59,.12);\n  }\n  .head{background:linear-gradient(120deg,#2a2f6b,#2f6df6); color:#fff; padding:26px 28px}\n  .head .tag{\n    display:inline-block; font-size:12px; letter-spacing:.12em;\n    background:rgba(255,255,255,.2); padding:5px 12px; border-radius:999px;\n    margin-bottom:12px; font-weight:600;\n  }\n  .head h2{font-size:22px; font-weight:800; line-height:1.35}\n  .body{padding:20px 24px 22px}\n  .item{padding:16px 0; border-bottom:1px solid var(--line)}\n  .item:last-child{border-bottom:none; padding-bottom:4px}\n  .fx{font-size:15px; font-weight:800; color:var(--navy); margin-bottom:8px}\n  .code{\n    display:block; background:#0e1b2e; color:#7fd0ff;\n    font-family:\"Consolas\",\"Menlo\",monospace; font-size:13.5px;\n    padding:11px 14px; border-radius:9px; margin-bottom:8px; overflow-x:auto;\n  }\n  .desc{font-size:13.5px; color:var(--muted)}\n  .ver{\n    display:inline-block; font-size:11px; font-weight:700; color:var(--blue);\n    background:var(--sky); padding:3px 9px; border-radius:999px; margin-left:6px;\n    vertical-align:middle;\n  }\n<\/style>\n<\/head>\n<body>\n  <div class=\"card\">\n    <div class=\"head\">\n      <span class=\"tag\">FUNCTIONS<\/span>\n      <h2><span class=\"ez-toc-section\" id=\"%EC%A4%91%EB%B3%B5_%EC%A0%9C%EA%B1%B0%C2%B7%ED%99%95%EC%9D%B8_%ED%95%A8%EC%88%98_%EB%AA%A8%EC%9D%8C\"><\/span>\uc911\ubcf5 \uc81c\uac70\u00b7\ud655\uc778 \ud568\uc218 \ubaa8\uc74c<span class=\"ez-toc-section-end\"><\/span><\/h2>\n    <\/div>\n    <div class=\"body\">\n      <div class=\"item\">\n        <div class=\"fx\">UNIQUE <span class=\"ver\">2021\u00b7365<\/span><\/div>\n        <code class=\"code\">=UNIQUE(A2:A100)<\/code>\n        <p class=\"desc\">\ubc94\uc704\uc5d0\uc11c \uc911\ubcf5\uc744 \ube80 \uace0\uc720\uac12\ub9cc \ubc18\ud658\ud569\ub2c8\ub2e4. \ub370\uc774\ud130\uac00 \ubc14\ub00c\uba74 \uacb0\uacfc\ub3c4 \uc790\ub3d9\uc73c\ub85c \uac31\uc2e0\ub429\ub2c8\ub2e4.<\/p>\n      <\/div>\n      <div class=\"item\">\n        <div class=\"fx\">UNIQUE + SORT <span class=\"ver\">2021\u00b7365<\/span><\/div>\n        <code class=\"code\">=SORT(UNIQUE(A2:A100))<\/code>\n        <p class=\"desc\">\uc911\ubcf5 \uc81c\uac70\uc640 \uc624\ub984\ucc28\uc21c \uc815\ub82c\uc744 \ud55c \ubc88\uc5d0 \ucc98\ub9ac\ud569\ub2c8\ub2e4.<\/p>\n      <\/div>\n      <div class=\"item\">\n        <div class=\"fx\">TOCOL + UNIQUE <span class=\"ver\">365<\/span><\/div>\n        <code class=\"code\">=UNIQUE(TOCOL(A2:C100))<\/code>\n        <p class=\"desc\">\uc5ec\ub7ec \uc5f4\uc744 \ud558\ub098\uc758 \uc5f4\ub85c \ud569\uce5c \ub4a4 \uc911\ubcf5\uc744 \uc81c\uac70\ud569\ub2c8\ub2e4.<\/p>\n      <\/div>\n      <div class=\"item\">\n        <div class=\"fx\">COUNTIF <span class=\"ver\">\ubaa8\ub4e0 \ubc84\uc804<\/span><\/div>\n        <code class=\"code\">=COUNTIF($A$2:$A$100, A2)<\/code>\n        <p class=\"desc\">\uac12\uc774 \ub098\ud0c0\ub09c \ud69f\uc218\ub97c \uc149\ub2c8\ub2e4. \uacb0\uacfc\uac00 1\ubcf4\ub2e4 \ud06c\uba74 \uc911\ubcf5\uc774\ub77c\ub294 \ub73b\uc785\ub2c8\ub2e4.<\/p>\n      <\/div>\n    <\/div>\n  <\/div>\n<\/body>\n<\/html>\n\n\n\n<p class=\"wp-block-paragraph\">\uc6d0\ubcf8\uc740 \uadf8\ub300\ub85c \ub450\uace0 \ubcc4\ub3c4 \uc601\uc5ed\uc5d0 \uace0\uc720\uac12\ub9cc \ubf51\uace0 \uc2f6\ub2e4\uba74 \uc911\ubcf5 \uc81c\uac70 \ud568\uc218\uc778 UNIQUE\ub97c \uc0ac\uc6a9\ud569\ub2c8\ub2e4. \uc774 \ud568\uc218\ub294 \ubc94\uc704\uc5d0\uc11c \uc911\ubcf5\uc744 \uc81c\uac70\ud55c \uacb0\uacfc\ub97c \ub3d9\uc801 \ubc30\uc5f4\ub85c \ub3cc\ub824\uc8fc\uba70, \ub370\uc774\ud130\uac00 \ubc14\ub00c\uba74 \uacb0\uacfc\ub3c4 \uc790\ub3d9\uc73c\ub85c \uac31\uc2e0\ub429\ub2c8\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc0ac\uc6a9\ubc95\uc740 \uac04\ub2e8\ud569\ub2c8\ub2e4. \ube48 \uc140\uc5d0 =UNIQUE(A2:A100) \ud615\ud0dc\ub85c \uc785\ub825\ud558\uba74 \ud574\ub2f9 \ubc94\uc704\uc5d0\uc11c \uc911\ubcf5\uc744 \ube80 \uace0\uc720 \ubaa9\ub85d\uc774 \ub098\ud0c0\ub0a9\ub2c8\ub2e4. \ub2e8, UNIQUE \ud568\uc218\ub294 \uc5d1\uc140 2021\uacfc Microsoft 365 \uc774\uc0c1 \ubc84\uc804\uc5d0\uc11c\ub9cc \uc0ac\uc6a9\ud560 \uc218 \uc788\ub2e4\ub294 \uc810\uc744 \uae30\uc5b5\ud574\uc57c \ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"SORT_%ED%95%A8%EC%88%98%EB%A1%9C_%EC%A0%95%EB%A0%AC%EA%B9%8C%EC%A7%80_%ED%95%9C_%EB%B2%88%EC%97%90\"><\/span>SORT \ud568\uc218\ub85c \uc815\ub82c\uae4c\uc9c0 \ud55c \ubc88\uc5d0<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">UNIQUE \ud568\uc218\uc758 \uacb0\uacfc\ub97c SORT \ud568\uc218\ub85c \uac10\uc2f8\uba74 \uc911\ubcf5 \uc81c\uac70\uc640 \uc815\ub82c\uc744 \ub3d9\uc2dc\uc5d0 \ucc98\ub9ac\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4 =SORT(UNIQUE(A2:A100)) \ud615\ud0dc\ub85c \uc785\ub825\ud558\uba74 \uace0\uc720\uac12\uc744 \uc624\ub984\ucc28\uc21c\uc73c\ub85c \uae54\ub054\ud558\uac8c \uc815\ub82c\ud574 \ubcf4\uc5ec\uc90d\ub2c8\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc5ec\ub7ec \uc5f4\uc5d0 \ud769\uc5b4\uc9c4 \ub370\uc774\ud130\uc5d0\uc11c \uc911\ubcf5\uc744 \uc81c\uac70\ud560 \ub54c\ub294 TOCOL \ud568\uc218\ub97c \ud568\uaed8 \uc501\ub2c8\ub2e4. TOCOL\ub85c \uc5ec\ub7ec \uc5f4\uc744 \ud558\ub098\uc758 \uc5f4\ub85c \ud569\uce5c \ub4a4 UNIQUE\ub97c \uc801\uc6a9\ud558\uba74 \ub418\uba70, TOCOL\uc740 Microsoft 365 \ubc84\uc804\uc5d0\uc11c \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774\ub807\uac8c \ud568\uc218\ub97c \uc870\ud569\ud558\uba74 \uc6d0\ubcf8\uc744 \uac74\ub4dc\ub9ac\uc9c0 \uc54a\uace0\ub3c4 \uc815\ub3c8\ub41c \uace0\uc720 \ubaa9\ub85d\uc744 \uc5bb\uc744 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%EC%9E%90%EC%A3%BC_%EB%AC%BB%EB%8A%94_%EC%A7%88%EB%AC%B8_FAQ\"><\/span>\uc790\uc8fc \ubb3b\ub294 \uc9c8\ubb38 (FAQ)<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\uc5d1\uc140 \uc911\ubcf5\uac12 \uc81c\uac70\uc640 \uad00\ub828\ud574 \ub9ce\uc774 \ub098\uc624\ub294 \uad81\uae08\uc99d\uc744 \uc815\ub9ac\ud588\uc2b5\ub2c8\ub2e4. \uc791\uc5c5 \uc804\uc5d0 \uc9da\uc5b4\ub450\uba74 \uc2e4\uc218\ub97c \uc904\uc77c \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%EC%A4%91%EB%B3%B5%EB%90%9C_%ED%95%AD%EB%AA%A9_%EC%A0%9C%EA%B1%B0%EC%99%80_UNIQUE_%ED%95%A8%EC%88%98_%EC%A4%91_%EB%AC%B4%EC%97%87%EC%9D%84_%EC%8D%A8%EC%95%BC_%ED%95%98%EB%82%98%EC%9A%94\"><\/span>\uc911\ubcf5\ub41c \ud56d\ubaa9 \uc81c\uac70\uc640 UNIQUE \ud568\uc218 \uc911 \ubb34\uc5c7\uc744 \uc368\uc57c \ud558\ub098\uc694?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\uc6d0\ubcf8\uc5d0\uc11c \uc911\ubcf5\uc744 \ubc14\ub85c \uc9c0\uc6cc\ub3c4 \ub418\uba74 \uc911\ubcf5\ub41c \ud56d\ubaa9 \uc81c\uac70 \uae30\ub2a5\uc774 \ube60\ub985\ub2c8\ub2e4. \ubc18\uba74 \uc6d0\ubcf8\uc744 \ubcf4\uc874\ud558\uba74\uc11c \uace0\uc720 \ubaa9\ub85d\uc744 \ub530\ub85c \ub9cc\ub4e4\uace0 \uc790\ub3d9 \uac31\uc2e0\uae4c\uc9c0 \uc6d0\ud55c\ub2e4\uba74 UNIQUE \ud568\uc218\uac00 \uc801\ud569\ud569\ub2c8\ub2e4. UNIQUE\ub294 \uc5d1\uc140 2021 \uc774\uc0c1\uc5d0\uc11c\ub9cc \uc9c0\uc6d0\ub429\ub2c8\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%EC%88%AB%EC%9E%90%EC%9D%B8%EB%8D%B0_%EC%A4%91%EB%B3%B5%EC%9C%BC%EB%A1%9C_%EC%9D%B8%EC%8B%9D%EB%90%98%EC%A7%80_%EC%95%8A%EC%95%84%EC%9A%94\"><\/span>\uc22b\uc790\uc778\ub370 \uc911\ubcf5\uc73c\ub85c \uc778\uc2dd\ub418\uc9c0 \uc54a\uc544\uc694.<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\uc11c\uc2dd\uc774 \ub2e4\ub978 \uc22b\uc790\ub294 \ub2e4\ub978 \uac12\uc73c\ub85c \ucc98\ub9ac\ub420 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4 1\uacfc 1.00\ucc98\ub7fc \ud45c\uc2dc \ud615\uc2dd\uc774 \ub2e4\ub974\uba74 \uc911\ubcf5\uc73c\ub85c \uc7a1\ud788\uc9c0 \uc54a\uc73c\ubbc0\ub85c, \uc791\uc5c5 \uc804\uc5d0 \uc140 \uc11c\uc2dd\uc744 \ud1b5\uc77c\ud574 \ub450\ub294 \uac83\uc774 \uc88b\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%EC%A7%80%EC%9A%B0%EA%B8%B0_%EC%A0%84%EC%97%90_%EC%A4%91%EB%B3%B5%EC%9D%84_%EB%A8%BC%EC%A0%80_%ED%99%95%EC%9D%B8%ED%95%98%EA%B3%A0_%EC%8B%B6%EC%96%B4%EC%9A%94\"><\/span>\uc9c0\uc6b0\uae30 \uc804\uc5d0 \uc911\ubcf5\uc744 \uba3c\uc800 \ud655\uc778\ud558\uace0 \uc2f6\uc5b4\uc694.<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\uc870\uac74\ubd80 \uc11c\uc2dd\uc758 \uc911\ubcf5 \uac12 \uac15\uc870 \uae30\ub2a5\uc744 \uc4f0\uba74 \uc6d0\ubcf8\uc744 \uc190\uc0c1\uc2dc\ud0a4\uc9c0 \uc54a\uace0 \uc911\ubcf5\ub41c \uc140\uc5d0 \uc0c9\uc0c1\ub9cc \uc785\ud600 \ud655\uc778\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uac1c\uc218\uae4c\uc9c0 \uc54c\uace0 \uc2f6\ub2e4\uba74 COUNTIF \ud568\uc218\ub97c \ud568\uaed8 \ud65c\uc6a9\ud558\uba74 \ub429\ub2c8\ub2e4.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%EC%97%91%EC%85%80_%EC%A4%91%EB%B3%B5%EA%B0%92_%EC%A0%9C%EA%B1%B0_%EC%9D%B4%EB%A0%87%EA%B2%8C_%ED%99%9C%EC%9A%A9%ED%95%98%EC%84%B8%EC%9A%94\"><\/span>\uc5d1\uc140 \uc911\ubcf5\uac12 \uc81c\uac70, \uc774\ub807\uac8c \ud65c\uc6a9\ud558\uc138\uc694<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\uc5d1\uc140 \uc911\ubcf5\uac12 \uc81c\uac70\ub294 \uc0c1\ud669\uc5d0 \ub9de\ub294 \ubc29\ubc95\uc744 \uace0\ub974\ub294 \uac83\uc774 \ud575\uc2ec\uc785\ub2c8\ub2e4. \ubc14\ub85c \uc9c0\uc6b8 \ub54c\ub294 \uc911\ubcf5\ub41c \ud56d\ubaa9 \uc81c\uac70, \ud655\uc778 \ud6c4 \uc9c0\uc6b8 \ub54c\ub294 \uc870\uac74\ubd80 \uc11c\uc2dd, \uc6d0\ubcf8\uc744 \ubcf4\uc874\ud560 \ub54c\ub294 UNIQUE \ud568\uc218\ub97c \uc4f0\uba74 \ub429\ub2c8\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc624\ub298 \uc815\ub9ac\ud55c \uc21c\uc11c\ub300\ub85c \ub0b4 \ub370\uc774\ud130\uc5d0 \ub9de\ub294 \ubc29\ubc95\uc744 \uace8\ub77c \uc801\uc6a9\ud574 \ubcf4\uc138\uc694. \uc5d1\uc140 \uc2e4\ubb34 \ub2a5\ub825\uc744 \ub354 \ud0a4\uc6b0\uace0 \uc2f6\ub2e4\uba74 <a href=\"https:\/\/tips-for-office.com\/?p=264\">\ub178\uc158 \uc0ac\uc6a9\ubc95<\/a>\uc774\ub098 <a href=\"https:\/\/tips-for-office.com\/?p=235\">\ud06c\ub86c \ud655\uc7a5\ud504\ub85c\uadf8\ub7a8 \ucd94\ucc9c<\/a> \uae00\uc744, \ubb38\uc11c \uc791\uc5c5 \ud658\uacbd\uc744 \uc815\ube44\ud558\ub824\uba74 <a href=\"https:\/\/tips-for-office.com\/?p=111\">\uc624\ud53c\uc2a4365 \ubb34\ub8cc \ub2e4\uc6b4\ub85c\ub4dc<\/a> \uae00\uc744 \ud568\uaed8 \ucc38\uace0\ud558\uba74 \ub3c4\uc6c0\uc774 \ub429\ub2c8\ub2e4.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\uc5ec\ub7ec \uacf3\uc5d0\uc11c \ubaa8\uc740 \uc790\ub8cc\ub97c \uc815\ub9ac\ud558\ub2e4 \ubcf4\uba74 \uac19\uc740 \uac12\uc774 \ub450\uc138 \ubc88\uc529 \ub4e4\uc5b4\uac00\uace4 \ud569\ub2c8\ub2e4. \uc774\ub7f4 \ub54c \ud544\uc694\ud55c \uc791\uc5c5\uc774 \uc5d1\uc140 \uc911\ubcf5\uac12 \uc81c\uac70\uc785\ub2c8\ub2e4. \uc774 \uae00\uc5d0\uc11c\ub294 \ub370\uc774\ud130 \ud0ed\uc758 \uc911\ubcf5\ub41c \ud56d\ubaa9 \uc81c\uac70 \uae30\ub2a5\ubd80\ud130 \uc870\uac74\ubd80 \uc11c\uc2dd\uc73c\ub85c \uc911\ubcf5\uac12 &#8230; <a title=\"\uc5d1\uc140 \uc911\ubcf5\uac12 \uc81c\uac70 \ucd1d\uc815\ub9ac \u2013 \uc911\ubcf5\uac12 \ucc3e\uae30\ubd80\ud130 UNIQUE \ud568\uc218\uae4c\uc9c0\" class=\"read-more\" href=\"https:\/\/tips-for-office.com\/?p=439\" aria-label=\"\uc5d1\uc140 \uc911\ubcf5\uac12 \uc81c\uac70 \ucd1d\uc815\ub9ac \u2013 \uc911\ubcf5\uac12 \ucc3e\uae30\ubd80\ud130 UNIQUE \ud568\uc218\uae4c\uc9c0\uc5d0 \ub300\ud574 \ub354 \uc790\uc138\ud788 \uc54c\uc544\ubcf4\uc138\uc694\">\ub354\ubcf4\uae30<\/a><\/p>\n","protected":false},"author":1,"featured_media":443,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6],"tags":[],"class_list":["post-439","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category--365-","generate-columns","tablet-grid-50","mobile-grid-100","grid-parent","grid-50"],"_links":{"self":[{"href":"https:\/\/tips-for-office.com\/index.php?rest_route=\/wp\/v2\/posts\/439","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tips-for-office.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tips-for-office.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tips-for-office.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/tips-for-office.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=439"}],"version-history":[{"count":2,"href":"https:\/\/tips-for-office.com\/index.php?rest_route=\/wp\/v2\/posts\/439\/revisions"}],"predecessor-version":[{"id":444,"href":"https:\/\/tips-for-office.com\/index.php?rest_route=\/wp\/v2\/posts\/439\/revisions\/444"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/tips-for-office.com\/index.php?rest_route=\/wp\/v2\/media\/443"}],"wp:attachment":[{"href":"https:\/\/tips-for-office.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=439"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tips-for-office.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=439"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tips-for-office.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=439"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}