{"id":5045,"date":"2025-11-21T11:26:00","date_gmt":"2025-11-21T04:26:00","guid":{"rendered":"https:\/\/autofillform.com\/blog\/huong-dan-cach-su-dung-ham-small-trong-excel-cuc-de-hieu\/"},"modified":"2025-11-21T11:26:00","modified_gmt":"2025-11-21T04:26:00","slug":"huong-dan-cach-su-dung-ham-small-trong-excel-cuc-de-hieu","status":"publish","type":"post","link":"https:\/\/autofillform.com\/blog\/huong-dan-cach-su-dung-ham-small-trong-excel-cuc-de-hieu\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m SMALL trong Excel c\u1ef1c d\u1ec5 hi\u1ec3u"},"content":{"rendered":"<div class=\"content_article\" id=\"clicklinka\">\n<div id=\"bxindexknh\">\u00a0<\/div>\n<p>Khi c\u1ea7n l\u1ea5y ra c\u00e1c gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t trong danh s\u00e1ch s\u1ed1 li\u1ec7u, h\u00e0m SMALL s\u1ebd gi\u00fap b\u1ea1n th\u1ef1c hi\u1ec7n nhanh v\u00e0 ch\u00ednh x\u00e1c. N\u1ed9i dung b\u00e0i vi\u1ebft s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1ch d\u00f9ng h\u00e0m, \u00fd ngh\u0129a t\u1eebng tham s\u1ed1 v\u00e0 c\u00e1c v\u00ed d\u1ee5 \u00e1p d\u1ee5ng tr\u1ef1c quan \u0111\u1ec3 b\u1ea1n x\u1eed l\u00fd d\u1eef li\u1ec7u thu\u1eadn ti\u1ec7n h\u01a1n trong Excel.<\/p>\n<p><em><img decoding=\"async\" alt=\"c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m SMALL trong Excel\" src=\"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/11\/ham-small-trong-excel-8.jpg\" title=\"ham-small-trong-excel-8\">H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m SMALL trong Excel<\/em><\/p>\n<div class=\"titletab\" id=\"titletab1\">\n<h2>1. H\u00e0m SMALL l\u00e0 g\u00ec<\/h2>\n<\/div>\n<p>H\u00e0m SMALL d\u00f9ng \u0111\u1ec3 tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb nh\u1ecf th\u1ee9 k trong m\u1ed9t d\u00e3y s\u1ed1. \u0110\u00e2y l\u00e0 c\u00f4ng c\u1ee5 h\u1eefu \u00edch khi b\u1ea1n c\u1ea7n x\u00e1c \u0111\u1ecbnh c\u00e1c m\u1ee9c gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t theo th\u1ee9 t\u1ef1 trong m\u1ed9t b\u1ea3ng d\u1eef li\u1ec7u.<\/p>\n<p>Trong Excel, SMALL th\u01b0\u1eddng \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3:<\/p>\n<ul>\n<li>Nhanh ch\u00f3ng t\u00ecm ra gi\u00e1 tr\u1ecb \u0111\u1ee9ng th\u1ee9 k t\u1eeb nh\u1ecf \u0111\u1ebfn l\u1edbn trong t\u1eadp d\u1eef li\u1ec7u.<\/li>\n<li>K\u1ebft h\u1ee3p v\u1edbi c\u00e1c h\u00e0m kh\u00e1c \u0111\u1ec3 x\u1eed l\u00fd, l\u1ecdc ho\u1eb7c ph\u00e2n t\u00edch d\u1eef li\u1ec7u hi\u1ec7u qu\u1ea3 h\u01a1n.<\/li>\n<\/ul>\n<div class=\"infobox\"><strong>Xem th\u00eam: <\/strong>H\u00e0m LARGE trong Excel v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng hi\u1ec7u qu\u1ea3<\/div>\n<div class=\"titletab\" id=\"titletab2\">\n<h2>2. C\u00fa ph\u00e1p c\u1ee7a h\u00e0m SMALL<\/h2>\n<\/div>\n<p>C\u00fa ph\u00e1p s\u1eed d\u1ee5ng h\u00e0m SMALL trong Excel nh\u01b0 sau: <strong>=SMALL(array, k)<\/strong><\/p>\n<p><strong>Gi\u1ea3i th\u00edch c\u00e1c tham s\u1ed1:<\/strong><\/p>\n<ul>\n<li><strong>array:<\/strong> V\u00f9ng d\u1eef li\u1ec7u d\u1ea1ng s\u1ed1 m\u00e0 b\u1ea1n mu\u1ed1n t\u00ecm gi\u00e1 tr\u1ecb nh\u1ecf \u0111\u1ee9ng th\u1ee9 k.<\/li>\n<li><strong>k:<\/strong> V\u1ecb tr\u00ed x\u1ebfp h\u1ea1ng theo th\u1ee9 t\u1ef1 t\u0103ng d\u1ea7n; k = 1 l\u00e0 gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t, k = 2 l\u00e0 nh\u1ecf th\u1ee9 2,\u2026<\/li>\n<\/ul>\n<p><em><img decoding=\"async\" alt=\"C\u00fa ph\u00e1p h\u00e0m SMALL trong Excel v\u1edbi g\u1ee3i \u00fd c\u00f4ng th\u1ee9c\" src=\"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/11\/ham-small-trong-excel-6.jpg\" title=\"ham-small-trong-excel-6\">C\u00fa ph\u00e1p v\u00e0 th\u00e0nh ph\u1ea7n c\u1ee7a h\u00e0m SMALL trong Excel<\/em><\/p>\n<div class=\"titletab\" id=\"titletab3\">\n<h2>3. C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m SMALL trong Excel<\/h2>\n<\/div>\n<div class=\"titletab\" id=\"titletab3_1\">\n<h3>3.1. T\u00ecm gi\u00e1 tr\u1ecb th\u1ea5p th\u1ee9 nh\u1ea5t, th\u1ee9 2, th\u1ee9 3 trong m\u1ea3ng<\/h3>\n<\/div>\n<p><strong>B\u01b0\u1edbc 1: <\/strong>T\u1ea1i \u00f4 <strong>F3<\/strong>, nh\u1eadp c\u00f4ng th\u1ee9c:<\/p>\n<p><strong>=SMALL($B$2:$B$7, E3)<\/strong><\/p>\n<p><strong>Gi\u1ea3i th\u00edch<\/strong>:<\/p>\n<ul>\n<li><strong>$B$2:$B$7:<\/strong> V\u00f9ng d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c c\u1ed1 \u0111\u1ecbnh \u0111\u1ec3 lu\u00f4n tham chi\u1ebfu \u0111\u00fang khi sao ch\u00e9p c\u00f4ng th\u1ee9c.<\/li>\n<li><strong>E3: <\/strong>Ch\u1ee9a gi\u00e1 tr\u1ecb 1, ngh\u0129a l\u00e0 y\u00eau c\u1ea7u l\u1ea5y ph\u1ea7n t\u1eed nh\u1ecf nh\u1ea5t trong danh s\u00e1ch.<\/li>\n<\/ul>\n<p><strong>B\u01b0\u1edbc 2<\/strong>: Nh\u1ea5n<strong> Enter<\/strong> \u0111\u1ec3 hi\u1ec3n th\u1ecb gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t. Ti\u1ebfp theo, sao ch\u00e9p c\u00f4ng th\u1ee9c t\u1eeb \u00f4 <strong>F3<\/strong> xu\u1ed1ng <strong>F5<\/strong> \u0111\u1ec3 l\u1ea7n l\u01b0\u1ee3t l\u1ea5y gi\u00e1 tr\u1ecb nh\u1ecf th\u1ee9 2 v\u00e0 th\u1ee9 3 trong danh s\u00e1ch.<\/p>\n<p><em><img decoding=\"async\" alt=\"Danh s\u00e1ch ba chi ph\u00ed nh\u1ecf nh\u1ea5t b\u1eb1ng h\u00e0m SMALL\" src=\"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/11\/ham-small-trong-excel-4.jpg\" title=\"ham-small-trong-excel-4\">T\u00ecm gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t, nh\u1ecf th\u1ee9 2 v\u00e0 th\u1ee9 3 b\u1eb1ng SMALL<\/em><\/p>\n<div class=\"titletab\" id=\"titletab3_2\">\n<h3>3.2. T\u00ecm t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb nh\u1ecf th\u1ee9 n<\/h3>\n<\/div>\n<p>B\u1ea1n c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p h\u00e0m SMALL v\u1edbi SUMPRODUCT \u0111\u1ec3 t\u00ednh t\u1ed5ng 3 gi\u00e1 tr\u1ecb th\u1ea5p nh\u1ea5t trong m\u1ed9t danh s\u00e1ch s\u1ed1 li\u1ec7u.<\/p>\n<p><strong>Gi\u1ea3i th\u00edch:<\/strong><\/p>\n<ul>\n<li><strong>SMALL(B2:B7, {1,2,3})<\/strong> tr\u1ea3 v\u1ec1 ba gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t theo th\u1ee9 t\u1ef1.<\/li>\n<li><strong>SUMPRODUCT <\/strong>c\u1ed9ng t\u1ea5t c\u1ea3 c\u00e1c gi\u00e1 tr\u1ecb m\u00e0 h\u00e0m SMALL tr\u1ea3 v\u1ec1.<\/li>\n<\/ul>\n<p><strong>B\u01b0\u1edbc 1:<\/strong> T\u1ea1i \u00f4 c\u1ea7n t\u00ednh t\u1ed5ng, nh\u1eadp:<\/p>\n<p><strong>=SUMPRODUCT(SMALL(B2:B7, {1,2,3}))<\/strong><\/p>\n<p><em><img decoding=\"async\" alt=\"C\u00f4ng th\u1ee9c SUMPRODUCT v\u1edbi h\u00e0m SMALL \u0111\u1ec3 l\u1ea5y gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t\" src=\"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/11\/ham-small-trong-excel-1.jpg\" title=\"ham-small-trong-excel-1\">C\u00e1ch d\u00f9ng SMALL k\u1ebft h\u1ee3p SUMPRODUCT \u0111\u1ec3 t\u00ednh t\u1ed5ng gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t<\/em><\/p>\n<p><strong>B\u01b0\u1edbc 2: <\/strong>Nh\u1ea5n <strong>Enter<\/strong> \u0111\u1ec3 nh\u1eadn k\u1ebft qu\u1ea3 t\u1ed5ng c\u1ee7a ba gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t trong b\u1ea3ng.<\/p>\n<p><em><img decoding=\"async\" alt=\"K\u1ebft qu\u1ea3 t\u00ednh t\u1ed5ng ba gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t b\u1eb1ng h\u00e0m SMALL\" src=\"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/11\/ham-small-trong-excel-2.jpg\" title=\"ham-small-trong-excel-2\">K\u1ebft qu\u1ea3 t\u1ed5ng ba gi\u00e1 tr\u1ecb th\u1ea5p nh\u1ea5t trong danh s\u00e1ch<\/em><\/p>\n<div class=\"titletab\" id=\"titletab3_3\">\n<h3>3.3. S\u1eafp x\u1ebfp gi\u00e1 tr\u1ecb t\u0103ng d\u1ea7n<\/h3>\n<\/div>\n<p>B\u1ea1n c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p h\u00e0m SMALL c\u00f9ng ROWS \u0111\u1ec3 l\u1ea7n l\u01b0\u1ee3t l\u1ea5y c\u00e1c gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t trong danh s\u00e1ch, t\u1eeb \u0111\u00f3 t\u1ea1o ra m\u1ed9t c\u1ed9t d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp t\u0103ng d\u1ea7n.<\/p>\n<p><strong>B\u01b0\u1edbc 1: <\/strong>T\u1ea1i \u00f4 \u0111\u1ea7u ti\u00ean c\u1ee7a c\u1ed9t k\u1ebft qu\u1ea3, nh\u1eadp c\u00f4ng th\u1ee9c:<\/p>\n<p><strong>=SMALL($B$2:$B$13, ROWS($B$2:B2))<\/strong><\/p>\n<p><strong>Gi\u1ea3i th\u00edch:<\/strong><\/p>\n<ul>\n<li><strong>$B$2:$B$13: <\/strong>V\u00f9ng d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c c\u1ed1 \u0111\u1ecbnh \u0111\u1ec3 c\u00f4ng th\u1ee9c lu\u00f4n tham chi\u1ebfu \u0111\u00fang.<\/li>\n<li><strong>ROWS($B$2:B2):<\/strong> Tr\u1ea3 v\u1ec1 s\u1ed1 l\u01b0\u1ee3ng h\u00e0ng trong ph\u1ea1m vi, gi\u00fap x\u00e1c \u0111\u1ecbnh th\u1ee9 t\u1ef1 k (1, 2, 3, \u2026) khi sao ch\u00e9p c\u00f4ng th\u1ee9c xu\u1ed1ng d\u01b0\u1edbi.<\/li>\n<\/ul>\n<p><strong>B\u01b0\u1edbc 2:<\/strong> Nh\u1ea5n <strong>Enter<\/strong>, sau \u0111\u00f3 k\u00e9o c\u00f4ng th\u1ee9c xu\u1ed1ng c\u00e1c \u00f4 ti\u1ebfp theo \u0111\u1ec3 hi\u1ec3n th\u1ecb \u0111\u1ea7y \u0111\u1ee7 c\u00e1c gi\u00e1 tr\u1ecb theo th\u1ee9 t\u1ef1 t\u0103ng d\u1ea7n.<\/p>\n<p><em><img decoding=\"async\" alt=\"S\u1eafp x\u1ebfp doanh thu t\u0103ng d\u1ea7n b\u1eb1ng h\u00e0m SMALL v\u00e0 ROWS\" src=\"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/11\/ham-small-trong-excel-3.jpg\" title=\"ham-small-trong-excel-3\">\u1ee8ng d\u1ee5ng SMALL v\u00e0 ROWS \u0111\u1ec3 s\u1eafp x\u1ebfp d\u1eef li\u1ec7u theo th\u1ee9 t\u1ef1 t\u0103ng d\u1ea7n<\/em><\/p>\n<div class=\"titletab\" id=\"titletab3_4\">\n<h3>3.4. T\u00ecm m\u1ed9t ng\u00e0y tr\u01b0\u1edbc \u0111\u00f3 g\u1ea7n nh\u1ea5t v\u1edbi ng\u00e0y h\u00f4m nay ho\u1eb7c ng\u00e0y c\u1ee5 th\u1ec3<\/h3>\n<\/div>\n<p>Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 danh s\u00e1ch ng\u00e0y k\u00edch ho\u1ea1t v\u00e0 mu\u1ed1n x\u00e1c \u0111\u1ecbnh ng\u00e0y g\u1ea7n nh\u1ea5t nh\u01b0ng nh\u1ecf h\u01a1n ng\u00e0y hi\u1ec7n t\u1ea1i. B\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng h\u00e0m SMALL k\u1ebft h\u1ee3p COUNTIF.<\/p>\n<p><strong>B\u01b0\u1edbc 1: <\/strong>Nh\u1eadp danh s\u00e1ch ng\u00e0y k\u00edch ho\u1ea1t v\u00e0o c\u1ed9t A.<\/p>\n<p><strong>B\u01b0\u1edbc 2: <\/strong>T\u1ea1i \u00f4 B2, nh\u1eadp c\u00f4ng th\u1ee9c:<\/p>\n<p><strong>=SMALL(A2:A5, COUNTIF(A2:A5, &#8220;&#8221;&amp;TODAY()))<\/strong><\/p>\n<ul>\n<li><strong>A2:A5:<\/strong> V\u00f9ng ch\u1ee9a c\u00e1c ng\u00e0y c\u1ea7n so s\u00e1nh.<\/li>\n<li><strong>COUNTIF(A2:A5, &#8220;&#8221;&amp;TODAY()): <\/strong>\u0110\u1ebfm xem c\u00f3 bao nhi\u00eau ng\u00e0y nh\u1ecf h\u01a1n ng\u00e0y h\u00f4m nay. K\u1ebft qu\u1ea3 ch\u00ednh l\u00e0 \u201cth\u1ee9 h\u1ea1ng\u201d c\u1ee7a ng\u00e0y g\u1ea7n nh\u1ea5t tr\u01b0\u1edbc h\u00f4m nay.<\/li>\n<li><strong>SMALL(A2:A5, \u2026): <\/strong>Tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb nh\u1ecf th\u1ee9 n trong v\u00f9ng, v\u00e0 n ch\u00ednh l\u00e0 s\u1ed1 \u0111\u1ebfm \u1edf tr\u00ean \u2192 t\u1ee9c l\u00e0 ng\u00e0y g\u1ea7n nh\u1ea5t nh\u01b0ng v\u1eabn nh\u1ecf h\u01a1n h\u00f4m nay.<\/li>\n<\/ul>\n<p><strong>B\u01b0\u1edbc 3:<\/strong> Nh\u1ea5n <strong>Enter<\/strong> \u0111\u1ec3 hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3. N\u1ebfu \u00f4 tr\u1ea3 v\u1ec1 s\u1ed1, h\u00e3y chuy\u1ec3n \u0111\u1ecbnh d\u1ea1ng v\u1ec1 Date \u0111\u1ec3 xem \u0111\u00fang ng\u00e0y.<\/p>\n<p>K\u1ebft qu\u1ea3 l\u00e0 ng\u00e0y g\u1ea7n nh\u1ea5t ngay tr\u01b0\u1edbc ng\u00e0y h\u00f4m nay.<\/p>\n<p><em><img decoding=\"async\" alt=\"H\u00e0m SMALL t\u00ecm ng\u00e0y g\u1ea7n nh\u1ea5t d\u1ef1a tr\u00ean \u0111i\u1ec1u ki\u1ec7n COUNTIF\" src=\"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/11\/ham-small-trong-excel-5.jpg\" title=\"ham-small-trong-excel-5\">T\u00ecm ng\u00e0y g\u1ea7n nh\u1ea5t tr\u01b0\u1edbc ng\u00e0y h\u00f4m nay b\u1eb1ng SMALL v\u00e0 COUNTIF<\/em><\/p>\n<p>Trong tr\u01b0\u1eddng h\u1ee3p b\u1ea1n c\u00f3 danh s\u00e1ch ng\u00e0y k\u00edch ho\u1ea1t v\u00e0 mu\u1ed1n x\u00e1c \u0111\u1ecbnh ng\u00e0y g\u1ea7n nh\u1ea5t nh\u01b0ng v\u1eabn nh\u1ecf h\u01a1n m\u1ed9t m\u1ed1c ng\u00e0y ki\u1ec3m tra c\u1ee5 th\u1ec3, b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 d\u00f9ng h\u00e0m SMALL k\u1ebft h\u1ee3p v\u1edbi COUNTIF \u0111\u1ec3 l\u1ecdc v\u00e0 ch\u1ecdn \u0111\u00fang gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm.<\/p>\n<p><strong>B\u01b0\u1edbc 1: <\/strong>Nh\u1eadp c\u00f4ng th\u1ee9c v\u00e0o \u00f4 k\u1ebft qu\u1ea3:<\/p>\n<p><strong>=SMALL($A$2:$A$5, COUNTIF($A$2:$A$5, &#8220;&#8221;&amp;B2))<\/strong><\/p>\n<ul>\n<li><strong>$A$2:$A$5:<\/strong> V\u00f9ng ch\u1ee9a c\u00e1c ng\u00e0y k\u00edch ho\u1ea1t<\/li>\n<li><strong>B2:<\/strong> M\u1ed1c ng\u00e0y ki\u1ec3m tra<\/li>\n<li><strong>COUNTIF(&#8230;):<\/strong> \u0110\u1ebfm bao nhi\u00eau ng\u00e0y nh\u1ecf h\u01a1n m\u1ed1c ki\u1ec3m tra<\/li>\n<li><strong>SMALL(&#8230;):<\/strong> L\u1ea5y ng\u00e0y l\u1edbn nh\u1ea5t trong nh\u00f3m ng\u00e0y nh\u1ecf h\u01a1n m\u1ed1c ki\u1ec3m tra (ch\u00ednh l\u00e0 ng\u00e0y g\u1ea7n nh\u1ea5t tr\u01b0\u1edbc m\u1ed1c)<\/li>\n<\/ul>\n<p><strong>B\u01b0\u1edbc 2:<\/strong> Nh\u1ea5n <strong>Enter<\/strong>, sau \u0111\u00f3 \u0111\u1ecbnh d\u1ea1ng l\u1ea1i \u00f4 k\u1ebft qu\u1ea3 v\u1ec1 ki\u1ec3u <strong>Date<\/strong> n\u1ebfu c\u1ea7n.<\/p>\n<p><em><img decoding=\"async\" alt=\"V\u00ed d\u1ee5 h\u00e0m SMALL t\u00ecm ng\u00e0y nh\u1ecf nh\u1ea5t theo \u0111i\u1ec1u ki\u1ec7n ng\u00e0y ki\u1ec3m tra\" src=\"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/11\/ham-small-trong-excel-9.jpg\" title=\"ham-small-trong-excel-9\">X\u00e1c \u0111\u1ecbnh ng\u00e0y g\u1ea7n nh\u1ea5t nh\u01b0ng v\u1eabn nh\u1ecf h\u01a1n m\u1ed9t m\u1ed1c ki\u1ec3m tra c\u1ee5 th\u1ec3<\/em><\/p>\n<div class=\"titletab\" id=\"titletab4\">\n<h2>4. M\u1ed9t s\u1ed1 l\u01b0u \u00fd khi d\u00f9ng h\u00e0m SMALL<\/h2>\n<\/div>\n<p>\u0110\u1ec3 h\u00e0m SMALL ho\u1ea1t \u0111\u1ed9ng \u0111\u00fang v\u00e0 tr\u00e1nh sai s\u00f3t trong qu\u00e1 tr\u00ecnh t\u00ednh to\u00e1n, b\u1ea1n c\u1ea7n l\u01b0u \u00fd \u0111\u1ebfn c\u00e1c \u0111i\u1ec3m sau:<\/p>\n<p>L\u1ed7i <strong>#NUM!<\/strong> th\u01b0\u1eddng xu\u1ea5t hi\u1ec7n khi:<\/p>\n<ul>\n<li>V\u00f9ng d\u1eef li\u1ec7u (array) r\u1ed7ng ho\u1eb7c kh\u00f4ng c\u00f3 gi\u00e1 tr\u1ecb d\u1ea1ng s\u1ed1.<\/li>\n<li>Gi\u00e1 tr\u1ecb k nh\u1ecf h\u01a1n 1 ho\u1eb7c l\u1edbn h\u01a1n t\u1ed5ng s\u1ed1 ph\u1ea7n t\u1eed trong v\u00f9ng d\u1eef li\u1ec7u.<\/li>\n<\/ul>\n<p>Tr\u01b0\u1eddng h\u1ee3p \u0111\u1eb7c bi\u1ec7t:<\/p>\n<ul>\n<li><strong>k = 1: <\/strong>H\u00e0m tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t.<\/li>\n<li><strong>k = n:<\/strong> H\u00e0m tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t th\u1ee9 n trong danh s\u00e1ch.<\/li>\n<\/ul>\n<p>H\u00e0m SMALL l\u00e0 c\u00f4ng c\u1ee5 h\u1eefu \u00edch khi b\u1ea1n c\u1ea7n l\u1ecdc, s\u1eafp x\u1ebfp ho\u1eb7c t\u00ecm gi\u00e1 tr\u1ecb theo th\u1ee9 h\u1ea1ng trong Excel. \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 h\u01b0\u1edbng d\u1eabn hay m\u1ed7i ng\u00e0y.<\/p>\n<p>N\u1ebfu b\u1ea1n th\u01b0\u1eddng xuy\u00ean l\u00e0m vi\u1ec7c v\u1edbi Excel, m\u1ed9t chi\u1ebfc m\u00e1y t\u00ednh b\u1ea3ng c\u1ea5u h\u00ecnh m\u1ea1nh s\u1ebd gi\u00fap thao t\u00e1c nhanh v\u00e0 ti\u1ec7n l\u1ee3i h\u01a1n khi di chuy\u1ec3n. Tham kh\u1ea3o c\u00e1c m\u1eabu tablet m\u1edbi t\u1ea1i Si\u00eau Th\u1ecb \u0110i\u1ec7n M\u00e1y &#8211; N\u1ed9i Th\u1ea5t Ch\u1ee3 L\u1edbn \u0111\u1ec3 ch\u1ecdn thi\u1ebft b\u1ecb ph\u00f9 h\u1ee3p cho c\u00f4ng vi\u1ec7c v\u00e0 h\u1ecdc t\u1eadp.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u00a0 Khi c\u1ea7n l\u1ea5y ra c\u00e1c gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t trong danh s\u00e1ch s\u1ed1 li\u1ec7u, h\u00e0m SMALL s\u1ebd gi\u00fap b\u1ea1n th\u1ef1c hi\u1ec7n nhanh v\u00e0 ch\u00ednh x\u00e1c. N\u1ed9i dung b\u00e0i vi\u1ebft s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1ch d\u00f9ng h\u00e0m, \u00fd ngh\u0129a t\u1eebng tham s\u1ed1 v\u00e0 c\u00e1c v\u00ed d\u1ee5 \u00e1p d\u1ee5ng tr\u1ef1c quan \u0111\u1ec3 b\u1ea1n x\u1eed l\u00fd d\u1eef li\u1ec7u [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":5046,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[],"class_list":["post-5045","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tro-choi-va-ung-dung"],"jetpack_featured_media_url":"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/11\/19406.jpg","_links":{"self":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts\/5045","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=5045"}],"version-history":[{"count":0,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts\/5045\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/media\/5046"}],"wp:attachment":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/media?parent=5045"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/categories?post=5045"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/tags?post=5045"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}