{"id":7032,"date":"2024-12-21T16:44:17","date_gmt":"2024-12-21T16:44:17","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/kiem-tra-ma-hang-hoa-bi-trung-trong-quan-ly-kho\/"},"modified":"2024-12-21T16:44:17","modified_gmt":"2024-12-21T16:44:17","slug":"kiem-tra-ma-hang-hoa-bi-trung-trong-quan-ly-kho","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/kiem-tra-ma-hang-hoa-bi-trung-trong-quan-ly-kho\/","title":{"rendered":"Ki\u1ec3m tra m\u00e3 h\u00e0ng h\u00f3a b\u1ecb tr\u00f9ng trong qu\u1ea3n l\u00fd kho"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\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-6766f060b963f\" 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\/kiem-tra-ma-hang-hoa-bi-trung-trong-quan-ly-kho.html#1_Tam_quan_trong\" title=\"1. T\u1ea7m quan tr\u1ecdng\">1. T\u1ea7m quan tr\u1ecdng<\/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\/kiem-tra-ma-hang-hoa-bi-trung-trong-quan-ly-kho.html#2_Ket_qua_can_dat_duoc\" title=\"2.\u00a0K\u1ebft qu\u1ea3 c\u1ea7n \u0111\u1ea1t \u0111\u01b0\u1ee3c\">2.\u00a0K\u1ebft qu\u1ea3 c\u1ea7n \u0111\u1ea1t \u0111\u01b0\u1ee3c<\/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\/kiem-tra-ma-hang-hoa-bi-trung-trong-quan-ly-kho.html#3_Cach_lam\" title=\"3. C\u00e1ch l\u00e0m\">3. C\u00e1ch l\u00e0m<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/kiem-tra-ma-hang-hoa-bi-trung-trong-quan-ly-kho.html#4_Nhan_xet\" title=\"4. Nh\u1eadn x\u00e9t\">4. Nh\u1eadn x\u00e9t<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"1_Tam_quan_trong\"><\/span>1. T\u1ea7m quan tr\u1ecdng<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u2013 Khi qu\u1ea3n l\u00fd kho h\u00e0ng h\u00f3a v\u1edbi nhi\u1ec1u m\u1eb7t h\u00e0ng, vi\u1ec7c nh\u1ea7m l\u1eabn, tr\u00f9ng l\u1eb7p khi th\u00eam m\u00e3 h\u00e0ng m\u1edbi v\u00e0o kho l\u00e0 r\u1ea5t d\u1ec5 x\u1ea3y ra.<\/p>\n<p>\u2013 T\u00e1c h\u1ea1i c\u1ee7a vi\u1ec7c x\u1ea3y ra m\u00e3 tr\u00f9ng: M\u1ed9t s\u1ed1 c\u00f4ng th\u1ee9c hay d\u00f9ng trong excel s\u1ebd g\u1eb7p l\u1ed7i ho\u1eb7c t\u00ednh sai khi \u0111i\u1ec1u ki\u1ec7n t\u00ednh to\u00e1n b\u1ecb tr\u00f9ng (h\u00e0m vlookup s\u1ebd b\u00e1o l\u1ed7i, h\u00e0m sumif\/sumifs s\u1ebd b\u1ecb t\u00ednh tr\u00f9ng, g\u1ea5p b\u1ed9i d\u1eef li\u1ec7u d\u1eabn t\u1edbi k\u1ebft qu\u1ea3 sai)<\/p>\n<p>\u2013 L\u1eabn l\u1ed9n gi\u1eefa c\u00e1c nghi\u1ec7p v\u1ee5. Ghi ch\u00e9p sai l\u1ec7ch d\u1eabn t\u1edbi t\u00ednh to\u00e1n sai, ki\u1ec3m k\u00ea sai =&gt; k\u1ebft qu\u1ea3 c\u00f4ng vi\u1ec7c kh\u00f4ng \u0111\u1ea1t.<\/p>\n<p>\u2013 Kh\u00f4ng ki\u1ec3m so\u00e1t ngay t\u1eeb \u0111\u1ea7u, khi g\u1eb7p sai s\u00f3t s\u1ebd r\u1ea5t m\u1ea5t th\u1eddi gian \u0111\u1ec3 r\u00e0 so\u00e1t l\u1ed7i v\u00e0 s\u1eeda l\u1ed7i =&gt; m\u1ea5t th\u1eddi gian v\u00e0 t\u00e2m l\u00fd \u1ee9c ch\u1ebf =&gt; Hi\u1ec7u qu\u1ea3 c\u00f4ng vi\u1ec7c b\u1ecb gi\u1ea3m.<\/p>\n<p>=&gt; N\u00f3i chung l\u00e0 h\u1eadu qu\u1ea3 r\u1ea5t tai h\u1ea1i. Vi\u1ec7c quan tr\u1ecdng th\u1ebf n\u00e0y th\u00ec bi\u1ebft c\u00e0ng s\u1edbm, l\u00e0m c\u00e0ng s\u1edbm c\u00e0ng t\u1ed1t. Mu\u1ed1n l\u00e0m \u0111\u01b0\u1ee3c th\u00ec ph\u1ea3i bi\u1ebft c\u00e1ch l\u00e0m \u0111\u00e3.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"2_Ket_qua_can_dat_duoc\"><\/span>2.\u00a0K\u1ebft qu\u1ea3 c\u1ea7n \u0111\u1ea1t \u0111\u01b0\u1ee3c<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>V\u00ed d\u1ee5 ta c\u00f3 b\u1ea3ng danh m\u1ee5c h\u00e0ng h\u00f3a nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-8064 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/1_dmhh.jpg\" width=\"637\" height=\"433\" title=\"1_dmhh\"><\/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\/2024\/12\/ex101_92019-nho-633.gif\" title=\"ex101_92019-nho-633\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><em><strong>C\u00e1ch 1<\/strong><\/em>: \u0110\u1ebfm t\u1ed5ng s\u1ed1 l\u1ea7n xu\u1ea5t hi\u1ec7n c\u1ee7a 1 m\u00e3 h\u00e0ng trong to\u00e0n b\u1ed9 danh m\u1ee5c h\u00e0ng. N\u1ebfu l\u1edbn h\u01a1n 1 t\u1ee9c l\u00e0 m\u00e3 \u0111\u00f3 tr\u00f9ng (kh\u00f4ng r\u00f5 b\u1eaft \u0111\u1ea7u tr\u00f9ng t\u1eeb khi n\u00e0o)<\/p>\n<p><em><strong>C\u00e1ch 2<\/strong><\/em>:\u00a0\u0110\u1ebfm s\u1ed1 l\u1ea7n xu\u1ea5t hi\u1ec7n c\u1ee7a 1 m\u00e3 h\u00e0ng trong to\u00e0n b\u1ed9 danh m\u1ee5c h\u00e0ng. T\u1ea1i v\u1ecb tr\u00ed c\u00f3 k\u1ebft qu\u1ea3 l\u1edbn h\u01a1n 1 t\u1ee9c l\u00e0 m\u00e3 \u0111\u00f3 b\u1eaft \u0111\u1ea7u tr\u00f9ng (c\u00e1c v\u1ecb tr\u00ed c\u00f3 gi\u00e1 tr\u1ecb b\u1eb1ng 1 l\u00e0 ch\u01b0a tr\u00f9ng)<\/p>\n<h2><span class=\"ez-toc-section\" id=\"3_Cach_lam\"><\/span>3. C\u00e1ch l\u00e0m<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>V\u00ec m\u1ee5c \u0111\u00edch l\u00e0 \u201c\u0110\u1ebfm\u201d v\u00e0 c\u00f3 k\u00e8m theo \u201c\u0111i\u1ec1u ki\u1ec7n\u201d l\u00e0 m\u00e3 h\u00e0ng, n\u00ean ta s\u1eed d\u1ee5ng h\u00e0m COUNTIF<\/p>\n<ul style=\"list-style-type: disc\">\n<li>C\u1ea5u tr\u00fac h\u00e0m countif:<\/li>\n<\/ul>\n<blockquote>\n<p>=Countif(range,criteria)<\/p>\n<p>Range: V\u00f9ng ch\u1ee9a n\u1ed9i dung c\u1ea7n \u0111\u1ebfm<\/p>\n<p>Criteria: \u0110i\u1ec1u ki\u1ec7n \u0111\u1ebfm<\/p>\n<\/blockquote>\n<ul>\n<li>K\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m:<\/li>\n<\/ul>\n<p>=0: Trong range kh\u00f4ng c\u00f3 ch\u1ee9a Criteria<\/p>\n<p>&gt;0: \u0110i\u1ec1u ki\u1ec7n \u0111\u1ebfm c\u00f3 xu\u1ea5t hi\u1ec7n trong v\u00f9ng c\u1ea7n \u0111\u1ebfm (trong Range c\u00f3 \u00edt nh\u1ea5t 1 \u00f4 ch\u1ee9a Criteria)<\/p>\n<p><strong>C\u00e1ch 1:<\/strong><\/p>\n<p>\u0110\u1eb7t c\u00f4ng th\u1ee9c t\u1ea1i \u00f4 E5=Countif($B$5:$B$20,B5) \u00a0 =&gt; Filldown c\u00f4ng th\u1ee9c E5 xu\u1ed1ng t\u1edbi E20<\/p>\n<p>Nh\u1eefng \u00f4 cho k\u1ebft qu\u1ea3 l\u00e0 1 th\u00ec hi\u1ec3u l\u00e0 M\u00e3 t\u01b0\u01a1ng \u1ee9ng \u1edf c\u1ed9t B kh\u00f4ng tr\u00f9ng (Ch\u1ec9 xu\u1ea5t hi\u1ec7n 1 l\u1ea7n)<\/p>\n<p>Nh\u1eefng \u00f4 cho k\u1ebft qu\u1ea3 &gt;1 th\u00ec hi\u1ec3u l\u00e0 M\u00e3 t\u01b0\u01a1ng \u1ee9ng \u1edf c\u1ed9t B c\u00f3 tr\u00f9ng (S\u1ed1 l\u1ea7n xu\u1ea5t hi\u1ec7n &gt;1)<\/p>\n<p><strong><em>C\u00e1ch 2:<\/em><\/strong><\/p>\n<p>\u0110\u1eb7t c\u00f4ng th\u1ee9c t\u1ea1i \u00f4\u00a0F5 = Countif($B$5:$B5,B5) =&gt; Filldown c\u00f4ng th\u1ee9c F5 xu\u1ed1ng t\u1edbi F20<\/p>\n<p>Nh\u1eefng \u00f4 cho k\u1ebft qu\u1ea3 l\u00e0 1 th\u00ec hi\u1ec3u l\u00e0 nh\u1eefng m\u00e3 kh\u00f4ng tr\u00f9ng \/ ch\u01b0a b\u1ecb tr\u00f9ng l\u1eb7p<\/p>\n<p>Nh\u1eefng \u00f4 cho k\u1ebft qu\u1ea3 &gt;1 th\u00ec hi\u1ec3u l\u00e0 t\u1ea1i h\u00e0ng \u0111\u00f3, m\u00e3 \u0111\u00f3 \u0111\u00e3 b\u1ecb tr\u00f9ng so v\u1edbi 1 m\u00e3 tr\u01b0\u1edbc \u0111\u00e3 c\u00f3 t\u1eeb tr\u01b0\u1edbc<\/p>\n<p>*\u00a0<strong><em>S\u1ef1 kh\u00e1c bi\u1ec7t \u1edf vi\u1ec7c thi\u1ebft l\u1eadp to\u1ea1 \u0111\u1ed9 cho Range.\u00a0Ch\u1ec9 c\u1ed1 \u0111\u1ecbnh \u0111i\u1ec3m b\u1eaft \u0111\u1ea7u, c\u00f2n \u0111i\u1ec3m cu\u1ed1i kh\u00f4ng c\u1ed1 \u0111\u1ecbnh, cho ph\u00e9p m\u1edf r\u1ed9ng khi filldown c\u00f4ng th\u1ee9c<\/em><\/strong><\/p>\n<h2><span class=\"ez-toc-section\" id=\"4_Nhan_xet\"><\/span>4. Nh\u1eadn x\u00e9t<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u2013 V\u1edbi c\u00e1ch 1, ta ch\u1ec9 x\u00e1c \u0111\u1ecbnh \u0111\u01b0\u1ee3c m\u00e3 n\u00e0o tr\u00f9ng, m\u00e0 kh\u00f4ng r\u00f5 khi n\u00e0o n\u00f3 b\u1eaft \u0111\u1ea7u tr\u00f9ng. D\u00f9ng cho m\u1ee5c \u0111\u00edch duy nh\u1ea5t l\u00e0 ch\u1ec9 ra m\u00e3 n\u00e0o tr\u00f9ng<\/p>\n<p>\u2013 V\u1edbi c\u00e1ch 2, x\u00e1c \u0111\u1ecbnh \u0111\u01b0\u1ee3c khi n\u00e0o b\u1eaft \u0111\u1ea7u tr\u00f9ng. D\u00f9ng cho m\u1ee5c \u0111\u00edch: gi\u1eef l\u1ea1i m\u00e3 ch\u01b0a b\u1ecb tr\u00f9ng, ph\u00e2n bi\u1ec7t c\u00e1c m\u00e3 b\u1ecb tr\u00f9ng \u0111\u1ec3 lo\u1ea1i b\u1ecf<\/p>\n<p>\u2013\u00a0Tu\u1ef3 nhu c\u1ea7u s\u1eed d\u1ee5ng m\u00e0 ta c\u00f3 th\u1ec3 thi\u1ebft l\u1eadp c\u00e1ch ph\u00e2n bi\u1ec7t m\u00e3 tr\u00f9ng cho ph\u00f9 h\u1ee3p.<\/p>\n<p>\u00a0<\/p>\n<p><strong>N\u1ed9i dung n\u00e0y l\u00e0 m\u1ed9t ph\u1ea7n c\u1ee7a kho\u00e1 h\u1ecdc <span style=\"text-decoration: underline\"><a href=\"https:\/\/hocexcel.online\/course\/preview\/im101-tu-tao-phan-mem-quan-ly-kho-voi-excel-va-vba\">IM101 \u2013 T\u1ef1 t\u1ea1o ph\u1ea7n m\u1ec1m qu\u1ea3n l\u00fd kho v\u1edbi Excel v\u00e0 VBA<\/a><\/span>.<\/strong><\/p>\n<p><strong>\u0110\u1ec3 bi\u1ebft th\u00eam c\u00e1c ki\u1ebfn th\u1ee9c, k\u1ef9 thu\u1eadt qu\u1ea3n l\u00fd kho trong excel, b\u1ea1n h\u00e3y tham kh\u1ea3o th\u00eam n\u1ed9i dung c\u1ee7a c\u1ea3 kho\u00e1 h\u1ecdc \u0111\u1ec3 bi\u1ebft \u0111\u01b0\u1ee3c \u0111i\u1ec1u b\u1ed5 \u00edch h\u01a1n cho b\u1ea3n th\u00e2n.<\/strong><\/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\/2024\/12\/ex101_92019-nho-633.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":7033,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-7032","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\/7032","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=7032"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/7032\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/7033"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=7032"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=7032"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=7032"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}