{"id":9869,"date":"2025-01-03T19:49:18","date_gmt":"2025-01-03T19:49:18","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/03\/gioi-thieu-ve-ky-tu-dai-dien-trong-tim-kiem-wildcard-va-cach-ung-dung-hieu-qua\/"},"modified":"2025-01-03T19:49:18","modified_gmt":"2025-01-03T19:49:18","slug":"gioi-thieu-ve-ky-tu-dai-dien-trong-tim-kiem-wildcard-va-cach-ung-dung-hieu-qua","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/03\/gioi-thieu-ve-ky-tu-dai-dien-trong-tim-kiem-wildcard-va-cach-ung-dung-hieu-qua\/","title":{"rendered":"Gi\u1edbi thi\u1ec7u v\u1ec1 k\u00fd t\u1ef1 \u0111\u1ea1i di\u1ec7n trong t\u00ecm ki\u1ebfm (wildcard) v\u00e0 c\u00e1ch \u1ee9ng d\u1ee5ng hi\u1ec7u qu\u1ea3"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Trong b\u00e0i vi\u1ebft l\u1ea7n n\u00e0y, H\u1ecdc Excel Online s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n v\u1ec1 nh\u1eefng k\u00fd t\u1ef1 \u0111\u1ea1i di\u1ec7n \u201cquy\u1ec1n l\u1ef1c\u201d d\u00f9ng l\u00e0m ti\u00eau ch\u00ed khi t\u00ecm ki\u1ebfm v\u0103n b\u1ea3n (hay c\u00f2n \u0111\u01b0\u1ee3c g\u1ecdi l\u00e0 <strong>wildcard<\/strong>).<\/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-67783f3d83fa8\" 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-3\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/ky-tu-dai-dien-trong-tim-kiem-wildcard.html#Ky_tu_dai_dien_Wildcard_la_gi\" title=\"K\u00fd t\u1ef1 \u0111\u1ea1i di\u1ec7n (Wildcard) l\u00e0 g\u00ec?\">K\u00fd t\u1ef1 \u0111\u1ea1i di\u1ec7n (Wildcard) l\u00e0 g\u00ec?<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/ky-tu-dai-dien-trong-tim-kiem-wildcard.html#3_ki_tu_dai_dien_trong_Excel\" title=\"3 k\u00ed t\u1ef1 \u0111\u1ea1i di\u1ec7n trong Excel\">3 k\u00ed t\u1ef1 \u0111\u1ea1i di\u1ec7n trong Excel<\/a>\n<ul class=\"ez-toc-list-level-4\">\n<li class=\"ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/ky-tu-dai-dien-trong-tim-kiem-wildcard.html#Dau_sao\" title=\"D\u1ea5u sao\">D\u1ea5u sao<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/ky-tu-dai-dien-trong-tim-kiem-wildcard.html#Dau_hoi\" title=\"D\u1ea5u h\u1ecfi\">D\u1ea5u h\u1ecfi<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/ky-tu-dai-dien-trong-tim-kiem-wildcard.html#Dau_nga\" title=\"D\u1ea5u ng\u00e3\">D\u1ea5u ng\u00e3<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/ky-tu-dai-dien-trong-tim-kiem-wildcard.html#Su_dung_wildcard_de_tim_kiem_va_thay_the_Find_Replace\" title=\"S\u1eed d\u1ee5ng wildcard \u0111\u1ec3 t\u00ecm ki\u1ebfm v\u00e0 thay th\u1ebf (Find &amp; Replace)\">S\u1eed d\u1ee5ng wildcard \u0111\u1ec3 t\u00ecm ki\u1ebfm v\u00e0 thay th\u1ebf (Find &amp; Replace)<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/ky-tu-dai-dien-trong-tim-kiem-wildcard.html#Su_dung_wildcard_voi_ham_COUNTIF\" title=\"S\u1eed d\u1ee5ng wildcard v\u1edbi h\u00e0m COUNTIF\">S\u1eed d\u1ee5ng wildcard v\u1edbi h\u00e0m COUNTIF<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Ky_tu_dai_dien_Wildcard_la_gi\"><\/span>K\u00fd t\u1ef1 \u0111\u1ea1i di\u1ec7n (Wildcard) l\u00e0 g\u00ec?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><strong>Wildcard<\/strong> l\u00e0 nh\u1eefng k\u00ed t\u1ef1 \u0111\u1ea1i di\u1ec7n \u0111\u01b0\u1ee3c d\u00f9ng l\u00e0m ti\u00eau ch\u00ed khi t\u00ecm ki\u1ebfm v\u0103n b\u1ea3n, \u0111\u1ea1i di\u1ec7n cho m\u1ed9t ho\u1eb7c nhi\u1ec1u k\u00ed t\u1ef1 kh\u00e1c. Nh\u1eefng k\u00ed t\u1ef1 n\u00e0y v\u00f4 c\u00f9ng c\u00f3 \u00edch khi b\u1ea1n mu\u1ed1n t\u00ecm ki\u1ebfm theo c\u00e1ch <em>t\u01b0\u01a1ng \u0111\u1ed1i<\/em>, kh\u00f4ng ch\u00ednh x\u00e1c ho\u00e0n to\u00e0n.<\/p>\n<p>B\u1ea1n s\u1ebd ph\u1ea7n n\u00e0o th\u1ea5y \u0111\u01b0\u1ee3c\u00a0<strong>wildcard\u00a0<\/strong>c\u00f3 \u00edch ra sao khi h\u1ed7 tr\u1ee3 ng\u01b0\u1eddi d\u00f9ng gi\u1ea3i quy\u1ebft m\u1ed9t s\u1ed1 kh\u00f3 kh\u0103n li\u00ean quan t\u1edbi t\u00ecm ki\u1ebfm trong nh\u1eefng v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"3_ki_tu_dai_dien_trong_Excel\"><\/span>3 k\u00ed t\u1ef1 \u0111\u1ea1i di\u1ec7n trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Trong Excel, c\u00f3 3 k\u00ed t\u1ef1 \u0111\u1ea1i di\u1ec7n \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng bao g\u1ed3m:<\/p>\n<ul>\n<li>D\u1ea5u sao (*)<\/li>\n<li>D\u1ea5u h\u1ecfi (?)<\/li>\n<li>D\u1ea5u ng\u00e3 (~)<\/li>\n<\/ul>\n<p>D\u00f9 cho t\u00e1c d\u1ee5ng c\u00f3 ph\u1ea7n kh\u00e1c nhau th\u00ec trong m\u1ed9t chu\u1ed7i, c\u00e1c k\u00ed t\u1ef1 \u0111\u1ea1i di\u1ec7n n\u00e0y c\u00f3 th\u1ec3 \u0111\u1ea1i di\u1ec7n cho b\u1ea5t c\u1ee9 gi\u00e1 tr\u1ecb n\u00e0o trong chu\u1ed7i.<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Dau_sao\"><\/span>D\u1ea5u sao<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>Wildcard \u0111\u1ea7u ti\u00ean ta s\u1ebd t\u00ecm hi\u1ec3u l\u00e0 d\u1ea5u sao.\u00a0<strong>D\u1ea5u sao<\/strong> c\u00f3 th\u1ec3 thay th\u1ebf m\u1ed9t ho\u1eb7c m\u1ed9t nh\u00f3m c\u00e1c k\u00ed t\u1ef1 trong chu\u1ed7i kh\u00f4ng k\u1ec3 ch\u1eef hay s\u1ed1(\u1edf d\u1ea1ng Text).<\/p>\n<p>V\u00ed d\u1ee5, n\u1ebfu ta c\u00f3 m\u1ed9t c\u1ee5m \u201cNa*\u201d, n\u00f3 c\u00f3 th\u1ec3 \u0111\u1ea1i di\u1ec7n cho c\u00e1c chu\u1ed7i: \u201cNam\u201d, \u201cNammmmmm\u201d, \u201cNam01234\u201d, \u201cNam98man89\u2033\u2026<\/p>\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\/2025\/01\/ex101_92019-nho-104.gif\" title=\"ex101_92019-nho-104\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>Ta c\u00f3 th\u1ec3 \u0111\u1eb7t d\u1ea5u sao \u1edf \u0111\u1ea7u chu\u1ed7i, v\u00ed d\u1ee5 nh\u01b0 \u201c*98\u201d. N\u00f3 \u0111\u1ea1i di\u1ec7n cho t\u1ea5t c\u1ea3 c\u00e1c chu\u1ed7i k\u1ebft th\u00fac b\u1eb1ng \u201c98\u201d m\u00e0 kh\u00f4ng c\u1ea7n bi\u1ebft c\u00f3 bao nhi\u00eau ch\u1eef ho\u1eb7c s\u1ed1 tr\u01b0\u1edbc \u0111\u00f3.<\/p>\n<p>\u00a0<\/p>\n<p>B\u1ea1n \u0111\u00e3 b\u1eaft \u0111\u1ea7u m\u01b0\u1eddng t\u01b0\u1ee3ng \u0111\u01b0\u1ee3c t\u00e1c d\u1ee5ng c\u1ee7a k\u00ed t\u1ef1 \u0111\u1ea1i di\u1ec7n r\u1ed3i, ph\u1ea3i kh\u00f4ng n\u00e0o?<\/p>\n<p><em>H\u00e3y xem ch\u00ednh x\u00e1c c\u00e1ch m\u00e0 b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng d\u1ea5u sao:<\/em><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23004\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/wildcard-1-asterisk.png\" width=\"355\" height=\"451\" title=\"wildcard-1-asterisk\"><\/p>\n<p>Trong v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y, H\u1ecdc Excel Online c\u1ea7n l\u1ecdc ra nh\u1eefng ng\u01b0\u1eddi c\u00f3 h\u1ecd L\u00ea. \u0110\u1ec3 l\u00e0m \u0111i\u1ec1u n\u00e0y, ta s\u1ebd s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng Filter k\u1ebft h\u1ee3p wildcard. C\u1ee5 th\u1ec3:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23005\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/wildcard-1-asterisk-2.png\" width=\"380\" height=\"468\" title=\"wildcard-1-asterisk-2\"><\/p>\n<p>V\u00e0 k\u1ebft qu\u1ea3<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23006\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/wildcard-1-asterisk-3.png\" width=\"380\" height=\"221\" title=\"wildcard-1-asterisk-3\"><\/p>\n<p>Ngo\u00e0i ra, wildcard c\u00f2n ho\u1ea1t \u0111\u1ed9ng kh\u00f4ng ph\u00e2n bi\u1ec7t ch\u1eef hoa\/th\u01b0\u1eddng:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23007\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/wildcard-1-asterisk-4.png\" width=\"413\" height=\"464\" title=\"wildcard-1-asterisk-4\"><\/p>\n<h4><span class=\"ez-toc-section\" id=\"Dau_hoi\"><\/span>D\u1ea5u h\u1ecfi<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>M\u1ed7i <strong>D\u1ea5u h\u1ecfi (?)<\/strong> s\u1ebd thay th\u1ebf\u00a0<strong>m\u1ed9t<\/strong> k\u00ed t\u1ef1 trong chu\u1ed7i t\u00ecm ki\u1ebfm.<\/p>\n<p>D\u1ea5u h\u1ecfi \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng khi b\u1ea1n mu\u1ed1n t\u00ecm ki\u1ebfm m\u1ed9t c\u00e1ch c\u1ee5 th\u1ec3 h\u01a1n, nh\u01b0ng v\u1eabn kh\u00f4ng ph\u1ea3i l\u00e0 ch\u00ednh x\u00e1c ho\u00e0n to\u00e0n.<\/p>\n<p><em>Trong v\u00ed d\u1ee5 ph\u00eda d\u01b0\u1edbi n\u00e0y, ta s\u1ebd k\u1ebft h\u1ee3p v\u1edbi nh\u1eefng ki\u1ebfn th\u1ee9c \u0111\u00e3 bi\u1ebft v\u1ec1 d\u1ea5u sao \u1edf ph\u00eda tr\u00ean.<\/em><\/p>\n<p>Y\u00eau c\u1ea7u: L\u1ecdc t\u1ea5t c\u1ea3 nh\u1eefng ng\u01b0\u1eddi c\u00f3 t\u00ean \u0111\u1ec7m l\u00e0 \u201cTh\u1ecb\u201d ho\u1eb7c \u201cThu\u201d<\/p>\n<p>H\u01b0\u1edbng l\u00e0m:<br \/>\nS\u1eed d\u1ee5ng<strong> d\u1ea5u sao\u00a0<\/strong>k\u1ebft h\u1ee3p\u00a0<strong>d\u1ea5u c\u00e1ch<\/strong> \u0111\u1ec3 l\u1ecdc ra ph\u1ea7n t\u00ean \u0111\u1ec7m \u1edf gi\u1eefa.<\/p>\n<p>S\u1eed d\u1ee5ng\u00a0<strong>d\u1ea5u h\u1ecfi<\/strong> \u0111\u1ec3 \u0111\u1ea1i di\u1ec7n cho k\u00ed t\u1ef1 cu\u1ed1i sau \u201cTh\u201d.<\/p>\n<p>K\u1ebft qu\u1ea3:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23008\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/wildcard-2-question-mark-2.png\" width=\"380\" height=\"461\" title=\"wildcard-2-question-mark-2\"><\/p>\n<p><strong><em>V\u1eady trong tr\u01b0\u1eddng h\u1ee3p ta mu\u1ed1n t\u00ecm ki\u1ebfm wildcard trong chu\u1ed7i, v\u00ed d\u1ee5 nh\u01b0 h\u00ecnh d\u01b0\u1edbi, th\u00ec ph\u1ea3i l\u00e0m th\u1ebf n\u00e0o?<\/em><\/strong><\/p>\n<p>\u00a0<\/p>\n<figure id=\"attachment_23009\" aria-describedby=\"caption-attachment-23009\" style=\"width: 444px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-23009\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/wildcard-tilde-1.png\" width=\"444\" height=\"471\" title=\"wildcard-tilde-1\"><figcaption id=\"caption-attachment-23009\" class=\"wp-caption-text\">L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 hi\u1ec3n th\u1ecb nh\u1eefng t\u00ean c\u00f3 d\u1ea5u sao b\u00e2y gi\u1edd?<\/figcaption><\/figure>\n<h4><span class=\"ez-toc-section\" id=\"Dau_nga\"><\/span>D\u1ea5u ng\u00e3<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>Vi\u1ec7c \u0111\u1eb7t d\u1ea5u ng\u00e3 s\u1ebd gi\u00fap cho Excel nh\u1eadn d\u1ea1ng\u00a0<strong>d\u1ea5u sao\u00a0<\/strong>v\u00e0\u00a0<strong>d\u1ea5u h\u1ecfi<\/strong> l\u00e0 m\u1ed9t ph\u1ea7n trong chu\u1ed7i thay v\u00ec\u00a0<strong>wildcard\u00a0<\/strong>nh\u01b0 m\u1eb7c \u0111\u1ecbnh.<\/p>\n<figure id=\"attachment_23010\" aria-describedby=\"caption-attachment-23010\" style=\"width: 380px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-23010\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/wildcard-tilde-2.png\" width=\"380\" height=\"469\" title=\"wildcard-tilde-2\"><figcaption id=\"caption-attachment-23010\" class=\"wp-caption-text\">D\u1ea5u sao th\u1ee9 nh\u1ea5t l\u00e0 m\u1ed9t wildcard, trong khi d\u1ea5u sao th\u1ee9 hai l\u00e0 k\u00ed t\u1ef1 thu\u1ed9c chu\u1ed7i<\/figcaption><\/figure>\n<p>B\u00e2y gi\u1edd ta s\u1ebd c\u00f9ng t\u00ecm hi\u1ec3u th\u00eam m\u1ed9t s\u1ed1 c\u00e1ch s\u1eed d\u1ee5ng Wildcard kh\u00e1c nh\u00e9!<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Su_dung_wildcard_de_tim_kiem_va_thay_the_Find_Replace\"><\/span>S\u1eed d\u1ee5ng wildcard \u0111\u1ec3 t\u00ecm ki\u1ebfm v\u00e0 thay th\u1ebf (Find &amp; Replace)<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><em>T\u00ecm\u00a0to\u00e0n b\u1ed9 t\u00ean \u0111\u1ec7m b\u1eaft \u0111\u1ea7u v\u1edbi \u201cTh\u201d b\u1eb1ng \u201cThu\u201d<\/em><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23011\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/wildcard-ex-1.png\" width=\"379\" height=\"469\" title=\"wildcard-ex-1\"><\/p>\n<p>Ch\u00fang ta s\u1ebd th\u1ef1c hi\u1ec7n t\u01b0\u01a1ng t\u1ef1 v\u1edbi c\u00e1c v\u00ed d\u1ee5 tr\u00ean, c\u00f3 kh\u00e1c l\u00e0 thay v\u00ec l\u1ecdc (Filter) th\u00ec ta d\u00f9ng t\u00ecm ki\u1ebfm (Find).<\/p>\n<p>H\u01b0\u1edbng l\u00e0m:<\/p>\n<ul>\n<li>Khoanh v\u00f9ng mu\u1ed1n t\u00ecm ki\u1ebfm.<br \/>\nS\u1eed d\u1ee5ng ph\u00edm Ctrl+F \u0111\u1ec3 m\u1edf h\u1ed9p tho\u1ea1i t\u00ecm ki\u1ebfm.<\/li>\n<li>T\u1ea1i \u00f4 t\u00ecm ki\u1ebfm, g\u00f5\u00a0<strong>* TH* *<\/strong><\/li>\n<li>\u1ea4n Find.<\/li>\n<\/ul>\n<p>K\u1ebft qu\u1ea3 t\u00ecm ki\u1ebfm s\u1ebd \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb b\u00ean d\u01b0\u1edbi:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23012\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/wildcard-ex-2.png\" width=\"459\" height=\"301\" title=\"wildcard-ex-2\"><\/p>\n<p>\u0110\u1ec3 hi\u1ec3u h\u01a1n v\u1ec1<strong> Find &amp; Replace,\u00a0<\/strong>c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 t\u00ecm \u0111\u1ecdc t\u1ea1i <a href=\"http:\/\/blog.ezworkapp.com\/find-va-replace-nang-cao-trong-excel-cach-su-dung-hieu-qua-nhat.html\">\u0111\u00e2y.<\/a><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Su_dung_wildcard_voi_ham_COUNTIF\"><\/span>S\u1eed d\u1ee5ng wildcard v\u1edbi h\u00e0m COUNTIF<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Trong c\u00e1c h\u00e0m, wildcard c\u0169ng t\u1ecf ra l\u00e0 m\u1ed9t tr\u1ee3 th\u1ee7 \u0111\u1eafc l\u1ef1c. V\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y v\u1edbi COUNTIF \u0111\u00e3 ch\u1ee9ng t\u1ecf r\u1eb1ng wildcard r\u1ea5t g\u1ea7n g\u0169i v\u00e0 d\u1ec5 s\u1eed d\u1ee5ng.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23013\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/wildcard-ex-3.png\" width=\"956\" height=\"471\" title=\"wildcard-ex-3\"><\/p>\n<blockquote>\n<p><strong>Xem th\u00eam:<\/strong> <a href=\"http:\/\/blog.ezworkapp.com\/dem-co-dieu-kien-ham-countif-co-ban.html\">H\u00e0m COUNTIF \u0111\u1ebfm v\u1edbi \u0111i\u1ec1u ki\u1ec7n \u0111\u01a1n gi\u1ea3n d\u1ec5 h\u1ecdc nh\u1ea5t.<\/a><\/p>\n<\/blockquote>\n<p>Qua b\u00e0i h\u1ecdc n\u00e0y, c\u00e1c b\u1ea1n kh\u00f4ng ch\u1ec9 hi\u1ec3u v\u1ec1 wildcard, m\u00e0 c\u00f2n \u0111\u01b0\u1ee3c th\u1ea5y c\u00e1ch n\u00f3 \u1ee9ng d\u1ee5ng trong c\u00e1c thao t\u00e1c v\u1edbi trang t\u00ednh Excel. Tr\u00ean \u0111\u00e2y l\u00e0 nh\u1eefng v\u00ed d\u1ee5 c\u01a1 b\u1ea3n nh\u1ea5t, v\u00e0 n\u00f3 kh\u00f4ng qu\u00e1 kh\u00f3 ph\u1ea3i kh\u00f4ng n\u00e0o? \u0110\u1eebng qu\u00ean t\u00ecm hi\u1ec3u th\u00eam, luy\u1ec7n t\u1eadp th\u00e0nh th\u1ea1o \u0111\u1ec3 c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng nhu\u1ea7n nhuy\u1ec5n v\u00e0o th\u1ef1c t\u1ebf nh\u00e9!<\/p>\n<p>\u00a0<\/p>\n<p>\u00a0<\/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<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\/2025\/01\/ex101_92019-nho-104.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":9870,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-9869","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/9869","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=9869"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/9869\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/9870"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=9869"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=9869"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=9869"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}