{"id":12374,"date":"2025-01-15T08:26:26","date_gmt":"2025-01-15T08:26:26","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/huong-dan-4-cach-tim-gia-tri-lon-nhat-va-nho-nhat-trong-excel\/"},"modified":"2025-01-15T08:26:26","modified_gmt":"2025-01-15T08:26:26","slug":"huong-dan-4-cach-tim-gia-tri-lon-nhat-va-nho-nhat-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/huong-dan-4-cach-tim-gia-tri-lon-nhat-va-nho-nhat-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn 4 c\u00e1ch t\u00ecm gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t v\u00e0 nh\u1ecf nh\u1ea5t trong excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\">V\u01a1\u0301i ba\u0300i vi\u00ea\u0301t na\u0300y,\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc-excel-co-ban\">h\u1ecdc excel c\u01a1 b\u1ea3n<\/a> se\u0303 h\u01b0\u01a1\u0301ng d\u00e2\u0303n ca\u0301c ba\u0323n 4 ca\u0301ch \u0111\u00ea\u0309 ti\u0300m ra gia\u0301 tri\u0323 l\u01a1\u0301n nh\u00e2\u0301t va\u0300 nho\u0309 nh\u00e2\u0301t trong Excel v\u00f4 cu\u0300ng \u0111\u01a1n gia\u0309n ma\u0300 hi\u00ea\u0323u qua\u0309.<\/p>\n<p style=\"text-align: justify\">T\u00f9y t\u1eebng tr\u01b0\u1eddng h\u1ee3p t\u00ednh to\u00e1n v\u00e0 ph\u00e2n t\u00edch s\u1ed1 li\u1ec7u trong Excel, \u0111\u1ec3 t\u00ecm gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5 \u2013 gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t trong d\u00e3y, ch\u00fang ta th\u01b0\u1eddng s\u1eed d\u1ee5ng 4 h\u00e0m ph\u1ed5 bi\u1ebfn 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-6787713082339\" 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-3\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-4-cach-tim-gia-tri-lon-nhat-va-nho-nhat-trong-excel.html#1_Ham_MAX\" title=\"1. H\u00e0m MAX\">1. H\u00e0m MAX<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-4-cach-tim-gia-tri-lon-nhat-va-nho-nhat-trong-excel.html#3_Ham_MIN\" title=\"3. H\u00e0m MIN\">3. H\u00e0m MIN<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-4-cach-tim-gia-tri-lon-nhat-va-nho-nhat-trong-excel.html#4_Ham_SMALL\" title=\"\n4. H\u00e0m SMALL\"><br \/>\n4. H\u00e0m SMALL<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"1_Ham_MAX\"><\/span><b>1. H\u00e0m MAX<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">\u0110\u1ed1i v\u1edbi h\u00e0m <strong>MAX<\/strong>, n\u00f3 s\u1ebd tr\u1ea3 v\u1ec1 s\u1ed1 l\u1edbn nh\u1ea5t trong d\u00e3y \u0111\u01b0\u1ee3c nh\u1eadp.<br \/>\nC\u00fa ph\u00e1p: <strong>= MAX(Number1, Number2\u2026)<\/strong><br \/>\nC\u00e1c tham s\u1ed1: Number1, Number2\u2026 l\u00e0 d\u00e3y m\u00e0 b\u1ea1n mu\u1ed1n t\u00ecm gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t \u1edf trong \u0111\u00f3.<\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5: T\u00ecm \u0111i\u1ec3m To\u00e1n l\u1edbn nh\u1ea5t trong b\u1ea3ng.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3270 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ham-replace-3.png\" width=\"600\" height=\"416\" title=\"ham-replace-3\">K\u1ebft qu\u1ea3 thu \u0111\u01b0\u1ee3c:<\/p>\n<h3 style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3272 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ham-replace-4.png\" width=\"600\" height=\"456\" title=\"ham-replace-4\"><\/h3>\n<blockquote>\n<p>Xem th\u00eam: <a href=\"http:\/\/blog.ezworkapp.com\/thao-tac-voi-ham.html\">Thao ta\u0301c ca\u0301c ha\u0300m trong Excel<\/a><\/p>\n<\/blockquote>\n<p><b>2. H\u00e0m LAGRE<\/b><\/p>\n<p style=\"text-align: justify\">\u0110\u1ed1i v\u1edbi h\u00e0m <b>LARGE<\/b>, n\u00f3 s\u1ebd t\u00ecm s\u1ed1 l\u1edbn th\u1ee9 k trong m\u1ed9t d\u00e3y \u0111\u01b0\u1ee3c nh\u1eadp.<br \/>\nC\u00fa ph\u00e1p: =<strong>LARGE(Array, k)<\/strong><br \/>\nC\u00e1c tham s\u1ed1:<br \/>\n\u2013 Array: L\u00e0 m\u1ed9t m\u1ea3ng ho\u1eb7c m\u1ed9t v\u00f9ng d\u1eef li\u1ec7u.<br \/>\n\u2013 k: L\u00e0 th\u1ee9 h\u1ea1ng c\u1ee7a s\u1ed1 b\u1ea1n mu\u1ed1n t\u00ecm k\u1ec3 t\u1eeb s\u1ed1 l\u1edbn nh\u1ea5t trong d\u00e3y.<\/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-390.gif\" title=\"ex101_92019-nho-390\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5: T\u00ecm \u0111i\u1ec3m L\u00fd l\u1edbn th\u1ee9 3 trong d\u00e3y \u0111\u00e3 cho.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3274 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ham-replace-5.png\" width=\"600\" height=\"377\" title=\"ham-replace-5\"><\/p>\n<p style=\"text-align: justify\">K\u1ebft qu\u1ea3 thu \u0111\u01b0\u1ee3c:<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3275 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ham-replace-6.png\" width=\"600\" height=\"412\" title=\"ham-replace-6\"><\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"3_Ham_MIN\"><\/span><b>3. H\u00e0m MIN<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">\u0110\u1ed1i v\u1edbi h\u00e0m <strong>MIN<\/strong>, n\u00f3 tr\u1ea3 v\u1ec1 s\u1ed1 nh\u1ecf nh\u1ea5t trong d\u00e3y \u0111\u01b0\u1ee3c nh\u1eadp v\u00e0o.<br \/>\nC\u00fa ph\u00e1p: <strong>=MIN(Number1, Number2\u2026)<\/strong><br \/>\nC\u00e1c tham s\u1ed1: Number1, Number2\u2026 l\u00e0 d\u00e3y m\u00e0 b\u1ea1n mu\u1ed1n t\u00ecm gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t \u1edf trong \u0111\u00f3.<\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5:\u00a0T\u00ecm \u0111i\u1ec3m To\u00e1n b\u00e9 nh\u1ea5t trong b\u1ea3ng.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3276 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ham-replace-7.png\" width=\"600\" height=\"396\" title=\"ham-replace-7\">K\u1ebft qu\u1ea3 thu \u0111\u01b0\u1ee3c:<\/p>\n<h3 style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3277 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ham-replace-8.png\" width=\"600\" height=\"421\" title=\"ham-replace-8\"><br \/>\n<b>4. H\u00e0m SMALL<\/b><\/h3>\n<p style=\"text-align: justify\">\u0110\u1ed1i v\u1edbi h\u00e0m <strong>SMALL, <\/strong>n\u00f3 s\u1ebd t\u00ecm s\u1ed1 nh\u1ecf th\u1ee9 k trong m\u1ed9t d\u00e3y \u0111\u01b0\u1ee3c nh\u1eadp v\u00e0o.<strong><br \/>\n<\/strong>C\u00fa ph\u00e1p: =<strong>SMALL(Array, k)<\/strong><br \/>\nC\u00e1c tham s\u1ed1:<br \/>\n\u2013 Array: L\u00e0 m\u1ed9t m\u1ea3ng ho\u1eb7c m\u1ed9t v\u00f9ng c\u1ee7a d\u1eef li\u1ec7u.<br \/>\n\u2013 k: L\u00e0 th\u1ee9 h\u1ea1ng c\u1ee7a s\u1ed1 m\u00e0 b\u1ea1n mu\u1ed1n t\u00ecm k\u1ec3 t\u1eeb s\u1ed1 nh\u1ecf nh\u1ea5t trong d\u00e3y.<\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5: T\u00ecm \u0111i\u1ec3m L\u00fd nh\u1ecf nh\u1ea5t th\u1ee9 5 \u00a0trong d\u00e3y.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3278 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ham-replace-9.png\" width=\"600\" height=\"342\" title=\"ham-replace-9\"><\/p>\n<p style=\"text-align: justify\">K\u1ebft qu\u1ea3 thu \u0111\u01b0\u1ee3c:<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3279 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ham-replace-10.png\" width=\"600\" height=\"420\" title=\"ham-replace-10\"><\/p>\n<p><a href=\"http:\/\/bit.ly\/2mWmtzP\" target=\"_blank\" rel=\"noopener noreferrer\">\u00a0<\/a><\/p>\n<p>Ngo\u00e0i ra \u0111\u1ec3 \u1ee9ng d\u1ee5ng Excel v\u00e0o c\u00f4ng vi\u1ec7c m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3 th\u00ec b\u1ea1n c\u00f2n ph\u1ea3i s\u1eed d\u1ee5ng t\u1ed1t c\u00e1c h\u00e0m, c\u00e1c c\u00f4ng c\u1ee5 kh\u00e1c c\u1ee7a Excel.<\/p>\n<p>M\u1ed9t s\u1ed1 h\u00e0m c\u01a1 b\u1ea3n th\u01b0\u1eddng g\u1eb7p nh\u01b0:<\/p>\n<ul>\n<li>SUMIF, SUMIFS \u0111\u1ec3 t\u00ednh t\u1ed5ng theo 1 \u0111i\u1ec1u ki\u1ec7n, nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/li>\n<li>COUNTIF, COUNTIFS \u0111\u1ec3 th\u1ed1ng k\u00ea, \u0111\u1ebfm theo m\u1ed9t \u0111i\u1ec1u ki\u1ec7n, nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/li>\n<li>C\u00e1c h\u00e0m x\u1eed l\u00fd d\u1eef li\u1ec7u d\u1ea1ng chu\u1ed7i, d\u1ea1ng ng\u00e0y th\u00e1ng, d\u1ea1ng s\u1ed1\u2026<\/li>\n<li>C\u00e1c h\u00e0m d\u00f2 t\u00ecm tham chi\u1ebfu Index+Match, h\u00e0m SUMPRODUCT\u2026<\/li>\n<\/ul>\n<p>M\u1ed9t s\u1ed1 c\u00f4ng c\u1ee5 hay s\u1eed d\u1ee5ng nh\u01b0:<\/p>\n<ul>\n<li>\u0110\u1ecbnh d\u1ea1ng theo \u0111i\u1ec1u ki\u1ec7n v\u1edbi Conditional formatting<\/li>\n<li>Thi\u1ebft l\u1eadp \u0111i\u1ec1u ki\u1ec7n nh\u1eadp d\u1eef li\u1ec7u v\u1edbi Data Validation<\/li>\n<li>C\u00e1ch \u0111\u1eb7t Name v\u00e0 s\u1eed d\u1ee5ng Name trong c\u00f4ng th\u1ee9c<\/li>\n<li>L\u1eadp b\u00e1o c\u00e1o v\u1edbi Pivot Table\u2026<\/li>\n<\/ul>\n<p>R\u1ea5t nhi\u1ec1u ki\u1ebfn th\u1ee9c ph\u1ea3i kh\u00f4ng n\u00e0o? 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\/2o7xMG3\">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<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-390.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":12375,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-12374","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\/12374","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=12374"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/12374\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/12375"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=12374"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=12374"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=12374"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}