{"id":4367,"date":"2024-12-04T21:58:37","date_gmt":"2024-12-04T21:58:37","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/04\/huong-dan-su-dung-ham-heounique-loc-khong-trung\/"},"modified":"2024-12-04T21:58:37","modified_gmt":"2024-12-04T21:58:37","slug":"huong-dan-su-dung-ham-heounique-loc-khong-trung","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/04\/huong-dan-su-dung-ham-heounique-loc-khong-trung\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m HeoUnique L\u1ecdc Kh\u00f4ng Tr\u00f9ng"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-dQf5b79p#1\">\n<p><em>Trong b\u00e0i vi\u1ebft n\u00e0y ch\u00fang ta s\u1ebd c\u00f9ng<strong>\u00a0<a href=\"https:\/\/hocexcel.online\/\">H\u1ecdc\u00a0Excel Online<\/a>\u00a0<\/strong>t\u00ecm hi\u1ec3u v\u1ec1 <strong>c\u00e1ch s\u1eed d\u1ee5ng\u00a0h\u00e0m HeoUnique\u00a0\u00a0trong Add ins HocExcel Online.<\/strong>\u00a0\u0110\u00e2y l\u00e0 m\u1ed9t h\u00e0m tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb duy nh\u1ea5t trong m\u1ed9t c\u1ed9t hay m\u1ed9t h\u00e0ng.<\/em><\/p>\n<p>\u0110\u1ec3 s\u1eed d\u1ee5ng \u0111\u01b0\u1ee3c h\u00e0m n\u00e0y c\u00e1c b\u1ea1n h\u00e3y t\u1ea3i add ins HocExcel Online v\u1ec1 h\u01b0\u1edbng d\u1eabn<a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cai-dat-add-ins-hocexcelonline.html\"> t\u1ea1i \u0111\u00e2y<\/a><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-6750d08cb4fc4\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-su-dung-ham-heounique-loc-khong-trung.html#Cach_dungCau_Truc\" title=\"C\u00e1ch dung\/C\u1ea5u Tr\u00fac\">C\u00e1ch dung\/C\u1ea5u Tr\u00fac<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-su-dung-ham-heounique-loc-khong-trung.html#Tham_so\" title=\"Tham s\u1ed1\">Tham s\u1ed1<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-su-dung-ham-heounique-loc-khong-trung.html#Gia_tri_tra_ve\" title=\"Gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1\">Gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-su-dung-ham-heounique-loc-khong-trung.html#Vi_Du\" title=\"V\u00ed D\u1ee5.\">V\u00ed D\u1ee5.<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-su-dung-ham-heounique-loc-khong-trung.html#Tham_Khao\" title=\"Tham Kh\u1ea3o\">Tham Kh\u1ea3o<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Cach_dungCau_Truc\"><\/span>C\u00e1ch dung\/C\u1ea5u Tr\u00fac<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<blockquote>\n<p><strong>HeoUnique(m\u1ea3ng v\u00e0o, t\u00f9y ch\u1ecdn)<\/strong><\/p>\n<p>H\u00e0m c\u00f3 hai tham s\u1ed1<\/p>\n<p>1.l\u00e0 c\u1ed9t v\u00e0o, ho\u1eb7c d\u00f2ng v\u00e0o<\/p>\n<p>2. T\u00f9y ch\u1ecdn<\/p>\n<\/blockquote>\n<h2><span class=\"ez-toc-section\" id=\"Tham_so\"><\/span>Tham s\u1ed1<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>1. M\u1ea3ng v\u00e0o l\u00e0 m\u1ed9t c\u1ed9t ho\u1eb7c m\u1ed9t h\u00e0ng trong excel<\/p>\n<p>2. Gi\u00e1 tr\u1ecb t\u00f9y ch\u1ecdn<\/p>\n<ul style=\"list-style-type: circle\">\n<li>\u00a0 \u00a0 \u00a0 \u00a0 ten =? \u0111\u1eb7t t\u00ean cho v\u00f9ng gi\u00e1 tr\u1ecb<\/li>\n<li>\u00a0 \u00a0 \u00a0 \u00a0 xoaname =? x\u00f3a t\u00ean \u0111\u00e3 \u0111\u1eb7t cho v\u00f9ng d\u1eef li\u1ec7u<\/li>\n<li>\u00a0 \u00a0 \u00a0 \u00a0chen =y ch\u00e8n gi\u00e1 tr\u1ecb v\u00e0o v\u00f9ng m\u00e0 kh\u00f4ng l\u00e0m thay \u0111\u1ed5i c\u1ea5u tr\u00fac file<\/li>\n<li>\u00a0 \u00a0 \u00a0 tudong =y t\u1ef1 \u0111\u1ed9ng ch\u1ec9nh c\u1ed9t v\u1eeba kh\u00edt v\u1edbi d\u1eef li\u1ec7u excel.<\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"Gia_tri_tra_ve\"><\/span>Gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>M\u1ea3ng gi\u00e1 tr\u1ecb duy nh\u1ea5t kh\u00f4ng tr\u00f9ng l\u1eb7p<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Vi_Du\"><\/span>V\u00ed D\u1ee5.<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-29577 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/l0ckhongtrung.gif\" alt=\"huong-dan-su-dung-ham-heounique-loc-khong-trung-1\" width=\"1910\" height=\"930\" title=\"l0ckhongtrung\"><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Tham_Khao\"><\/span>Tham Kh\u1ea3o<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>H\u00e0m tr\u1ea3 ra gi\u00e1 tr\u1ecb duy nh\u1ea5t trong m\u1ed9t v\u00f9ng d\u1eef li\u1ec7u.<\/p>\n<div class=\"code-block code-block-3\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<p>D\u00f9 \u0111\u00e3 c\u00f3 ph\u1ea7n m\u1ec1m, nh\u01b0ng k\u1ef9 n\u0103ng Excel v\u1eabn c\u1ef1c k\u1ef3 quan tr\u1ecdng v\u1edbi k\u1ebf to\u00e1n, b\u1ea1n \u0111\u00e3 v\u1eefng Excel ch\u01b0a? H\u00e3y \u0111\u1ec3 t\u00f4i gi\u00fap b\u1ea1n, \u0111\u0103ng k\u00fd kho\u00e1 h\u1ecdc Excel:<\/p>\n<p><a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-351.gif\" title=\"ex101_92019-nho-351\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<div class=\"code-block code-block-2\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-153.gif\" title=\"vba101_92019-nho-153\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-351.gif\" title=\"ex101_92019-nho-351\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>H\u00e3y gh\u00e9 th\u0103m <strong>Hoc Excel Online<\/strong> \u0111\u1ec3 c\u00f3 nh\u1eefng tr\u1ea3i nghi\u1ec7m th\u00fa v\u1ee5 v\u1ec1 Excel Nh\u00e9<\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<p>D\u00f9 \u0111\u00e3 c\u00f3 ph\u1ea7n m\u1ec1m, nh\u01b0ng k\u1ef9 n\u0103ng Excel v\u1eabn c\u1ef1c k\u1ef3 quan tr\u1ecdng v\u1edbi k\u1ebf to\u00e1n, b\u1ea1n \u0111\u00e3 v\u1eefng Excel ch\u01b0a? H\u00e3y \u0111\u1ec3 t\u00f4i gi\u00fap b\u1ea1n, \u0111\u0103ng k\u00fd kho\u00e1 h\u1ecdc Excel:<\/p>\n<p><a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-351.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":4368,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-4367","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-nang-cao"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/4367","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/comments?post=4367"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/4367\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/4368"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=4367"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=4367"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=4367"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}