{"id":12079,"date":"2025-01-15T06:57:05","date_gmt":"2025-01-15T06:57:05","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/ham-mode-ham-tim-tan-xuat-lon-nhat-trong-excel\/"},"modified":"2025-01-15T06:57:05","modified_gmt":"2025-01-15T06:57:05","slug":"ham-mode-ham-tim-tan-xuat-lon-nhat-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/ham-mode-ham-tim-tan-xuat-lon-nhat-trong-excel\/","title":{"rendered":"H\u00e0m MODE, H\u00e0m t\u00ecm t\u1ea7n xu\u1ea5t l\u1edbn nh\u1ea5t trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><strong>H\u00e0m MODE\u00a0trong Excel s\u1ebd gi\u00fap b\u1ea1n t\u00ecm ra m\u1ed9t s\u1ed1 c\u00f3 t\u1ea7n su\u1ea5t xu\u1ea5t hi\u1ec7n nhi\u1ec1u nh\u1ea5t trong m\u1ed9t m\u1ea3ng d\u1eef li\u1ec7u.<\/strong><\/p>\n<p><strong>C\u00fa ph\u00e1p: MODE(s\u1ed1 1, s\u1ed1 2, s\u1ed1 3, \u2026)<\/strong><\/p>\n<p><span style=\"font-weight: 400\">Trong \u0111\u00f3:<\/span><\/p>\n<ul style=\"list-style-type: circle\">\n<li><span style=\"font-weight: 400\">S\u1ed1 1: B\u1eaft bu\u1ed9c. L\u00e0 \u0111\u1ed1i s\u1ed1 d\u1ea1ng s\u1ed1 \u0111\u1ea7u ti\u00ean cho nh\u1eefng g\u00ec b\u1ea1n mu\u1ed1n t\u00ednh s\u1ed1 y\u1ebfu v\u1ecb.<\/span><\/li>\n<li><span style=\"font-weight: 400\">S\u1ed1 2, s\u1ed1 3 \u2026 : T\u00f9y ch\u1ecdn. L\u00e0 \u0111\u1ed1i s\u1ed1 d\u1ea1ng s\u1ed1 th\u1ee9 2, th\u1ee9 3,\u2026 m\u00e0 b\u1ea1n mu\u1ed1n t\u00ednh to\u00e1n s\u1ed1 y\u1ebfu v\u1ecb trong \u0111\u00f3.<\/span><\/li>\n<\/ul>\n<p><strong><em>L\u01b0u \u00fd:<\/em><\/strong><\/p>\n<p><span style=\"font-weight: 400\">\u2013<\/span> <span style=\"font-weight: 400\">\u0110\u1ed1i s\u1ed1 c\u00f3 th\u1ec3 l\u00e0 s\u1ed1, m\u1ea3ng ho\u1eb7c tham chi\u1ebfu c\u00f3 ch\u1ee9a s\u1ed1.<\/span><\/p>\n<p><span style=\"font-weight: 400\">\u2013<\/span> <span style=\"font-weight: 400\">C\u00e1c \u0111\u1ed1i s\u1ed1 l\u00e0 v\u0103n b\u1ea3n hay gi\u00e1 tr\u1ecb l\u1ed7i kh\u00f4ng th\u1ec3 chuy\u1ec3n \u0111\u1ed5i th\u00e0nh s\u1ed1 th\u00ec h\u00e0m s\u1ebd l\u1ed7i.<\/span><\/p>\n<p><span style=\"font-weight: 400\">\u2013<\/span> <span style=\"font-weight: 400\">N\u1ebfu \u0111\u1ed1i s\u1ed1, tham chi\u1ebfu hay m\u1ea3ng c\u00f3 ch\u1ee9a gi\u00e1 tr\u1ecb logic, v\u0103n b\u1ea3n hay \u00f4 tr\u1ed1ng th\u00ec s\u1ebd b\u1ecb b\u1ecf qua, nh\u1eefng \u00f4 c\u00f3 gi\u00e1 tr\u1ecb 0 s\u1ebd \u0111\u01b0\u1ee3c t\u00ednh.<\/span><\/p>\n<p><span style=\"font-weight: 400\">\u2013<\/span> <span style=\"font-weight: 400\">C\u00e1c \u0111\u1ed1i s\u1ed1 kh\u00f4ng c\u00f3 s\u1ed1 n\u00e0o l\u1eb7p l\u1ea1i tr\u00ean 2 l\u1ea7n th\u00ec h\u00e0m s\u1ebd b\u00e1o l\u1ed7i.<\/span><\/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-348.gif\" title=\"ex101_92019-nho-348\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><span style=\"font-weight: 400\">\u2013<\/span> <span style=\"font-weight: 400\">C\u00f3 nhi\u1ec1u s\u1ed1 c\u00f3 t\u1ea7n su\u1ea5t xu\u1ea5t hi\u1ec7n nh\u01b0 nhau th\u00ec k\u1ebft qu\u1ea3 s\u1ebd l\u00e0 \u0111\u1ed1i s\u1ed1 xu\u1ea5t hi\u1ec7n \u0111\u1ea7u ti\u00ean.<\/span><\/p>\n<blockquote>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/tag\/cac-ham-co-ban-trong-excel\">C\u00e1c h\u00e0m Excel c\u01a1 b\u1ea3n <\/a><\/p>\n<\/blockquote>\n<p><strong>V\u00ed d\u1ee5:<\/strong><\/p>\n<p><span style=\"font-weight: 400\">Cho d\u1eef li\u1ec7u \u00a0nh\u01b0 sau:<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4327 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/mode-1.gif\" width=\"600\" height=\"271\" title=\"mode-1\"><\/p>\n<p>\u0110\u1ec3 t\u00ecm s\u1ed1 c\u00f3 t\u1ea7n xu\u1ea5t l\u1edbn nh\u1ea5t trong m\u1ea3ng d\u1eef li\u1ec7u tr\u00ean, t\u1ea1i \u00f4 B6 c\u00e1c b\u1ea1n nh\u1eadp: <strong>=MODE(A1:D4)\u00a0\u2192 Enter.<\/strong><\/p>\n<p>K\u1ebft qu\u1ea3:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4328 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/mode-2.gif\" width=\"600\" height=\"206\" title=\"mode-2\"><\/p>\n<p><strong>Tham kh\u1ea3o c\u00e1c kho\u00e1 h\u1ecdc c\u1ee7a H\u1ecdc Excel Online \u0111\u1ec3 l\u00e0m ch\u1ee7 Excel:<\/strong><\/p>\n<p>H\u1ecdc Excel, C\u00f3 Vi\u1ec7c Ngay: <a href=\"http:\/\/blog.ezworkapp.com\/ex101\">https:\/\/www.hocexcel.online\/ex101<\/a><br \/>\nLuy\u1ec7n h\u00e0m v\u00e0 c\u00f4ng c\u1ee5 Excel: <a href=\"http:\/\/blog.ezworkapp.com\/ex102\">https:\/\/www.hocexcel.online\/ex102<\/a><br \/>\nH\u00e3y \u0111\u1ec3 VBA gi\u00fap b\u1ea1n: <a href=\"https:\/\/www.hocexcel.online\/vba101\">https:\/\/www.hocexcel.online\/vba101<\/a><br \/>\nPro VBA n\u00e2ng cao: <a href=\"http:\/\/blog.ezworkapp.com\/vba201\">https:\/\/www.hocexcel.online\/vba201<\/a><br \/>\nHi\u1ec3u v\u00e0 ph\u00e2n t\u00edch d\u1eef li\u1ec7u v\u1edbi Excel: <a href=\"http:\/\/blog.ezworkapp.com\/dv101\">https:\/\/www.hocexcel.online\/dv101<\/a><br \/>\nH\u00e3y l\u00e0m k\u1ebf to\u00e1n v\u1edbi VBA: <a href=\"http:\/\/blog.ezworkapp.com\/im101\">https:\/\/www.hocexcel.online\/im101<\/a><br \/>\nQu\u1ea3n l\u00fd kho h\u00e0ng trong Excel: <a href=\"http:\/\/blog.ezworkapp.com\/im201\">https:\/\/www.hocexcel.online\/im201<\/a><\/p>\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=\"http:\/\/blog.ezworkapp.com\/ham-product-ham-nhan-trong-excel.html\" target=\"_blank\">H\u00e0m PRODUCT \u2013 H\u00e0m nh\u00e2n trong Excel<\/a><\/li>\n<li><a href=\"http:\/\/blog.ezworkapp.com\/ham-power-ham-tinh-luy-thua-trong-excel.html\" target=\"_blank\">H\u00e0m POWER, h\u00e0m t\u00ednh l\u0169y th\u1eeba trong Excel<\/a><\/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-348.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":12080,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-12079","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\/12079","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=12079"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/12079\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/12080"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=12079"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=12079"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=12079"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}