{"id":5509,"date":"2024-12-16T03:22:40","date_gmt":"2024-12-16T03:22:40","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/16\/tu-dong-cap-nhat-du-lieu-voi-cong-cu-spin-button\/"},"modified":"2024-12-16T03:22:40","modified_gmt":"2024-12-16T03:22:40","slug":"tu-dong-cap-nhat-du-lieu-voi-cong-cu-spin-button","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/16\/tu-dong-cap-nhat-du-lieu-voi-cong-cu-spin-button\/","title":{"rendered":"T\u1ef1 \u0111\u1ed9ng c\u1eadp nh\u1eadt d\u1eef li\u1ec7u v\u1edbi c\u00f4ng c\u1ee5 Spin Button"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Ch\u00fang ta x\u00e9t v\u00ed d\u1ee5 sau\u00a0\u0111\u1ec3 t\u00ecm hi\u1ec3u vi\u1ec7c\u00a0\u1ee9ng d\u1ee5ng c\u1ee7a c\u00f4ng c\u1ee5 Spin Button:<\/p>\n<p>Cho b\u1ea3ng t\u00ednh sau, s\u1eed d\u1ee5ng Spin Button\u00a0\u0111\u1ec3 thay\u00a0\u0111\u1ed5i n\u1ed9i dung c\u1ee7a Phi\u1ebfu Xu\u1ea5t kho t\u01b0\u01a1ng\u00a0\u1ee9ng theo m\u1ed7i s\u1ed1 phi\u1ebfu trong\u00a0b\u1ea3ng k\u00ea<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-13470 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/heo-spin-button-03.png\" width=\"994\" height=\"658\" title=\"heo-spin-button-03\"><\/p>\n<p>C\u00e1c b\u01b0\u1edbc th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/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-675f9cffd3e75\" 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\/tu-dong-cap-nhat-du-lieu-voi-cong-cu-spin-button.html#Tao_cong_cu_Spin_Button\" title=\"T\u1ea1o c\u00f4ng c\u1ee5 Spin Button\">T\u1ea1o c\u00f4ng c\u1ee5 Spin Button<\/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\/tu-dong-cap-nhat-du-lieu-voi-cong-cu-spin-button.html#Xay_dung_cong_thuc_lien_ket_du_lieu_theo_Spin_Button\" title=\"X\u00e2y d\u1ef1ng c\u00f4ng th\u1ee9c li\u00ean k\u1ebft d\u1eef li\u1ec7u theo Spin Button\">X\u00e2y d\u1ef1ng c\u00f4ng th\u1ee9c li\u00ean k\u1ebft d\u1eef li\u1ec7u theo Spin Button<\/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\/tu-dong-cap-nhat-du-lieu-voi-cong-cu-spin-button.html#Ket_luan\" title=\"K\u1ebft lu\u1eadn\">K\u1ebft lu\u1eadn<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Tao_cong_cu_Spin_Button\"><\/span>T\u1ea1o c\u00f4ng c\u1ee5 Spin Button<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Spin Button c\u00f2n\u00a0\u0111\u01b0\u1ee3c g\u1ecdi v\u1edbi t\u00ean kh\u00e1c l\u00e0 \u201cN\u00fat b\u1ea5m Up &amp; Down\u201d, s\u1eed d\u1ee5ng v\u1edbi m\u1ee5c\u00a0\u0111\u00edch\u00a0\u0111\u1ec3 m\u1ed7i l\u1ea7n b\u1ea5m n\u00fat Up s\u1ebd t\u0103ng gi\u00e1 tr\u1ecb l\u00ean 1\u00a0\u0111\u01a1n v\u1ecb, b\u1ea5m n\u00fat Down s\u1ebd gi\u1ea3m gi\u00e1 tr\u1ecb xu\u1ed1ng 1\u00a0\u0111\u01a1n v\u1ecb<\/p>\n<p>Spin Button \u0111\u01b0\u1ee3c t\u1ea1o nh\u01b0 sau:<\/p>\n<p>M\u1edf tab Developer tr\u00ean thanh c\u00f4ng c\u1ee5 (Click chu\u1ed9t ph\u1ea3i v\u00e0o thanh c\u00f4ng c\u1ee5, ch\u1ecdn m\u1ee5c Customize the Ribbon, trong m\u1ee5c n\u00e0y\u00a0\u0111\u00e1nh d\u1ea5u ch\u1ecdn v\u00e0o th\u1ebb Developer)<\/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-478.gif\" title=\"ex101_92019-nho-478\"><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-196.gif\" title=\"vba101_92019-nho-196\"><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-478.gif\" title=\"ex101_92019-nho-478\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-13466 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/heo-mo-the-developer.png\" width=\"1030\" height=\"847\" title=\"heo-mo-the-developer\"><\/p>\n<p>Trong tab\u00a0Developer tr\u00ean thanh c\u00f4ng c\u1ee5, b\u1ea5m ch\u1ecdn m\u1ee5c\u00a0Insert, ch\u1ecdn t\u1edbi ch\u1ee9c n\u0103ng Spin Button r\u1ed3i\u00a0\u0111\u1eb7t t\u1edbi v\u1ecb tr\u00ed b\u1ea5t k\u1ef3 trong Sheet. L\u01b0u\u00a0\u00fd n\u1ebfu v\u1ebd Spin theo chi\u1ec1u ngang th\u00ec 2 n\u00fat m\u0169i t\u00ean s\u1ebd h\u01b0\u1edbng Tr\u00e1i-Ph\u1ea3i, c\u00f2n v\u1ebd chi\u1ec1u d\u1ecdc th\u00ec 2 n\u00fat m\u0169i t\u00ean s\u1ebd h\u01b0\u1edbng Tr\u00ean-D\u01b0\u1edbi.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-13467 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/heo-spin-button-01.png\" width=\"772\" height=\"444\" title=\"heo-spin-button-01\"><\/p>\n<p>\u00a0<\/p>\n<p>Sau khi t\u1ea1o\u00a0\u0111\u01b0\u1ee3c c\u00f4ng c\u1ee5 Spin Button, ch\u00fang ta thi\u1ebft l\u1eadp n\u01a1i Link d\u1eef li\u1ec7u k\u1ebft qu\u1ea3 c\u1ee7a n\u00fat Spin:<\/p>\n<p>Trong Tab Developer &gt; Ch\u1ecdn Design Mode &gt; Click chu\u1ed9t ph\u1ea3i v\u00e0o Spin button v\u00e0 ch\u1ecdn Properties &gt; Trong c\u1eeda s\u1ed5 Properties ch\u00fa\u00a0\u00fd m\u1ee5c LinkedCell. T\u1ea1i\u00a0\u0111\u00e2y b\u1ea1n ch\u1ecdn n\u01a1i mu\u1ed1n li\u00ean k\u1ebft t\u1edbi v\u1ecb tr\u00ed\u00a0\u0111\u1eb7t k\u1ebft qu\u1ea3.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-13471 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/heo-spin-button-04.png\" width=\"658\" height=\"526\" title=\"heo-spin-button-04\"><\/p>\n<p>N\u1ebfu LinkedCell t\u1edbi sheet kh\u00e1c th\u00ec ph\u1ea3i k\u00e8m theo t\u00ean Sheet v\u00e0 v\u1ecb tr\u00ed Cell trong Sheet\u00a0\u0111\u00f3.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Xay_dung_cong_thuc_lien_ket_du_lieu_theo_Spin_Button\"><\/span>X\u00e2y d\u1ef1ng c\u00f4ng th\u1ee9c li\u00ean k\u1ebft d\u1eef li\u1ec7u theo Spin Button<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><strong>B\u01b0\u1edbc 1:\u00a0\u0110\u00e1nh gi\u00e1\u00a0\u0111\u1eb7c\u00a0\u0111i\u1ec3m d\u1eef li\u1ec7u c\u1ee7a Spin Button<\/strong><\/p>\n<p>Spin button cho ta c\u00e1c s\u1ed1 t\u1ef1 nhi\u00ean li\u00ean ti\u1ebfp, b\u1eaft\u00a0\u0111\u1ea7u t\u1eeb 0.<\/p>\n<p>Khi b\u1ea5m n\u00fat Up (m\u0169i t\u00ean\u00a0\u0111i l\u00ean ho\u1eb7c sang ph\u1ea3i) th\u00ec k\u1ebft qu\u1ea3 t\u0103ng l\u00ean 1<\/p>\n<p>Khi b\u1ea5m n\u00fat Down (m\u0169i t\u00ean\u00a0\u0111i xu\u1ed1ng ho\u1eb7c sang tr\u00e1i) th\u00ec k\u1ebft qu\u1ea3 gi\u1ea3m\u00a0\u0111i 1<\/p>\n<p>Do\u00a0\u0111\u00f3 ch\u00fang ta ph\u1ea3i d\u1ef1a v\u00e0o\u00a0\u0111\u1eb7c\u00a0\u0111i\u1ec3m n\u00e0y\u00a0\u0111\u1ec3 x\u00e2y d\u1ef1ng c\u00f4ng th\u1ee9c l\u1ea5y d\u1eef li\u1ec7u t\u1eeb B\u1ea3ng k\u00ea v\u00e0o PXK<\/p>\n<p><strong>B\u01b0\u1edbc 2: T\u1ea1o c\u1ed9t ph\u1ee5 cho b\u1ea3ng k\u00ea<\/strong><\/p>\n<p>D\u1ef1a theo\u00a0\u0111\u1eb7c\u00a0\u0111i\u1ec3m c\u1ee7a b\u1ea3ng d\u1eef li\u1ec7u ch\u00fang ta s\u1ebd x\u00e2y d\u1ef1ng c\u00f4ng th\u1ee9c cho ph\u00f9 h\u1ee3p.<\/p>\n<p>V\u1edbi b\u1ea3ng d\u1eef li\u1ec7u n\u00e0y c\u00f3\u00a0\u0111\u1eb7c\u00a0\u0111i\u1ec3m: M\u1ed7i phi\u1ebfu g\u1ed3m nhi\u1ec1u d\u00f2ng, m\u1ed7i d\u00f2ng kh\u00e1c nhau\u00a0\u1edf T\u00ean h\u00e0ng v\u00e0 S\u1ed1 l\u01b0\u1ee3ng, c\u00f2n c\u00e1c\u00a0\u0111\u1ed1i t\u01b0\u1ee3ng S\u1ed1 phi\u1ebfu, Ng\u00e0y, Kh\u00e1ch h\u00e0ng l\u00e0 gi\u1ed1ng nhau.<\/p>\n<p>=&gt; 1 c\u1ed9t d\u00f9ng\u00a0\u0111\u1ec3 ph\u00e2n chia th\u1ee9 t\u1ef1 c\u00e1c phi\u1ebfu v\u1edbi nhau (C\u1ed9t Th\u1ee9 t\u1ef1 phi\u1ebfu)<\/p>\n<p>Di\u1ec5n gi\u1ea3i t\u00ednh logic: N\u1ebfu d\u00f2ng s\u1ed1 phi\u1ebfu\u00a0\u0111ang x\u00e9t = s\u1ed1 phi\u1ebfu t\u1ea1i d\u00f2ng tr\u01b0\u1edbc\u00a0\u0111\u00f3 th\u00ec th\u1ee9 t\u1ef1 phi\u1ebfu kh\u00f4ng\u00a0\u0111\u1ed5i; n\u1ebfu kh\u00e1c th\u00ec s\u1ebd t\u0103ng s\u1ed1 th\u1ee9 t\u1ef1 l\u00ean 1\u00a0\u0111\u01a1n v\u1ecb (gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t c\u1ee7a v\u00f9ng tr\u01b0\u1edbc\u00a0\u0111\u00f3 + 1)<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-13472 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/heo-spin-button-05.png\" width=\"682\" height=\"359\" title=\"heo-spin-button-05\"><\/p>\n<p>=&gt; 1 c\u1ed9t d\u00f9ng\u00a0\u0111\u1ec3 ph\u00e2n chia t\u1eebng d\u00f2ng ph\u00e1t sinh trong m\u1ed7i phi\u1ebfu (C\u1ed9t Th\u1ee9 t\u1ef1 d\u00f2ng)<\/p>\n<p>Di\u1ec5n gi\u1ea3i t\u00ednh Logic:\u00a0\u0110\u1ebfm s\u1ed1 l\u1ea7n l\u1eb7p l\u1ea1i c\u1ee7a s\u1ed1 phi\u1ebfu trong v\u00f9ng t\u1eeb v\u1ecb tr\u00ed ban\u00a0\u0111\u1ea7u t\u1edbi v\u1ecb tr\u00ed s\u1ed1\u00a0phi\u1ebfu\u00a0\u1edf d\u00f2ng\u00a0\u0111ang x\u00e9t.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-13473 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/heo-spin-button-06.png\" width=\"701\" height=\"334\" title=\"heo-spin-button-06\"><\/p>\n<p><strong>B\u01b0\u1edbc 3: X\u00e2y d\u1ef1ng c\u00f4ng th\u1ee9c l\u1ea5y d\u1eef li\u1ec7u trong Phi\u1ebfu Xu\u1ea5t kho<\/strong><\/p>\n<p>\u1ee8ng d\u1ee5ng h\u00e0m Index +Match\u00a0\u0111\u1ec3 l\u1ea5y d\u1eef li\u1ec7u, v\u00ec\u00a0\u0111i\u1ec1u ki\u1ec7n x\u00e9t l\u00e0 gi\u00e1 tr\u1ecb c\u1ee7a n\u00fat Spin t\u01b0\u01a1ng\u00a0\u1ee9ng v\u1edbi c\u1ed9t Th\u1ee9 t\u1ef1 phi\u1ebfu. N\u1ebfu x\u00e9t b\u1eb1ng h\u00e0m Vlookup s\u1ebd kh\u00f4ng t\u00ednh\u00a0\u0111\u01b0\u1ee3c.<\/p>\n<p><strong>Gi\u00e1 tr\u1ecb Ng\u00e0y c\u1ee7a PXK (\u00f4 K2)<\/strong><\/p>\n<blockquote>\n<p>=\u00a0INDEX(B1:B26,MATCH(M2,F1:F26,0))<\/p>\n<\/blockquote>\n<p>Trong\u00a0\u0111\u00f3:<\/p>\n<ul>\n<li>B1:B26 l\u00e0 c\u1ed9t Ng\u00e0y c\u1ee7a B\u1ea3ng k\u00ea<\/li>\n<li>F1:F26 l\u00e0 c\u1ed9t Th\u1ee9 t\u1ef1 phi\u1ebfu c\u1ee7a B\u1ea3ng k\u00ea<\/li>\n<li>M2 l\u00e0 gi\u00e1 tr\u1ecb c\u1ee7a SpinButton<\/li>\n<\/ul>\n<p><strong>Ng\u01b0\u1eddi mua h\u00e0ng (\u00f4 K3)<\/strong><\/p>\n<blockquote>\n<p>=\u00a0INDEX(C1:C26,MATCH(M2,F1:F26,0))<\/p>\n<\/blockquote>\n<p>Thay\u00a0\u0111\u1ed5i\u00a0\u0111\u1ed1i t\u01b0\u1ee3ng trong h\u00e0m Index, x\u00e9t t\u1edbi c\u1ed9t C l\u00e0 c\u1ed9t Ng\u01b0\u1eddi mua h\u00e0ng, c\u00f2n n\u1ed9i dung h\u00e0m Match kh\u00f4ng thay\u00a0\u0111\u1ed5i<\/p>\n<p><strong>C\u00f4ng th\u1ee9c l\u1ea5y T\u00ean h\u00e0ng<\/strong>:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-13474 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/heo-spin-button-07.png\" width=\"1156\" height=\"698\" title=\"heo-spin-button-07\"><\/p>\n<p>T\u1ea1i\u00a0\u0111\u00e2y ch\u00fang ta s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c m\u1ea3ng\u00a0\u0111\u1ec3 x\u00e9t h\u00e0m Index + Match v\u1edbi nhi\u1ec1u\u00a0\u0111i\u1ec1u ki\u1ec7n. C\u1ee5 th\u1ec3 l\u00e0 g\u1ed3m 2\u00a0\u0111i\u1ec1u ki\u1ec7n:<\/p>\n<ul>\n<li>Th\u1ee9 t\u1ef1 phi\u1ebfu = gi\u00e1 tr\u1ecb c\u1ee7a Spin Button<\/li>\n<li>Th\u1ee9 t\u1ef1 d\u00f2ng = gi\u00e1 tr\u1ecb c\u1ee7a c\u1ed9t STT<\/li>\n<\/ul>\n<p>Do\u00a0\u0111\u00f3 c\u00e1c n\u1ed9i dung trong c\u00f4ng th\u1ee9c nh\u01b0 sau:<\/p>\n<blockquote>\n<p>=IFERROR(INDEX(D1:D26,MATCH(M2&amp;$I$6:$I$20,F1:F26&amp;G1:G26,0)),\u201d\u201d)\u00a0 \u00a0K\u1ebft th\u00fac b\u1eb1ng l\u1ec7nh Ctrl+Shift+Enter<\/p>\n<\/blockquote>\n<ul>\n<li>D1:D26 l\u00e0 c\u1ed9t T\u00ean h\u00e0ng trong b\u1ea3ng k\u00ea<\/li>\n<li>M2&amp;I6:I20 l\u00e0 gh\u00e9p gi\u1eefa 2\u00a0\u0111i\u1ec1u ki\u1ec7n Gi\u00e1 tr\u1ecb c\u1ee7a Spin Button v\u1edbi gi\u00e1 tr\u1ecb c\u1ee7a c\u1ed9t STT<\/li>\n<li>F1:F26&amp;G1:G26 l\u00e0 gh\u00e9p gi\u1eefa 2 c\u1ed9t Th\u1ee9 t\u1ef1 phi\u1ebfu v\u00e0 Th\u1ee9 t\u1ef1 d\u00f2ng trong ph\u1ea7n c\u1ed9t ph\u1ee5 c\u1ee7a\u00a0b\u1ea3ng k\u00ea<\/li>\n<li>H\u00e0m\u00a0IFERROR\u00a0\u0111\u1ec3 x\u1eed l\u00fd nh\u1eefng n\u1ed9i dung l\u1ed7i (kh\u00f4ng c\u00f3 ph\u00e1t sinh, kh\u00f4ng t\u00ecm th\u1ea5y k\u1ebft qu\u1ea3 th\u00ec s\u1ebd b\u00e1o l\u1ed7i #NA) =&gt; N\u1ebfu l\u1ed7i th\u00ec tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb l\u00e0 \u201c\u201d<\/li>\n<\/ul>\n<p>T\u01b0\u01a1ng t\u1ef1 nh\u01b0 v\u1eady ch\u00fang ta x\u00e2y d\u1ef1ng c\u00f4ng th\u1ee9c cho ph\u1ea7n\u00a0S\u1ed1 l\u01b0\u1ee3ng, trong\u00a0\u0111\u00f3 v\u1eabn s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c m\u1ea3ng gi\u1ed1ng T\u00ean h\u00e0ng, nh\u01b0ng\u00a0\u0111\u1ed1i t\u01b0\u1ee3ng l\u00e0 E1:E26 cho c\u1ed9t S\u1ed1 l\u01b0\u1ee3ng<\/p>\n<blockquote>\n<p>=IFERROR(INDEX(E1:E26,MATCH(M2&amp;$I$6:$I$20,F1:F26&amp;G1:G26,0)),\u201d\u201d)<\/p>\n<\/blockquote>\n<h2><span class=\"ez-toc-section\" id=\"Ket_luan\"><\/span>K\u1ebft lu\u1eadn<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Nh\u01b0 v\u1eady ch\u00fang ta\u00a0\u0111\u00e3 th\u1ea5y\u00a0\u0111\u01b0\u1ee3c t\u00ednh\u00a0\u1ee9ng d\u1ee5ng c\u1ee7a c\u00f4ng c\u1ee5 Spin Button r\u1ea5t h\u1eefu\u00a0\u00edch trong vi\u1ec7c tr\u00edch xu\u1ea5t d\u1eef li\u1ec7u theo nh\u1eefng s\u1ed1 phi\u1ebfu li\u00ean ti\u1ebfp. Ch\u1ec9 c\u1ea7n k\u1ebft h\u1ee3p v\u1edbi\u00a0h\u00e0m Index+Match l\u00e0 ch\u00fang ta\u00a0\u0111\u00e3 c\u00f3 th\u1ec3 l\u1ecdc d\u1eef li\u1ec7u t\u1eeb b\u1ea3ng k\u00ea ra c\u00e1c phi\u1ebfu 1 c\u00e1ch d\u1ec5 d\u00e0ng.<\/p>\n<p><strong>\u1ee8ng d\u1ee5ng<\/strong>: C\u00f3 th\u1ec3 \u1ee9ng d\u1ee5ng n\u1ed9i dung n\u00e0y v\u00e0o vi\u1ec7c qu\u1ea3n l\u00fd c\u00e1c \u0111\u1ed1i t\u01b0\u1ee3ng:<\/p>\n<ul>\n<li>Qu\u1ef9 : Phi\u1ebfu thu, chi,<\/li>\n<li>Kho: Phi\u1ebfu nh\u1eadp kho, xu\u1ea5t kho<\/li>\n<li>\u0110\u1ed1i t\u01b0\u1ee3ng kh\u00e1c: H\u00f3a\u00a0\u0111\u01a1n, h\u1ee3p\u00a0\u0111\u1ed3ng<\/li>\n<li>Danh s\u00e1ch khen th\u01b0\u1edfng, t\u1eb7ng qu\u00e0<\/li>\n<li>\u0110\u01a1n\u00a0\u0111\u1eb7t h\u00e0ng<\/li>\n<\/ul>\n<p>T\u1ea3i v\u1ec1 file m\u1eabu t\u1ea1i\u00a0\u0111\u1ecba ch\u1ec9:\u00a0<a href=\"http:\/\/bit.ly\/2mDUJ2v\">http:\/\/bit.ly\/2mDUJ2v<\/a><\/p>\n<p>R\u1ea5t nhi\u1ec1u ki\u1ebfn th\u1ee9c ph\u1ea3i kh\u00f4ng n\u00e0o? Nh\u1eefng ki\u1ebfn th\u1ee9c \u1edf Excel kh\u00f4ng kh\u00f3. Nh\u01b0ng n\u1ebfu b\u1ea1n kh\u00f4ng h\u1ec7 th\u1ed1ng v\u00e0 t\u1ed5ng h\u1ee3p, c\u0169ng nh\u01b0 r\u00e8n luy\u1ec7n th\u01b0\u1eddng xuy\u00ean th\u00ec s\u1ebd kh\u00f4ng t\u1eadn d\u1ee5ng t\u1ed1i \u0111a t\u00ednh n\u0103ng c\u1ee7a Excel. To\u00e0n b\u1ed9 nh\u1eefng ki\u1ebfn th\u1ee9c n\u00e0y c\u00e1c b\u1ea1n \u0111\u1ec1u c\u00f3 th\u1ec3 h\u1ecdc \u0111\u01b0\u1ee3c trong kh\u00f3a h\u1ecdc\u00a0<a href=\"http:\/\/bit.ly\/2w6YAe8\">EX101 \u2013 Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi chuy\u00ean gia<\/a>\u00a0c\u1ee7a H\u1ecdc Excel Online. \u0110\u00e2y l\u00e0 kh\u00f3a h\u1ecdc gi\u00fap b\u1ea1n h\u1ec7 th\u1ed1ng ki\u1ebfn th\u1ee9c m\u1ed9t c\u00e1ch \u0111\u1ea7y \u0111\u1ee7, chi ti\u1ebft. H\u01a1n n\u1eefa kh\u00f4ng h\u1ec1 c\u00f3 gi\u1edbi h\u1ea1n v\u1ec1 th\u1eddi gian h\u1ecdc t\u1eadp n\u00ean b\u1ea1n c\u00f3 th\u1ec3 tho\u1ea3i m\u00e1i h\u1ecdc b\u1ea5t c\u1ee9 l\u00fac n\u00e0o, d\u1ec5 d\u00e0ng tra c\u1ee9u l\u1ea1i ki\u1ebfn th\u1ee9c khi c\u1ea7n. Hi\u1ec7n nay h\u1ec7 th\u1ed1ng \u0111ang c\u00f3 \u01b0u \u0111\u00e3i r\u1ea5t l\u1edbn cho b\u1ea1n khi \u0111\u0103ng k\u00fd tham gia kh\u00f3a h\u1ecdc. Chi ti\u1ebft xem t\u1ea1i: <a href=\"https:\/\/hocexcel.online\" target=\"_blank\">HocExcel.Online<\/a><\/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-478.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":5510,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-5509","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\/5509","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=5509"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/5509\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/5510"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=5509"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=5509"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=5509"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}