{"id":24369,"date":"2021-05-11T11:10:28","date_gmt":"2021-05-11T04:10:28","guid":{"rendered":"https:\/\/ben.com.vn\/tin-tuc\/?p=24369"},"modified":"2021-05-11T11:10:28","modified_gmt":"2021-05-11T04:10:28","slug":"ham-find-trong-excel","status":"publish","type":"post","link":"https:\/\/ben.com.vn\/tin-tuc\/ham-find-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m Find trong Excel qua v\u00ed d\u1ee5 b\u00e0i t\u1eadp"},"content":{"rendered":"<p><strong>H\u00e0m Find trong Excel<\/strong> \u0111\u01b0\u1ee3c ph\u00e2n lo\u1ea1i l\u00e0 c\u00e1c h\u00e0m v\u0103n b\u1ea3n, text. H\u00e0m Excel n\u00e0y \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 tr\u1ea3 v\u1ec1 v\u1ecb tr\u00ed c\u1ee7a m\u1ed9t ho\u1eb7c chu\u1ed7i k\u00fd t\u1ef1 con \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh trong chu\u1ed7i v\u0103n b\u1ea3n \u0111\u00e3 cho. Ngo\u00e0i ra trong ph\u00e2n t\u00edch t\u00e0i ch\u00ednh, h\u00e0m Find \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ecm ki\u1ebfm v\u1ecb tr\u00ed d\u1eef li\u1ec7u c\u1ee5 th\u1ec3.<\/p>\n<p>B\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y Ben Computer s\u1ebd gi\u1edbi thi\u1ec7u cho b\u1ea1n chi ti\u1ebft c\u00f4ng th\u1ee9c, c\u00fa ph\u00e1p<strong> h\u00e0m Find trong Excel<\/strong> c\u0169ng nh\u01b0 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Excel n\u00e0y.<\/p>\n<h2><strong>C\u00fa ph\u00e1p h\u00e0m Find trong Excel<\/strong><\/h2>\n<p><strong>H\u00e0m Find trong Excel<\/strong> c\u00f3 c\u00f4ng th\u1ee9c, c\u00fa ph\u00e1p nh\u01b0 d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<blockquote><p><strong>=FIND(find_text, within_text, [start_num])<\/strong><\/p><\/blockquote>\n<p>Trong c\u00f4ng th\u1ee9c tr\u00ean, c\u00e1c tham s\u1ed1 c\u1ee7a h\u00e0m Find bao g\u1ed3m:<\/p>\n<p><strong>\u2013 Find_text<\/strong>\u00a0(tham s\u1ed1 b\u1eaft bu\u1ed9c): l\u00e0 k\u00fd t\u1ef1 ho\u1eb7c chu\u1ed7i con m\u00e0 ch\u00fang ta c\u1ea7n t\u00ecm.<\/p>\n<p><strong>\u2013 Within_text<\/strong>\u00a0(tham s\u1ed1 b\u1eaft bu\u1ed9c): l\u00e0 chu\u1ed7i v\u0103n b\u1ea3n cho tr\u01b0\u1edbc m\u00e0 ch\u00fang ta c\u1ea7n t\u00ecm ki\u1ebfm v\u1ecb tr\u00ed c\u1ee7a Find_text.<\/p>\n<p><strong>\u2013 Start_num<\/strong>\u00a0(tham s\u1ed1 t\u00f9y ch\u1ecdn): ch\u1ec9 \u0111\u1ecbnh v\u1ecb tr\u00ed chu\u1ed7i within_text, t\u1eeb \u0111\u00f3 h\u00e0m s\u1ebd b\u1eaft \u0111\u1ea7u t\u00ecm ki\u1ebfm. N\u1ebfu ch\u00fang ta b\u1ecf qua tham s\u1ed1 n\u00e0y, h\u00e0m Find s\u1ebd s\u1eed d\u1ee5ng gi\u00e1 m\u1eb7c \u0111\u1ecbnh l\u00e0 1, t\u1ee9c l\u00e0 h\u00e0m s\u1ebd b\u1eaft \u0111\u1ea7u t\u00ecm ki\u1ebfm \u1edf \u0111\u1ea7u chu\u1ed7i within_text.<\/p>\n<h2><strong>C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m <\/strong><strong>Find <\/strong><strong>trong Excel<\/strong><\/h2>\n<p>L\u00e0 m\u1ed9t h\u00e0m b\u1ea3ng t\u00ednh, h\u00e0m Find Excel c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c nh\u1eadp nh\u01b0 m\u1ed9t ph\u1ea7n c\u1ee7a c\u00f4ng th\u1ee9c h\u00e0m Excel trong m\u1ed9t \u00f4 b\u1ea3ng t\u00ednh. \u0110\u1ec3 t\u00ecm hi\u1ec3u c\u00e1ch s\u1eed d\u1ee5ng <strong>h\u00e0m Find trong Excel<\/strong> nh\u01b0 th\u1ebf n\u00e0o, b\u1ea1n \u0111\u1ecdc c\u00f3 th\u1ec3 tham kh\u1ea3o m\u1ed9t s\u1ed1 v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<h3><strong>1. V\u00ed d\u1ee5 1<\/strong><\/h3>\n<p>Gi\u1ea3 s\u1eed ch\u00fang ta mu\u1ed1n t\u00ecm ki\u1ebfm s\u1ed1 k\u00fd t\u1ef1 c\u1ee5 th\u1ec3 t\u1eeb c\u00e1c d\u1eef li\u1ec7u, chu\u1ed7i v\u0103n b\u1ea3n cho tr\u01b0\u1edbc d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<p>Data is not correct<\/p>\n<p>Revenue grew by 5%<\/p>\n<p>Original Text<\/p>\n<p>C\u00f4ng th\u1ee9c h\u00e0m Find s\u1eed d\u1ee5ng v\u00e0 k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 c\u00f3 d\u1ea1ng nh\u01b0 d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"632\" height=\"251\" class=\"aligncenter wp-image-16597 size-full\" src=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/1-5.jpg\" srcset=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/1-5-300x119.jpg 300w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/1-5.jpg 632w\" alt=\"1 5 - C\u00fa ph\u00e1p h\u00e0m Find trong Excel - Ben Computer\" \/><\/p>\n<p><strong>L\u01b0u \u00fd:<\/strong><\/p>\n<ul>\n<li>H\u00e0m Find ph\u00e2n bi\u1ec7t ch\u1eef hoa, ch\u1eef th\u01b0\u1eddng, do \u0111\u00f3 gi\u00e1 tr\u1ecb find_text vi\u1ebft hoa v\u00e0 vi\u1ebft th\u01b0\u1eddng, \u201cT\u201d v\u00e0 \u201ct\u201d s\u1ebd tr\u1ea3 v\u1ec1 c\u00e1c k\u1ebft qu\u1ea3 kh\u00e1c nhau.<\/li>\n<li>N\u1ebfu tham s\u1ed1 [start_num] c\u00f3 gi\u00e1 tr\u1ecb l\u00e0 4 th\u00ec h\u00e0m Find s\u1ebd b\u1eaft \u0111\u1ea7u t\u00ecm ki\u1ebfm t\u1eeb k\u00fd t\u1ef1 th\u1ee9 4 trong chu\u1ed7i within_text.<\/li>\n<\/ul>\n<h3><strong>2. V\u00ed d\u1ee5 2<\/strong><\/h3>\n<p>Ti\u1ebfp theo, cho b\u1ea3ng d\u1eef li\u1ec7u nh\u01b0 d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"632\" height=\"287\" class=\"aligncenter wp-image-16598 size-full\" src=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/2-5.jpg\" srcset=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/2-5-300x136.jpg 300w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/2-5.jpg 632w\" alt=\"2 5 - C\u00fa ph\u00e1p h\u00e0m Find trong Excel - Ben Computer\" \/><\/p>\n<p>Trong \u00f4 t\u1eeb D2 \u0111\u1ebfn D4, ch\u00fang ta mu\u1ed1n t\u00ecm ki\u1ebfm v\u1ecb tr\u00ed c\u00e1c k\u00fd t\u1ef1 \u201cHero\u201d trong \u00f4 B2, k\u00fd t\u1ef1 \u201c@\u201d trong \u00f4 C3 v\u00e0 k\u00fd t\u1ef1 \u201ca\u201d trong \u00f4 B4 t\u01b0\u01a1ng \u1ee9ng.<\/p>\n<p>V\u00ec v\u1eady c\u00f4ng th\u1ee9c h\u00e0m Find trong \u00f4 D2 c\u00f3 d\u1ea1ng nh\u01b0 d\u01b0\u1edbi \u0111\u00e2y. Sau \u0111\u00f3 ch\u00fang ta s\u1ebd k\u00e9o c\u00f4ng th\u1ee9c h\u00e0m n\u00e0y t\u1eeb \u00f4 D2 xu\u1ed1ng D4.<\/p>\n<p><strong>=FIND(C4,B4,14)<\/strong><\/p>\n<p>D\u01b0\u1edbi \u0111\u00e2y l\u00e0 k\u1ebft qu\u1ea3 h\u00e0m Find Excel tr\u1ea3 v\u1ec1:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"632\" height=\"236\" class=\"aligncenter wp-image-16599 size-full\" src=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/3-4.jpg\" srcset=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/3-4-300x112.jpg 300w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/3-4.jpg 632w\" alt=\"3 4 - C\u00fa ph\u00e1p h\u00e0m Find trong Excel - Ben Computer\" \/><\/p>\n<h3><strong>3. V\u00ed d\u1ee5 3<\/strong><\/h3>\n<p>Trong v\u00ed d\u1ee5 n\u00e0y ch\u00fang ta t\u00ecm ki\u1ebfm k\u00fd t\u1ef1 th\u1ee9 2, 3 v\u00e0 th\u1ee9 n t\u1eeb chu\u1ed7i v\u0103n b\u1ea3n \u0111\u00e3 cho.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"632\" height=\"200\" class=\"aligncenter wp-image-16600 size-full\" src=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/4-3.jpg\" srcset=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/4-3-300x95.jpg 300w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/4-3.jpg 632w\" alt=\"4 3 - C\u00fa ph\u00e1p h\u00e0m Find trong Excel - Ben Computer\" \/><\/p>\n<p>\u1ede \u0111\u00e2y, chu\u1ed7i v\u0103n b\u1ea3n \u0111\u01b0\u1ee3c cho n\u1eb1m trong ph\u1ea1m vi t\u1eeb \u00f4 A2 : A4. Trong c\u00e1c \u00f4 C2, C3 v\u00e0 C4, ch\u00fang ta nh\u1eadp c\u00e1c k\u00fd t\u1ef1 c\u1ea7n t\u00ecm ki\u1ebfm t\u1eeb chu\u1ed7i. Trong \u00f4 D2, D3 v\u00e0 D4 nh\u1eadp v\u1ecb tr\u00ed c\u00e1c k\u00fd t\u1ef1 xu\u1ea5t hi\u1ec7n.<\/p>\n<p>C\u00f4ng th\u1ee9c h\u00e0m Find Excel c\u00f3 d\u1ea1ng nh\u01b0 d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<p><strong>=FIND(\u201c~\u201d, SUBSTITUTE(A2,C2,\u201d~\u201d,D2))<\/strong><\/p>\n<p>Nh\u1eadp c\u00f4ng th\u1ee9c h\u00e0m Excel n\u00e0y v\u00e0o \u00f4 E2 v\u00e0 k\u00e9o xu\u1ed1ng \u00f4 E4. K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 t\u01b0\u01a1ng \u1ee9ng trong \u00f4 E2 \u0111\u1ebfn E4.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"632\" height=\"180\" class=\"aligncenter wp-image-16601 size-full\" src=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/5-2.jpg\" srcset=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/5-2-300x85.jpg 300w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/5-2.jpg 632w\" alt=\"5 2 - C\u00fa ph\u00e1p h\u00e0m Find trong Excel - Ben Computer\" \/><\/p>\n<h2><strong>M\u1ed9t s\u1ed1 l\u01b0u \u00fd khi s\u1eed d\u1ee5ng h\u00e0m Find trong Excel<\/strong><\/h2>\n<ol>\n<li><strong>H\u00e0m Find trong Excel<\/strong> tr\u1ea3 v\u1ec1 v\u1ecb tr\u00ed find_text \u0111\u1ea7u ti\u00ean trong chu\u1ed7i v\u0103n b\u1ea3n cho tr\u01b0\u1edbc trong within_text.<\/li>\n<li>V\u1ecb tr\u00ed \u0111\u01b0\u1ee3c tr\u1ea3 v\u1ec1 d\u01b0\u1edbi d\u1ea1ng s\u1ed1 k\u00fd t\u1ef1 \u0111\u01b0\u1ee3c t\u00ednh t\u1eeb \u0111\u1ea7u chu\u1ed7i v\u0103n b\u1ea3n within_text.<\/li>\n<li>Start_num l\u00e0 tham s\u1ed1 t\u00f9y ch\u1ecdn v\u00e0 gi\u00e1 tr\u1ecb m\u1eb7c \u0111\u1ecbnh l\u00e0 1.<\/li>\n<li>H\u00e0m Find Excel tr\u1ea3 v\u1ec1 l\u1ed7i #VALUE n\u1ebfu kh\u00f4ng t\u00ecm th\u1ea5y find_text trong within_text.<\/li>\n<li>H\u00e0m Excel n\u00e0y ph\u00e2n bi\u1ec7t ch\u1eef hoa v\u00e0 ch\u1eef th\u01b0\u1eddng, v\u00e0 kh\u00f4ng h\u1ed7 tr\u1ee3 c\u00e1c k\u00fd t\u1ef1 \u0111\u1ea1i di\u1ec7n.<\/li>\n<li>Ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m Search \u0111\u1ec3 t\u00ecm ki\u1ebfm v\u1ecb tr\u00ed k\u00fd t\u1ef1. H\u00e0m n\u00e0y kh\u00f4ng bi\u1ec7t ch\u1eef hoa ch\u1eef th\u01b0\u1eddng v\u00e0 h\u1ed7 tr\u1ee3 c\u00e1c k\u00fd t\u1ef1 \u0111\u1ea1i di\u1ec7n.<\/li>\n<\/ol>\n<p>Tr\u00ean \u0111\u00e2y Ben Computer v\u1eeba gi\u1edbi thi\u1ec7u cho b\u1ea1n c\u00e1ch s\u1eed d\u1ee5ng, c\u00fa ph\u00e1p <strong>h\u00e0m Find trong Excel<\/strong> nh\u01b0 th\u1ebf n\u00e0o. B\u00ean c\u1ea1nh \u0111\u00f3 b\u1ea1n \u0111\u1ecdc c\u00f3 th\u1ec3 tham kh\u1ea3o th\u00eam m\u1ed9t s\u1ed1 b\u00e0i vi\u1ebft \u0111\u00e3 c\u00f3 tr\u00ean Ben \u0111\u1ec3 t\u00ecm hi\u1ec3u th\u00eam c\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng <a href=\"https:\/\/ben.com.vn\/tin-tuc\/ham-max-trong-excel\/\">h\u00e0m Max trong Excel<\/a> nh\u01b0 th\u1ebf n\u00e0o nh\u00e9.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>H\u00e0m Find trong Excel \u0111\u01b0\u1ee3c ph\u00e2n lo\u1ea1i l\u00e0 c\u00e1c h\u00e0m v\u0103n b\u1ea3n, text. H\u00e0m Excel n\u00e0y \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 tr\u1ea3 v\u1ec1 v\u1ecb tr\u00ed c\u1ee7a m\u1ed9t ho\u1eb7c chu\u1ed7i k\u00fd t\u1ef1 con \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh trong chu\u1ed7i v\u0103n b\u1ea3n \u0111\u00e3 cho. Ngo\u00e0i ra trong ph\u00e2n t\u00edch t\u00e0i ch\u00ednh, h\u00e0m Find \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ecm ki\u1ebfm [&hellip;]<\/p>\n","protected":false},"author":39,"featured_media":24370,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_links_to":"","_links_to_target":""},"categories":[10],"tags":[],"class_list":["post-24369","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-thu-thuat-phan-mem"],"_links":{"self":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/24369","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/users\/39"}],"replies":[{"embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/comments?post=24369"}],"version-history":[{"count":0,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/24369\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/media\/24370"}],"wp:attachment":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/media?parent=24369"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/categories?post=24369"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/tags?post=24369"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}