{"id":6625,"date":"2024-12-21T15:46:49","date_gmt":"2024-12-21T15:46:49","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cach-tim-nhung-gia-tri-lap-nhieu-nhat-so-hoac-chuoi-ky-tu-tu-mot-danh-sach-trong-excel\/"},"modified":"2024-12-21T15:46:49","modified_gmt":"2024-12-21T15:46:49","slug":"cach-tim-nhung-gia-tri-lap-nhieu-nhat-so-hoac-chuoi-ky-tu-tu-mot-danh-sach-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cach-tim-nhung-gia-tri-lap-nhieu-nhat-so-hoac-chuoi-ky-tu-tu-mot-danh-sach-trong-excel\/","title":{"rendered":"C\u00e1ch t\u00ecm nh\u1eefng gi\u00e1 tr\u1ecb l\u1eb7p nhi\u1ec1u nh\u1ea5t (s\u1ed1 ho\u1eb7c chu\u1ed7i k\u00fd t\u1ef1) t\u1eeb m\u1ed9t danh s\u00e1ch trong Excel"},"content":{"rendered":"
\n

Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 m\u1ed9t danh s\u00e1ch t\u00ean ch\u1ee9a m\u1ed9t v\u00e0i t\u00ean tr\u00f9ng l\u1eb7p. B\u1ea1n mu\u1ed1n ch\u1ecdn c\u00e1c gi\u00e1 tr\u1ecb xu\u1ea5t hi\u1ec7n nhi\u1ec1u l\u1ea7n. C\u00e1ch tr\u1ef1c ti\u1ebfp l\u00e0 \u0111\u1ebfm t\u1eebng d\u1eef li\u1ec7u m\u1ed9t, nh\u01b0ng n\u1ebfu c\u00f3 h\u00e0ng ng\u00e0n t\u00ean trong c\u1ed9t, c\u00e1ch n\u00e0y s\u1ebd r\u1eafc r\u1ed1i v\u00e0 t\u1ed1n th\u1eddi gian. Trong b\u00e0i vi\u1ebft n\u00e0y, H\u1ecdc Excel Online s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n m\u1ed9t v\u00e0i m\u1eb9o \u0111\u1ec3 gi\u1ea3i quy\u1ebft v\u1ea5n \u0111\u1ec1 nhanh ch\u00f3ng v\u00e0 ti\u1ec7n l\u1ee3i.<\/p>\n

T\u00ecm c\u00e1c gi\u00e1 tr\u1ecb l\u1eb7p nhi\u1ec1u nh\u1ea5t (s\u1ed1 ho\u1eb7c chu\u1ed7i k\u00fd t\u1ef1) t\u1eeb danh s\u00e1ch b\u1eb1ng c\u00f4ng th\u1ee9c m\u1ea3ng<\/strong><\/p>\n

Nh\u00ecn chung, ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m\u00a0MODE\u00a0<\/strong><\/em>(=MODE(A1:A16)<\/strong><\/em>)\u0111\u1ec3 t\u00ecm c\u00e1c s\u1ed1 xu\u1ea5t hi\u1ec7n nhi\u1ec1u nh\u1ea5t trong v\u00f9ng d\u1eef li\u1ec7u. Tuy nhi\u00ean, h\u00e0m\u00a0MODE\u00a0<\/strong><\/em>kh\u00f4ng hi\u1ec7u qu\u1ea3 \u0111\u1ed1i v\u1edbi chu\u1ed7i k\u00fd t\u1ef1. \u0110\u1ec3 ch\u1ecdn c\u00e1c gi\u00e1 tr\u1ecb xu\u1ea5t hi\u1ec7n th\u01b0\u1eddng xuy\u00ean nh\u1ea5t, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c m\u1ea3ng sau:<\/p>\n

Trong \u00f4 tr\u1ed1ng b\u00ean c\u1ea1nh d\u1eef li\u1ec7u, nh\u1eadp c\u00f4ng th\u1ee9c:<\/p>\n

=INDEX($A$1:$A$16,MODE(MATCH($A$1:$A$16,$A$1:$A$16,0)))<\/strong><\/em><\/p>\n

Nh\u1ea5n\u00a0Ctrl + Shift + Enter<\/strong><\/em>.<\/p>\n

<\/p>\n

Ch\u00fa \u00fd:<\/strong><\/p>\n

\n
\n
\n
\n<\/a>\n<\/div>\n<\/div>\n
\n
\n
\n
\n<\/a>\n<\/div>\n<\/div>\n

1. A1:A16 l\u00e0 v\u00f9ng d\u1eef li\u1ec7u b\u1ea1n mu\u1ed1n thao t\u00e1c.<\/p>\n

2. C\u00f4ng th\u1ee9c m\u1ea3ng kh\u00f4ng ho\u1ea1t \u0111\u1ed9ng n\u1ebfu c\u00f3 \u00f4 tr\u1ed1ng trong danh s\u00e1ch.<\/p>\n

T\u00ecm c\u00e1c gi\u00e1 tr\u1ecb l\u1eb7p nhi\u1ec1u nh\u1ea5t (s\u1ed1 ho\u1eb7c chu\u1ed7i k\u00fd t\u1ef1) t\u1eeb danh s\u00e1ch b\u1eb1ng VBA Code<\/strong><\/p>\n

V\u00f3i VBA, b\u1ea1n kh\u00f4ng ch\u1ec9 t\u00ecm \u0111\u01b0\u1ee3c c\u00e1c gi\u00e1 tr\u1ecb xu\u1ea5t hi\u1ec7n th\u01b0\u1eddng xuy\u00ean nh\u1ea5t m\u00e0 c\u00f2n \u0111\u1ebfm \u0111\u01b0\u1ee3c s\u1ed1 l\u1ea7n xu\u1ea5t hi\u1ec7n c\u1ee7a ch\u00fang.<\/p>\n

1. Nh\u1ea5n gi\u1eef ph\u00edm\u00a0Alt + F11<\/strong><\/em>, c\u1eeda s\u1ed5 Microsoft Visual Basic for Applications\u00a0<\/strong><\/em>m\u1edf ra.<\/p>\n

2. Nh\u1ea5p Insert > Module<\/strong><\/em>, d\u00e1n \u0111o\u1ea1n m\u00e3 sau v\u00e0o Module Window<\/strong><\/em>.<\/p>\n<\/p>\n

View the code on Gist<\/a>.<\/div>\n
3. Nh\u1ea5n\u00a0F5\u00a0<\/strong><\/em>\u0111\u1ec3 ch\u1ea1y m\u00e3, m\u1ed9t h\u1ed9p tho\u1ea1i hi\u1ec7n ra nh\u1eafc nh\u1edf b\u1ea1n ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u b\u1ea1n mu\u1ed1n s\u1eed d\u1ee5ng nh\u01b0 h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y:<\/div>\n

\"doc<\/p>\n

4. Nh\u1ea5n OK. M\u1ed9t h\u1ed9p tho\u1ea1i l\u1ea1i xu\u1ea5t hi\u1ec7n hi\u1ec3n th\u1ecb th\u00f4ng tin sau \u0111\u00e2y:<\/p>\n

\"doc<\/p>\n

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\u00a0EX101 \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: HocExcel.Online<\/a><\/p>\n

\u00a0<\/p>\n<\/div>\n

\n

Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n

T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0\ud83d\udcd6<\/span><\/a><\/p>\n

H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n

HKD H\u1ecdc Excel Online
S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n

\n

\u00a9 document.currentScript.insertAdjacentHTML(‘afterend’, ” + new Intl.DateTimeFormat(document.documentElement.lang, {year: ‘numeric’}).format() + ”); H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

\n
\n
\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":6626,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-6625","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\/6625","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=6625"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/6625\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/6626"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=6625"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=6625"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=6625"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}