{"id":12123,"date":"2025-01-15T07:14:47","date_gmt":"2025-01-15T07:14:47","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/ham-dmin-huong-dan-su-dung-ham-dmin-trong-excel\/"},"modified":"2025-01-15T07:14:47","modified_gmt":"2025-01-15T07:14:47","slug":"ham-dmin-huong-dan-su-dung-ham-dmin-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/ham-dmin-huong-dan-su-dung-ham-dmin-trong-excel\/","title":{"rendered":"H\u00e0m DMIN, H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m DMIN trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\"><em><strong>H\u00e0m DMIN \u2013 H\u00e0m tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t v\u1edbi \u0111i\u1ec1u ki\u1ec7n \u0111\u01b0\u1ee3c x\u00e1c \u0111\u1ecbnh tr\u01b0\u1edbc trong 1 c\u01a1 s\u1edf d\u1eef li\u1ec7u c\u1ee7a b\u1ea3ng t\u00ednh Excel.<\/strong><\/em><\/p>\n<p style=\"text-align: justify\"><strong>C\u00fa ph\u00e1p:<\/strong> =<strong>DMIN(database, field, criteria)<\/strong>.<\/p>\n<p style=\"text-align: justify\"><em>Trong \u0111\u00f3:<\/em><\/p>\n<ul>\n<li style=\"text-align: justify\"><strong><em>database<\/em>:<\/strong> L\u00e0 c\u01a1 s\u1edf d\u1eef li\u1ec7u.\u00a0C\u01a1 s\u1edf d\u1eef li\u1ec7u \u1edf \u0111\u00e2y l\u00e0 m\u1ed9t danh s\u00e1ch ch\u1ee9a c\u00e1c d\u1eef li\u1ec7u li\u00ean quan, trong \u0111\u00f3 c\u00e1c h\u00e0ng th\u00f4ng tin li\u00ean quan l\u00e0 c\u00e1c b\u1ea3n ghi v\u00e0 c\u00e1c c\u1ed9t d\u1eef li\u1ec7u l\u00e0 c\u00e1c tr\u01b0\u1eddng. H\u00e0ng \u0111\u1ea7u ti\u00ean c\u1ee7a danh s\u00e1ch c\u00f3 ch\u1ee9a nh\u00e3n cho m\u1ed7i c\u1ed9t.<\/li>\n<li style=\"text-align: justify\"><em style=\"font-weight: bold\"> field<\/em><b>: <\/b>T\u00ean tr\u01b0\u1eddng (c\u1ed9t) d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c d\u00f9ng trong h\u00e0m, c\u00f3 th\u1ec3 nh\u1eadp t\u00ean c\u1ed9t, v\u1ecb tr\u00ed c\u1ed9t ho\u1eb7c th\u1ee9 t\u1ef1 c\u1ed9t trong b\u1ea3ng d\u1eef li\u1ec7u.<\/li>\n<li style=\"text-align: justify\"><strong><em>criteria:<\/em> <\/strong>L\u00e0 ph\u1ea1m vi \u00f4 ch\u1ee9a \u0111i\u1ec1u ki\u1ec7n x\u00e1c \u0111\u1ecbnh. Ph\u1ea1m vi \u00f4 ph\u1ea3i ch\u1ee9a ti\u00eau \u0111\u1ec1 c\u1ed9t v\u00e0 ch\u1ee9a \u00edt nh\u1ea5t m\u1ed9t gi\u00e1 tr\u1ecb n\u1eb1m trong ti\u00eau \u0111\u1ec1 c\u1ed9t.<\/li>\n<\/ul>\n<blockquote>\n<p>\u0110\u1eebng b\u1ecf qua:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/tag\/cac-ham-co-ban-trong-excel\">c\u00e1c h\u00e0m excel c\u01a1 b\u1ea3n<\/a>\u00a0 b\u1ea1n c\u1ea7n bi\u1ebft<\/p>\n<\/blockquote>\n<p style=\"text-align: justify\"><strong>V\u00ed d\u1ee5<\/strong><\/p>\n<p style=\"text-align: justify\">Cho b\u1ea3ng d\u1eef li\u1ec7u sau v\u00e0 t\u00ednh l\u01b0\u01a1ng th\u1ea5p nh\u1ea5t c\u1ee7a c\u00e1c nh\u00e2n vi\u00ean trong ph\u00f2ng Kinh doanh.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-4210 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ham-dmin.png\" width=\"600\" height=\"409\" title=\"ham-dmin\"><\/p>\n<ul>\n<li style=\"text-align: justify\">\u0110i\u1ec1u ki\u1ec7n: Nh\u00e2n vi\u00ean \u1edf ph\u00f2ng Kinh doanh, ta s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c:<strong> =DMIN(A4:D9;D4;E2:F3)<\/strong><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-4211 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ham-dmin-1.png\" width=\"600\" height=\"306\" title=\"ham-dmin-1\"><\/p>\n<p>V\u1eady l\u00e0 xong!<\/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\/2025\/01\/ex101_92019-nho-354.gif\" title=\"ex101_92019-nho-354\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><strong>M\u1ed9t s\u1ed1 b\u00e0i vi\u1ebft b\u1ea1n c\u00f3 th\u1ec3 quan t\u00e2m<\/strong><\/p>\n<ul>\n<li><a href=\"https:\/\/blog.hocexcel.online\/tong-hop-bao-cao-du-lieu-voi-ham-sumif-trong-excel.html\">T\u1ed5ng h\u1ee3p, b\u00e1o c\u00e1o d\u1eef li\u1ec7u v\u1edbi h\u00e0m SUMIF trong Excel<\/a><\/li>\n<li><a href=\"https:\/\/blog.hocexcel.online\/su-khac-nhau-giua-ham-columns-va-ham-column-trong-excel.html\">S\u1ef1 kh\u00e1c nhau gi\u1eefa h\u00e0m COLUMNS v\u00e0 h\u00e0m COLUMN trong Excel<\/a><\/li>\n<li><a href=\"https:\/\/blog.hocexcel.online\/ham-networkdays-va-cach-dung-ham-networkdays-trong-excel.html\">H\u00e0m NETWORKDAYS v\u00e0 c\u00e1ch d\u00f9ng h\u00e0m NETWORKDAYS trong Excel<\/a><\/li>\n<li><a href=\"https:\/\/blog.hocexcel.online\/cac-ham-chuyen-doi-kieu-chu-trong-excel.html\">C\u00e1c h\u00e0m chuy\u1ec3n \u0111\u1ed5i ki\u1ec3u ch\u1eef<\/a><strong><a href=\"https:\/\/blog.hocexcel.online\/cac-ham-chuyen-doi-kieu-chu-trong-excel.html\"> trong Excel<\/a><\/strong><\/li>\n<\/ul>\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\/2025\/01\/ex101_92019-nho-354.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":12124,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-12123","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/12123","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=12123"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/12123\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/12124"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=12123"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=12123"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=12123"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}