{"id":4160,"date":"2025-11-10T17:13:25","date_gmt":"2025-11-10T10:13:25","guid":{"rendered":"https:\/\/autofillform.com\/blog\/cach-dung-ham-search-searchb-trong-excel-kem-vi-du-de-hieu\/"},"modified":"2025-11-10T17:13:25","modified_gmt":"2025-11-10T10:13:25","slug":"cach-dung-ham-search-searchb-trong-excel-kem-vi-du-de-hieu","status":"publish","type":"post","link":"https:\/\/autofillform.com\/blog\/cach-dung-ham-search-searchb-trong-excel-kem-vi-du-de-hieu\/","title":{"rendered":"C\u00e1ch d\u00f9ng h\u00e0m SEARCH, SEARCHB trong Excel k\u00e8m v\u00ed d\u1ee5 d\u1ec5 hi\u1ec3u"},"content":{"rendered":"<div class=\"content_article\" id=\"clicklinka\">\n<p>H\u00e0m SEARCH v\u00e0 SEARCHB trong Excel \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed c\u1ee7a m\u1ed9t chu\u1ed7i con trong v\u0103n b\u1ea3n, gi\u00fap ng\u01b0\u1eddi d\u00f9ng d\u1ec5 d\u00e0ng tr\u00edch xu\u1ea5t ho\u1eb7c x\u1eed l\u00fd d\u1eef li\u1ec7u. Hai h\u00e0m n\u00e0y \u0111\u1eb7c bi\u1ec7t h\u1eefu \u00edch khi l\u00e0m vi\u1ec7c v\u1edbi n\u1ed9i dung c\u00f3 k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t ho\u1eb7c nhi\u1ec1u ng\u00f4n ng\u1eef kh\u00e1c nhau, h\u1ed7 tr\u1ee3 ph\u00e2n t\u00edch chu\u1ed7i ch\u00ednh x\u00e1c h\u01a1n. C\u00f9ng t\u00ecm hi\u1ec3u c\u00e1ch d\u00f9ng h\u00e0m SEARCH v\u00e0 SEARCHB trong Excel qua h\u01b0\u1edbng d\u1eabn v\u00e0 v\u00ed d\u1ee5 c\u1ee5 th\u1ec3 d\u01b0\u1edbi \u0111\u00e2y.<\/p>\n<p><em><img decoding=\"async\" alt=\"C\u00f4ng th\u1ee9c h\u00e0m SEARCH trong Excel\" src=\"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/11\/cach-dung-ham-search-searchb-excel-6.jpg\" title=\"cach-dung-ham-search-searchb-excel-6\">Chi ti\u1ebft c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m SEARCH trong excel \u0111\u01a1n gi\u1ea3n, nhanh ch\u00f3ng<\/em><\/p>\n<div class=\"titletab\" id=\"titletab1\">\n<h2>1. C\u00f4ng th\u1ee9c h\u00e0m SEARCH, SEARCHB<\/h2>\n<\/div>\n<p>H\u00e0m SEARCH v\u00e0 SEARCHB trong Excel \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed xu\u1ea5t hi\u1ec7n c\u1ee7a m\u1ed9t chu\u1ed7i k\u00fd t\u1ef1 trong chu\u1ed7i v\u0103n b\u1ea3n kh\u00e1c, v\u00e0 tr\u1ea3 v\u1ec1 s\u1ed1 th\u1ee9 t\u1ef1 c\u1ee7a k\u00fd t\u1ef1 \u0111\u1ea7u ti\u00ean m\u00e0 chu\u1ed7i c\u1ea7n t\u00ecm b\u1eaft \u0111\u1ea7u.<\/p>\n<p>V\u00ed d\u1ee5: <strong>=SEARCH(&#8220;nam&#8221;,&#8221;vietnam&#8221;)<\/strong><\/p>\n<p>K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 5, v\u00ec ph\u1ea7n \u201cnam\u201d b\u1eaft \u0111\u1ea7u t\u1ea1i k\u00fd t\u1ef1 th\u1ee9 5 trong t\u1eeb \u201cvietnam\u201d.<\/p>\n<p>C\u00f4ng th\u1ee9c c\u1ee7a h\u00e0m SEARCH v\u00e0 SEARCHB nh\u01b0 sau:<\/p>\n<ul>\n<li><strong>=SEARCH(find_text, within_text, start_num)<\/strong><\/li>\n<li><strong>=SEARCHB(find_text, within_text, start_num)<\/strong><\/li>\n<\/ul>\n<p><strong>Trong \u0111\u00f3:<\/strong><\/p>\n<ul>\n<li><strong>find_text (b\u1eaft bu\u1ed9c):<\/strong> Chu\u1ed7i v\u0103n b\u1ea3n ho\u1eb7c k\u00fd t\u1ef1 m\u00e0 b\u1ea1n mu\u1ed1n t\u00ecm ki\u1ebfm.<\/li>\n<li><strong>within_text (b\u1eaft bu\u1ed9c):<\/strong> Chu\u1ed7i v\u0103n b\u1ea3n ch\u1ee9a ph\u1ea7n m\u00e0 b\u1ea1n mu\u1ed1n t\u00ecm.<\/li>\n<li><strong>start_num (t\u00f9y ch\u1ecdn):<\/strong> V\u1ecb tr\u00ed k\u00fd t\u1ef1 trong within_text m\u00e0 Excel s\u1ebd b\u1eaft \u0111\u1ea7u t\u00ecm ki\u1ebfm t\u1eeb \u0111\u00f3.<\/li>\n<\/ul>\n<p><strong>L\u01b0u \u00fd:<\/strong> SEARCHB ho\u1ea1t \u0111\u1ed9ng t\u01b0\u01a1ng t\u1ef1 SEARCH, tuy nhi\u00ean c\u00f3 s\u1ef1 kh\u00e1c bi\u1ec7t khi l\u00e0m vi\u1ec7c trong h\u1ec7 th\u1ed1ng h\u1ed7 tr\u1ee3 k\u00fd t\u1ef1 hai byte (DBCS) nh\u01b0 ti\u1ebfng Nh\u1eadt, ti\u1ebfng Trung ho\u1eb7c ti\u1ebfng H\u00e0n. Trong c\u00e1c h\u1ec7 th\u1ed1ng n\u00e0y, SEARCHB \u0111\u1ebfm m\u1ed7i k\u00fd t\u1ef1 hai byte (DBCS) l\u00e0 2, thay v\u00ec 1 nh\u01b0 SEARCH.<\/p>\n<p><em><img decoding=\"async\" alt=\"C\u00fa ph\u00e1p chu\u1ea9n c\u1ee7a h\u00e0m SEARCH trong Excel d\u1ec5 hi\u1ec3u nh\u1ea5t\" src=\"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/11\/cach-dung-ham-search-searchb-excel-4.jpg\" title=\"cach-dung-ham-search-searchb-excel-4\">C\u00f4ng th\u1ee9c h\u00e0m SEARCH trong Excel<\/em><\/p>\n<div class=\"titletab\" id=\"titletab2\">\n<h2>2. C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m SEARCH trong Excel<\/h2>\n<\/div>\n<div class=\"titletab\" id=\"titletab2_1\">\n<h3>2.1 S\u1eed d\u1ee5ng h\u00e0m SEARCH k\u1ebft h\u1ee3p h\u00e0m LEFT<\/h3>\n<\/div>\n<p><strong>V\u00ed d\u1ee5:<\/strong> T\u00ecm c\u00e1c k\u00fd t\u1ef1 tr\u01b0\u1edbc t\u1eeb \u201cHEX\u201d trong m\u00e3 \u0111\u01a1n h\u00e0ng<\/p>\n<p><strong>B\u01b0\u1edbc 1:<\/strong> Trong b\u1ea3ng t\u00ednh Excel b\u1ea1n nh\u1eadp h\u00e0m <strong>=LEFT(B3,SEARCH(&#8220;HEX&#8221;,B3)-2)<\/strong> v\u00e0o \u00f4 tham chi\u1ebfu mu\u1ed1n hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3.<\/p>\n<p>Gi\u1ea3i th\u00edch h\u00e0m:<\/p>\n<ul>\n<li><strong>LEFT:<\/strong> L\u00e0 l\u1ec7nh h\u00e0m l\u1ea5y k\u1ebft qu\u1ea3 t\u1eeb b\u00ean tr\u00e1i.<\/li>\n<li><strong>B3:<\/strong> L\u00e0 \u00f4 tham chi\u1ebfu l\u1ea5y d\u1eef li\u1ec7u.<\/li>\n<li><strong>SEARCH:<\/strong> L\u00e0 l\u1ec7nh h\u00e0m t\u00ecm ki\u1ebfm k\u00fd t\u1ef1.<\/li>\n<li><strong>-2:<\/strong> L\u00e0 s\u1ed1 l\u01b0\u1ee3ng b\u1ea1n mu\u1ed1n lo\u1ea1i b\u1ecf k\u00fd t\u1ef1 th\u1eeba.<\/li>\n<\/ul>\n<p><strong>B\u01b0\u1edbc 2:<\/strong> Nh\u1ea5n <strong>Enter<\/strong> \u0111\u1ec3 Excel hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3 ph\u1ea7n m\u00e3 \u0111\u01b0\u1ee3c t\u00e1ch ra.<\/p>\n<p><strong>B\u01b0\u1edbc 3:<\/strong> K\u00e9o c\u00f4ng th\u1ee9c xu\u1ed1ng c\u00e1c \u00f4 b\u00ean d\u01b0\u1edbi \u0111\u1ec3 \u00e1p d\u1ee5ng cho to\u00e0n b\u1ed9 danh s\u00e1ch m\u00e3 \u0111\u01a1n h\u00e0ng.<\/p>\n<p><em><img decoding=\"async\" alt=\"H\u00e0m SEARCH t\u00e1ch k\u00fd t\u1ef1 trong m\u00e3 \u0111\u01a1n h\u00e0ng Excel\" src=\"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/11\/cach-dung-ham-search-searchb-excel-11.jpg\" title=\"cach-dung-ham-search-searchb-excel-11\">Thao t\u00e1c k\u1ebft h\u1ee3p h\u00e0m SEARCH v\u00e0 h\u00e0m LEFT \u0111\u1ec3 t\u00e1ch k\u00fd t\u1ef1<\/em><\/p>\n<div class=\"infobox\"><strong>Xem th\u00eam: <\/strong>C\u00e1ch d\u00f9ng h\u00e0m FILTER trong Excel \u0111\u1ec3 l\u1ecdc d\u1eef li\u1ec7u c\u1ef1c nhanh<\/div>\n<div class=\"titletab\" id=\"titletab2_2\">\n<h3>2.2 S\u1eed d\u1ee5ng h\u00e0m SEARCH k\u1ebft h\u1ee3p h\u00e0m MID<\/h3>\n<\/div>\n<p><strong>V\u00ed d\u1ee5:<\/strong> T\u00ecm 3 k\u00fd t\u1ef1 sau d\u1ea5u \u201c_\u201d trong m\u00e3 \u0111\u01a1n h\u00e0ng<\/p>\n<p><strong>B\u01b0\u1edbc 1:<\/strong> T\u1ea1i \u00f4 n\u01a1i b\u1ea1n mu\u1ed1n hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3, nh\u1eadp c\u00f4ng th\u1ee9c sau: <strong>=MID(B3, SEARCH(&#8220;_&#8221;, B3) +1, 3)<\/strong><\/p>\n<p>Gi\u1ea3i th\u00edch c\u00f4ng th\u1ee9c:<\/p>\n<ul>\n<li><strong>MID:<\/strong> D\u00f9ng \u0111\u1ec3 tr\u00edch xu\u1ea5t m\u1ed9t s\u1ed1 k\u00fd t\u1ef1 nh\u1ea5t \u0111\u1ecbnh n\u1eb1m gi\u1eefa chu\u1ed7i v\u0103n b\u1ea3n.<\/li>\n<li><strong>B3:<\/strong> L\u00e0 \u00f4 ch\u1ee9a d\u1eef li\u1ec7u c\u1ea7n x\u1eed l\u00fd.<\/li>\n<li><strong>SEARCH:<\/strong> H\u00e0m t\u00ecm v\u1ecb tr\u00ed c\u1ee7a m\u1ed9t k\u00fd t\u1ef1 ho\u1eb7c chu\u1ed7i k\u00fd t\u1ef1 c\u1ee5 th\u1ec3.<\/li>\n<li><strong>+1:<\/strong> Gi\u00fap b\u1ecf qua k\u00fd t\u1ef1 kho\u1ea3ng tr\u1eafng v\u00e0 b\u1eaft \u0111\u1ea7u l\u1ea5y k\u00fd t\u1ef1 ngay sau \u0111\u00f3.<\/li>\n<li><strong>3:<\/strong> L\u00e0 s\u1ed1 l\u01b0\u1ee3ng k\u00fd t\u1ef1 b\u1ea1n mu\u1ed1n hi\u1ec3n th\u1ecb t\u00ednh t\u1eeb v\u1ecb tr\u00ed x\u00e1c \u0111\u1ecbnh.<\/li>\n<\/ul>\n<p><strong>B\u01b0\u1edbc 2:<\/strong> Nh\u1ea5n <strong>Enter<\/strong> \u0111\u1ec3 hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3 k\u00fd t\u1ef1 \u0111\u01b0\u1ee3c t\u00e1ch ra t\u1eeb chu\u1ed7i sau d\u1ea5u \u201c_\u201d.<\/p>\n<p><em><img decoding=\"async\" alt=\"C\u00e1ch k\u1ebft h\u1ee3p h\u00e0m MID v\u00e0 SEARCH \u0111\u1ec3 t\u00e1ch chu\u1ed7i d\u1eef li\u1ec7u\" src=\"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/11\/cach-dung-ham-search-searchb-excel-5.jpg\" title=\"cach-dung-ham-search-searchb-excel-5\">C\u00e1ch d\u00f9ng h\u00e0m SEARCH k\u1ebft h\u1ee3p MID \u0111\u1ec3 t\u00e1ch chu\u1ed7i<\/em><\/p>\n<div class=\"titletab\" id=\"titletab2_3\">\n<h3>2.3 S\u1eed d\u1ee5ng h\u00e0m SEARCH k\u1ebft h\u1ee3p h\u00e0m RIGHT<\/h3>\n<\/div>\n<p><strong>V\u00ed d\u1ee5:<\/strong> T\u00ecm v\u00e0 hi\u1ec3n th\u1ecb \u0111o\u1ea1n k\u00fd t\u1ef1 ph\u00eda b\u00ean ph\u1ea3i trong \u00f4 B4.<\/p>\n<p><strong>B\u01b0\u1edbc 1:<\/strong> Nh\u1eadp c\u00f4ng th\u1ee9c v\u00e0o \u00f4 c\u1ea7n hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3: <strong>=RIGHT(B4, SEARCH(&#8221; &#8220;, B4) + 1)<\/strong><\/p>\n<p>Gi\u1ea3i th\u00edch:<\/p>\n<ul>\n<li><strong>RIGHT:<\/strong> Tr\u00edch xu\u1ea5t k\u00fd t\u1ef1 t\u1eeb ph\u00eda ph\u1ea3i c\u1ee7a chu\u1ed7i.<\/li>\n<li><strong>B4:<\/strong> \u00d4 ch\u1ee9a v\u0103n b\u1ea3n g\u1ed1c.<\/li>\n<li><strong>SEARCH:<\/strong> X\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed c\u1ee7a d\u1ea5u c\u00e1ch &#8221; &#8221; trong chu\u1ed7i.<\/li>\n<li><strong>+1:<\/strong> Gi\u00fap k\u1ebft qu\u1ea3 bao g\u1ed3m th\u00eam m\u1ed9t k\u00fd t\u1ef1 ngay sau v\u1ecb tr\u00ed t\u00ecm \u0111\u01b0\u1ee3c.<\/li>\n<\/ul>\n<p><em><img decoding=\"async\" alt=\"D\u00f9ng h\u00e0m SEARCH \u0111\u1ec3 t\u00e1ch t\u00ean trong Excel\" src=\"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/11\/cach-dung-ham-search-searchb-excel-2.jpg\" title=\"cach-dung-ham-search-searchb-excel-2\">C\u00e1ch d\u00f9ng h\u00e0m SEARCH k\u1ebft h\u1ee3p RIGHT trong Excel<\/em><\/p>\n<p><strong>B\u01b0\u1edbc 2:<\/strong> Nh\u1ea5n <strong>Enter<\/strong> \u0111\u1ec3 hi\u1ec3n th\u1ecb ph\u1ea7n k\u00fd t\u1ef1 \u0111\u01b0\u1ee3c l\u1ea5y ra t\u1eeb cu\u1ed1i chu\u1ed7i.<\/p>\n<p>2.4 S\u1eed d\u1ee5ng h\u00e0m SEARCH k\u1ebft h\u1ee3p h\u00e0m LEN<\/p>\n<p><strong>V\u00ed d\u1ee5:<\/strong> Gi\u1ea3 s\u1eed b\u1ea1n mu\u1ed1n t\u00e1ch c\u1ee5m t\u1eeb \u201cth\u00e0nh ph\u1ed1 H\u00e0 N\u1ed9i\u201d t\u1eeb chu\u1ed7i \u201cCh\u00e0o m\u1eebng b\u1ea1n \u0111\u1ebfn v\u1edbi th\u00e0nh ph\u1ed1 H\u00e0 N\u1ed9i\u201d, h\u00e3y nh\u1eadp c\u00f4ng th\u1ee9c sau:<\/p>\n<p><strong>B\u01b0\u1edbc 1:<\/strong> Nh\u1eadp h\u00e0m <strong>=RIGHT(A2, LEN(A2) &#8211; SEARCH(&#8220;th\u00e0nh ph\u1ed1&#8221;, A2) + 1)<\/strong> v\u00e0o \u00f4 tham chi\u1ebfu mu\u1ed1n hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3<\/p>\n<p>Gi\u1ea3i th\u00edch:<\/p>\n<ul>\n<li><strong>SEARCH(&#8220;th\u00e0nh ph\u1ed1&#8221;, A2):<\/strong> X\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed b\u1eaft \u0111\u1ea7u c\u1ee7a c\u1ee5m \u201cth\u00e0nh ph\u1ed1\u201d trong chu\u1ed7i.<\/li>\n<li><strong>LEN(A2):<\/strong> \u0110\u1ebfm t\u1ed5ng s\u1ed1 k\u00fd t\u1ef1 trong chu\u1ed7i g\u1ed1c.<\/li>\n<li><strong>RIGHT:<\/strong> L\u1ea5y ph\u1ea7n v\u0103n b\u1ea3n n\u1eb1m b\u00ean ph\u1ea3i, b\u1eaft \u0111\u1ea7u t\u1eeb v\u1ecb tr\u00ed \u0111\u01b0\u1ee3c x\u00e1c \u0111\u1ecbnh b\u1edfi h\u00e0m SEARCH.<\/li>\n<\/ul>\n<p><em><img decoding=\"async\" alt=\"C\u00f4ng th\u1ee9c RIGHT k\u1ebft h\u1ee3p SEARCH trong b\u1ea3ng t\u00ednh Excel\" src=\"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/11\/cach-dung-ham-search-searchb-excel-8.jpg\" title=\"cach-dung-ham-search-searchb-excel-8\">C\u00f4ng th\u1ee9c SEARCH k\u1ebft h\u1ee3p LEN v\u00e0 RIGHT trong Excel<\/em><\/p>\n<p><strong>B\u01b0\u1edbc 2:<\/strong> Nh\u1ea5n<strong> Enter<\/strong> \u0111\u1ec3 hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3.<\/p>\n<p><em><img decoding=\"async\" alt=\"\u1ee8ng d\u1ee5ng h\u00e0m SEARCH \u0111\u1ec3 tr\u00edch \u0111o\u1ea1n v\u0103n b\u1ea3n c\u1ee5 th\u1ec3\" src=\"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/11\/cach-dung-ham-search-searchb-excel-7.jpg\" title=\"cach-dung-ham-search-searchb-excel-7\">K\u1ebft qu\u1ea3 hi\u1ec3n th\u1ecb chu\u1ed7i k\u00fd t\u1ef1 mong mu\u1ed1n sau khi \u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c<\/em><\/p>\n<div class=\"titletab\" id=\"titletab3\">\n<h2>3. M\u1ed9t s\u1ed1 l\u01b0u \u00fd khi s\u1eed d\u1ee5ng h\u00e0m SEARCH<\/h2>\n<\/div>\n<p><strong>Khi n\u00e0o n\u00ean k\u1ebft h\u1ee3p v\u1edbi h\u00e0m kh\u00e1c<\/strong><\/p>\n<ul>\n<li>D\u00f9ng SEARCH\/SEARCHB \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed k\u00fd t\u1ef1\/chu\u1ed7i trong v\u0103n b\u1ea3n, sau \u0111\u00f3:<\/li>\n<li>K\u1ebft h\u1ee3p MID\/MIDB \u0111\u1ec3 tr\u00edch xu\u1ea5t \u0111o\u1ea1n v\u0103n b\u1ea3n theo v\u1ecb tr\u00ed t\u00ecm \u0111\u01b0\u1ee3c.<\/li>\n<li>K\u1ebft h\u1ee3p REPLACE\/REPLACEB \u0111\u1ec3 thay th\u1ebf m\u1ed9t ph\u1ea7n chu\u1ed7i d\u1ef1a tr\u00ean v\u1ecb tr\u00ed x\u00e1c \u0111\u1ecbnh.<\/li>\n<\/ul>\n<p><strong>Ph\u00e2n bi\u1ec7t ch\u1eef hoa \u2013 ch\u1eef th\u01b0\u1eddng<\/strong><\/p>\n<ul>\n<li>SEARCH\/SEARCHB kh\u00f4ng ph\u00e2n bi\u1ec7t hoa &#8211; th\u01b0\u1eddng.<\/li>\n<li>C\u1ea7n t\u00ecm ki\u1ebfm ph\u00e2n bi\u1ec7t hoa &#8211; th\u01b0\u1eddng \u2192 D\u00f9ng FIND\/FINDB.<\/li>\n<\/ul>\n<p><strong>C\u00e1c t\u00ecnh hu\u1ed1ng g\u00e2y l\u1ed7i #VALUE!<\/strong><\/p>\n<ul>\n<li>Kh\u00f4ng t\u00ecm th\u1ea5y chu\u1ed7i find_text trong within_text.<\/li>\n<li>start_num l\u1edbn h\u01a1n \u0111\u1ed9 d\u00e0i c\u1ee7a within_text.<\/li>\n<li>start_num \u2264 0 (kh\u00f4ng h\u1ee3p l\u1ec7).<\/li>\n<\/ul>\n<p>Qua nh\u1eefng v\u00ed d\u1ee5 v\u00e0 h\u01b0\u1edbng d\u1eabn tr\u00ean, c\u00f3 th\u1ec3 th\u1ea5y h\u00e0m SEARCH v\u00e0 SEARCHB trong Excel l\u00e0 c\u00f4ng c\u1ee5 h\u1eefu hi\u1ec7u gi\u00fap ng\u01b0\u1eddi d\u00f9ng x\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed chu\u1ed7i, h\u1ed7 tr\u1ee3 t\u00e1ch, thay th\u1ebf ho\u1eb7c ph\u00e2n t\u00edch v\u0103n b\u1ea3n nhanh ch\u00f3ng v\u00e0 ch\u00ednh x\u00e1c. Th\u00e0nh th\u1ea1o hai h\u00e0m n\u00e0y s\u1ebd gi\u00fap b\u1ea1n l\u00e0m vi\u1ec7c hi\u1ec7u qu\u1ea3 h\u01a1n v\u1edbi d\u1eef li\u1ec7u.<\/p>\n<p>\u0110\u1eebng qu\u00ean theo d\u00f5i chuy\u00ean m\u1ee5c Kinh nghi\u1ec7m c\u1ee7a Si\u00eau Th\u1ecb \u0110i\u1ec7n M\u00e1y &#8211; N\u1ed9i Th\u1ea5t Ch\u1ee3 L\u1edbn \u0111\u1ec3 c\u1eadp nh\u1eadt th\u00eam nhi\u1ec1u m\u1eb9o Excel h\u1eefu \u00edch kh\u00e1c nh\u00e9!<\/p>\n<p>N\u1ebfu b\u1ea1n \u0111ang t\u00ecm ki\u1ebfm c\u00e1c ph\u1ee5 ki\u1ec7n vi t\u00ednh b\u1ec1n b\u1ec9 v\u00e0 ph\u00f9 h\u1ee3p cho c\u00f4ng vi\u1ec7c h\u1eb1ng ng\u00e0y, h\u00e3y gh\u00e9 Si\u00eau Th\u1ecb \u0110i\u1ec7n M\u00e1y &#8211; N\u1ed9i Th\u1ea5t Ch\u1ee3 L\u1edbn \u0111\u1ec3 ch\u1ecdn ngay nh\u1eefng s\u1ea3n ph\u1ea9m h\u1ed7 tr\u1ee3 l\u00e0m vi\u1ec7c hi\u1ec7u qu\u1ea3 h\u01a1n.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>H\u00e0m SEARCH v\u00e0 SEARCHB trong Excel \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed c\u1ee7a m\u1ed9t chu\u1ed7i con trong v\u0103n b\u1ea3n, gi\u00fap ng\u01b0\u1eddi d\u00f9ng d\u1ec5 d\u00e0ng tr\u00edch xu\u1ea5t ho\u1eb7c x\u1eed l\u00fd d\u1eef li\u1ec7u. Hai h\u00e0m n\u00e0y \u0111\u1eb7c bi\u1ec7t h\u1eefu \u00edch khi l\u00e0m vi\u1ec7c v\u1edbi n\u1ed9i dung c\u00f3 k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t ho\u1eb7c nhi\u1ec1u ng\u00f4n ng\u1eef kh\u00e1c [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":4161,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-4160","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-thu-thuat"],"jetpack_featured_media_url":"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/11\/19221.jpg","_links":{"self":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts\/4160","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/comments?post=4160"}],"version-history":[{"count":0,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts\/4160\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/media\/4161"}],"wp:attachment":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/media?parent=4160"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/categories?post=4160"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/tags?post=4160"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}