{"id":9360,"date":"2025-01-02T02:18:16","date_gmt":"2025-01-02T02:18:16","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/02\/huong-dan-cach-tim-gia-tri-lon-hon-gan-nhat-voi-gia-tri-so-sanh\/"},"modified":"2025-01-02T02:18:16","modified_gmt":"2025-01-02T02:18:16","slug":"huong-dan-cach-tim-gia-tri-lon-hon-gan-nhat-voi-gia-tri-so-sanh","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/02\/huong-dan-cach-tim-gia-tri-lon-hon-gan-nhat-voi-gia-tri-so-sanh\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch t\u00ecm gi\u00e1 tr\u1ecb l\u1edbn h\u01a1n g\u1ea7n nh\u1ea5t v\u1edbi gi\u00e1 tr\u1ecb so s\u00e1nh"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Trong b\u00e0i vi\u1ebft v\u1ec1\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-tim-gia-tri-nho-hon-gan-nhat-voi-gia-tri-so-sanh.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch t\u00ecm gi\u00e1 tr\u1ecb nh\u1ecf h\u01a1n g\u1ea7n nh\u1ea5t v\u1edbi gi\u00e1 tr\u1ecb so s\u00e1nh<\/a>, ch\u00fang ta\u00a0\u0111\u00e3 bi\u1ebft c\u00e1c c\u00e1ch kh\u00e1c nhau\u00a0\u0111\u1ec3 t\u00ecm gi\u00e1 tr\u1ecb nh\u1ecf h\u01a1n g\u1ea7n nh\u1ea5t v\u1edbi 1 s\u1ed1. V\u1eady n\u1ebfu mu\u1ed1n t\u00ecm gi\u00e1 tr\u1ecb l\u1edbn h\u01a1n g\u1ea7n nh\u1ea5t v\u1edbi 1 s\u1ed1 th\u00ec d\u00f9ng c\u00e1ch n\u00e0o? B\u00e0i vi\u1ebft n\u00e0y s\u1ebd h\u01b0\u1edbng d\u1eabn chi ti\u1ebft cho c\u00e1c b\u1ea1n.<\/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-6775f7675f790\" 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\/huong-dan-cach-tim-gia-tri-lon-hon-gan-nhat-voi-gia-tri-so-sanh.html#Tim_gia_tri_lon_hon_gan_nhat_trong_danh_sach_duoc_sap_xep\" title=\"T\u00ecm gi\u00e1 tr\u1ecb\u00a0l\u1edbn\u00a0h\u01a1n g\u1ea7n nh\u1ea5t trong danh s\u00e1ch\u00a0\u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp\">T\u00ecm gi\u00e1 tr\u1ecb\u00a0l\u1edbn\u00a0h\u01a1n g\u1ea7n nh\u1ea5t trong danh s\u00e1ch\u00a0\u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-tim-gia-tri-lon-hon-gan-nhat-voi-gia-tri-so-sanh.html#Tim_vi_tri_so_lon_hon_gan_nhat_voi_ham_MATCH\" title=\"T\u00ecm v\u1ecb tr\u00ed s\u1ed1 l\u1edbn h\u01a1n g\u1ea7n nh\u1ea5t v\u1edbi h\u00e0m MATCH\">T\u00ecm v\u1ecb tr\u00ed s\u1ed1 l\u1edbn h\u01a1n g\u1ea7n nh\u1ea5t v\u1edbi h\u00e0m MATCH<\/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-cach-tim-gia-tri-lon-hon-gan-nhat-voi-gia-tri-so-sanh.html#Tim_gia_tri_so_lon_hon_gan_nhat_voi_ham_INDEX_ket_hop_ham_MATCH\" title=\"T\u00ecm gi\u00e1 tr\u1ecb s\u1ed1 l\u1edbn h\u01a1n g\u1ea7n nh\u1ea5t v\u1edbi h\u00e0m INDEX k\u1ebft h\u1ee3p h\u00e0m MATCH\">T\u00ecm gi\u00e1 tr\u1ecb s\u1ed1 l\u1edbn h\u01a1n g\u1ea7n nh\u1ea5t v\u1edbi h\u00e0m INDEX k\u1ebft h\u1ee3p h\u00e0m MATCH<\/a><\/li>\n<\/ul>\n<\/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\/huong-dan-cach-tim-gia-tri-lon-hon-gan-nhat-voi-gia-tri-so-sanh.html#Tim_gia_tri_lon_hon_gan_nhat_trong_danh_sach_khong_duoc_sap_xep\" title=\"T\u00ecm gi\u00e1 tr\u1ecb\u00a0l\u1edbn\u00a0h\u01a1n g\u1ea7n nh\u1ea5t trong danh s\u00e1ch kh\u00f4ng \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp\">T\u00ecm gi\u00e1 tr\u1ecb\u00a0l\u1edbn\u00a0h\u01a1n g\u1ea7n nh\u1ea5t trong danh s\u00e1ch kh\u00f4ng \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-tim-gia-tri-lon-hon-gan-nhat-voi-gia-tri-so-sanh.html#Su_dung_ham_COUNTIF_ket_hop_ham_LARGE\" title=\"S\u1eed d\u1ee5ng h\u00e0m COUNTIF k\u1ebft h\u1ee3p h\u00e0m LARGE\">S\u1eed d\u1ee5ng h\u00e0m COUNTIF k\u1ebft h\u1ee3p h\u00e0m LARGE<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Tim_gia_tri_lon_hon_gan_nhat_trong_danh_sach_duoc_sap_xep\"><\/span>T\u00ecm gi\u00e1 tr\u1ecb\u00a0l\u1edbn\u00a0h\u01a1n g\u1ea7n nh\u1ea5t trong danh s\u00e1ch\u00a0\u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0110\u1ec3 c\u00f3 th\u1ec3 x\u00e1c\u00a0\u0111\u1ecbnh gi\u00e1 tr\u1ecb l\u1edbn h\u01a1n g\u1ea7n nh\u1ea5t, ch\u00fang ta kh\u00f4ng th\u1ec3 d\u00f9ng c\u00e1ch th\u00f4ng th\u01b0\u1eddng v\u1edbi h\u00e0m LOOKUP hay h\u00e0m VLOOKUP.\u00a0\u1ede\u00a0\u0111\u00e2y ch\u00fang ta s\u1ebd t\u00ecm hi\u1ec3u v\u1ec1 <a href=\"http:\/\/blog.ezworkapp.com\/vi-sao-dung-index-va-match-tot-hon-dung-vlookup-trong-excel.html\">2 h\u00e0m INDEX v\u00e0 MATCH<\/a>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24721\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/tim-so-lon-hon-gan-nhat-ham-index-match-yeu-cau.png\" width=\"503\" height=\"164\" title=\"tim-so-lon-hon-gan-nhat-ham-index-match-yeu-cau\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Tim_vi_tri_so_lon_hon_gan_nhat_voi_ham_MATCH\"><\/span>T\u00ecm v\u1ecb tr\u00ed s\u1ed1 l\u1edbn h\u01a1n g\u1ea7n nh\u1ea5t v\u1edbi h\u00e0m MATCH<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Trong c\u00e1c d\u1ea1ng t\u00ecm ki\u1ebfm, vi\u1ec7c t\u00ecm ki\u1ebfm b\u1eb1ng h\u00e0m MATCH cho ph\u00e9p ch\u00fang ta t\u00ecm trong danh s\u00e1ch\u00a0\u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp theo th\u1ee9 t\u1ef1 gi\u1ea3m d\u1ea7n ho\u1eb7c t\u0103ng d\u1ea7n. Tham s\u1ed1 c\u1ee7a h\u00e0m MATCH g\u1ed3m:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24722\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/tim-so-lon-hon-gan-nhat-ham-match.png\" width=\"634\" height=\"177\" title=\"tim-so-lon-hon-gan-nhat-ham-match\"><\/p>\n<ul>\n<li>S\u1ed1 1: t\u00ecm ki\u1ebfm theo gi\u00e1 tr\u1ecb nh\u1ecf h\u01a1n g\u1ea7n nh\u1ea5t (t\u01b0\u01a1ng\u00a0\u0111\u1ed1i)<\/li>\n<li>S\u1ed1 0: t\u00ecm ki\u1ebfm theo gi\u00e1 tr\u1ecb b\u1eb1ng (ch\u00ednh x\u00e1c)<\/li>\n<li>S\u1ed1 -1: t\u00ecm ki\u1ebfm theo gi\u00e1 tr\u1ecb l\u1edbn h\u01a1n g\u1ea7n nh\u1ea5t (t\u01b0\u01a1ng\u00a0\u0111\u1ed1i)<\/li>\n<\/ul>\n<p>Nh\u01b0 v\u1eady trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, ch\u00fang ta t\u00ecm theo tham s\u1ed1 l\u00e0 -1<\/p>\n<p>K\u1ebft qu\u1ea3 thu\u00a0\u0111\u01b0\u1ee3c l\u00e0:<\/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-43.gif\" title=\"ex101_92019-nho-43\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24723\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/tim-so-lon-hon-gan-nhat-ham-match-ket-qua.png\" width=\"523\" height=\"165\" title=\"tim-so-lon-hon-gan-nhat-ham-match-ket-qua\"><\/p>\n<p>C\u00f3 3 s\u1ed1 c\u00f3 gi\u00e1 tr\u1ecb l\u1edbn h\u01a1n 168, v\u00e0 s\u1ed1 180 l\u00e0 s\u1ed1 th\u1ee9 3 trong danh s\u00e1ch tr\u00ean.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Tim_gia_tri_so_lon_hon_gan_nhat_voi_ham_INDEX_ket_hop_ham_MATCH\"><\/span>T\u00ecm gi\u00e1 tr\u1ecb s\u1ed1 l\u1edbn h\u01a1n g\u1ea7n nh\u1ea5t v\u1edbi h\u00e0m INDEX k\u1ebft h\u1ee3p h\u00e0m MATCH<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/6-tinh-nang-hieu-qua-nhat-cua-ham-index-trong-excel.html\">H\u00e0m INDEX<\/a> l\u00e0 h\u00e0m gi\u00fap ch\u00fang ta x\u00e1c\u00a0\u0111\u1ecbnh gi\u00e1 tr\u1ecb trong 1\u00a0\u00f4, d\u1ef1a v\u00e0o v\u1ecb tr\u00ed d\u00f2ng v\u00e0 c\u1ed9t. Trong h\u01b0\u1edbng d\u1eabn v\u1ec1 h\u00e0m MATCH\u00a0\u1edf tr\u00ean, ch\u00fang ta\u00a0\u0111\u00e3 x\u00e1c\u00a0\u0111\u1ecbnh\u00a0\u0111\u01b0\u1ee3c v\u1ecb tr\u00ed s\u1ed1 l\u1edbn h\u01a1n g\u1ea7n nh\u1ea5t l\u00e0 v\u1ecb tr\u00ed th\u1ee9 m\u1ea5y,\u00a0\u1ee9ng v\u1edbi s\u1ed1 d\u00f2ng. C\u1ed9t c\u1ea7n t\u00ecm l\u00e0 c\u1ed9t s\u1ed1 Ti\u00eau chu\u1ea9n. Nh\u01b0 v\u1eady ta c\u00f3 c\u00f4ng th\u1ee9c t\u1ea1i\u00a0\u00f4 E3 l\u00e0:<\/p>\n<blockquote>\n<p>E3=INDEX(A2:A6,D3)<\/p>\n<p>hay E3=INDEX(A2:A6,MATCH(C3,$A$2:$A$6,-1))<\/p>\n<\/blockquote>\n<p>K\u1ebft qu\u1ea3 thu\u00a0\u0111\u01b0\u1ee3c l\u00e0:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24724\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/tim-so-lon-hon-gan-nhat-ham-index-match.png\" width=\"525\" height=\"164\" title=\"tim-so-lon-hon-gan-nhat-ham-index-match\"><\/p>\n<p>Nh\u01b0 v\u1eady ch\u00ednh x\u00e1c k\u1ebft qu\u1ea3 l\u00e0 s\u1ed1 180 l\u00e0 s\u1ed1 l\u1edbn h\u01a1n g\u1ea7n nh\u1ea5t so v\u1edbi s\u1ed1 168.<\/p>\n<p>L\u01b0u\u00a0\u00fd: Ch\u1ec9\u00a0\u00e1p d\u1ee5ng\u00a0\u0111\u01b0\u1ee3c tr\u01b0\u1eddng h\u1ee3p n\u00e0y khi d\u00e3y s\u1ed1<strong><em>\u00a0\u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp<\/em><\/strong> theo th\u1ee9 t\u1ef1 t\u0103ng d\u1ea7n ho\u1eb7c gi\u1ea3m d\u1ea7n.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Tim_gia_tri_lon_hon_gan_nhat_trong_danh_sach_khong_duoc_sap_xep\"><\/span>T\u00ecm gi\u00e1 tr\u1ecb\u00a0l\u1edbn\u00a0h\u01a1n g\u1ea7n nh\u1ea5t trong danh s\u00e1ch kh\u00f4ng \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"Su_dung_ham_COUNTIF_ket_hop_ham_LARGE\"><\/span>S\u1eed d\u1ee5ng h\u00e0m COUNTIF k\u1ebft h\u1ee3p h\u00e0m LARGE<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Trong b\u00e0i \u00a0<a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-tim-gia-tri-nho-hon-gan-nhat-voi-gia-tri-so-sanh.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch t\u00ecm gi\u00e1 tr\u1ecb nh\u1ecf h\u01a1n g\u1ea7n nh\u1ea5t v\u1edbi gi\u00e1 tr\u1ecb so s\u00e1nh<\/a>, ch\u00fang ta\u00a0\u0111\u00e3 bi\u1ebft c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m COUNTIF v\u1edbi h\u00e0m LARGE.\u00a0Khi t\u00ecm s\u1ed1 l\u1edbn h\u01a1n g\u1ea7n nh\u1ea5t, ch\u00fang ta s\u1ebd x\u00e9t ng\u01b0\u1ee3c l\u1ea1i nh\u01b0 sau:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/dem-co-dieu-kien-ham-countif-co-ban.html\">H\u00e0m COUNTIF<\/a>:\u00a0Trong h\u00e0m COUNTIF, ch\u00fang ta \u0111\u1ed5i d\u1ea5u so s\u00e1nh l\u00e0 d\u1ea5u nh\u1ecf h\u01a1n:<\/p>\n<p style=\"padding-left: 30px\">D3=COUNTIF(A2:A6,\u201d&lt;\u201c&amp;C3)+1<\/p>\n<p>Trong\u00a0\u0111\u00f3:<\/p>\n<p style=\"padding-left: 30px\">COUNTIF(A2:A6,\u201d&lt;\u201c&amp;C3) l\u00e0\u00a0\u0111\u1ebfm s\u1ed1 gi\u00e1 tr\u1ecb trong v\u00f9ng A2:A6 m\u00e0 nh\u1ecf h\u01a1n gi\u00e1 tr\u1ecb\u00a0\u1edf C3<\/p>\n<p style=\"padding-left: 30px\">COUNTIF(A2:A6,\u201d&lt;\u201c&amp;C3)+1\u00a0\u0111em k\u1ebft qu\u1ea3 s\u1ed1 gi\u00e1 tr\u1ecb nh\u1ecf h\u01a1n gi\u00e1 tr\u1ecb C3 c\u1ed9ng th\u00eam 1\u00a0\u0111\u1ec3 ra v\u1ecb tr\u00ed s\u1ed1 g\u1ea7n nh\u1ea5t m\u00e0 l\u1edbn h\u01a1n s\u1ed1 c\u1ea7n t\u00ecm.<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/ham-large-va-ham-small-trong-excel.html\">H\u00e0m SMALL<\/a>: tham chi\u1ebfu t\u1edbi gi\u00e1 t\u1ecb l\u1edbn h\u01a1n g\u1ea7n nh\u1ea5t, t\u1eeb v\u1ecb tr\u00ed\u00a0\u0111\u00e3 x\u00e1c\u00a0\u0111\u1ecbnh b\u1edfi h\u00e0m COUNTIF<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24726\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/tim-so-lon-hon-gan-nhat-ham-countif-small.png\" width=\"513\" height=\"164\" title=\"tim-so-lon-hon-gan-nhat-ham-countif-small\"><\/p>\n<p style=\"padding-left: 30px\">E3=SMALL(A2:A6,D3)<\/p>\n<p style=\"padding-left: 30px\">hay E3=SMALL(A2:A6,COUNTIF(A2:A6,\u201d&lt;\u201c&amp;C3)+1)<\/p>\n<p>Khi x\u00e9t theo h\u00e0m SMALL, ch\u00fang ta s\u1ebd t\u00ecm s\u1ed1 nh\u1ecf th\u1ee9 m\u1ea5y trong danh s\u00e1ch. Logic nh\u01b0 sau:<\/p>\n<ul>\n<li>S\u1ed1 l\u1edbn h\u01a1n g\u1ea7n nh\u1ea5t s\u1ebd l\u00e0 s\u1ed1\u00a0\u0111\u1ee9ng ti\u1ebfp theo c\u00e1c s\u1ed1 nh\u1ecf h\u01a1n s\u1ed1 c\u1ea7n t\u00ecm (\u0111\u00e3 x\u00e1c\u00a0\u0111\u1ecbnh b\u1edfi h\u00e0m COUNTIF\u00a0\u1edf tr\u00ean)<\/li>\n<li>Khi x\u00e9t theo h\u00e0m SMALL, s\u1ed1 1\u00a0\u1ee9ng v\u1edbi s\u1ed1 nh\u1ecf nh\u1ea5t, s\u1ed1 nh\u1ecf th\u1ee9 4 trong danh s\u00e1ch ch\u00ednh l\u00e0 s\u1ed1 l\u1edbn h\u01a1n g\u1ea7n nh\u1ea5t v\u1edbi s\u1ed1 c\u1ea7n t\u00ecm<\/li>\n<\/ul>\n<p>V\u00ed d\u1ee5 v\u1edbi s\u1ed1 195, ta c\u00f3:<\/p>\n<ul>\n<li>S\u1ed1 nh\u1ecf h\u01a1n g\u1ed3m c\u00e1c s\u1ed1: 140, 100, 180\u00a0\u1ee9ng v\u1edbi c\u00e1c v\u1ecb tr\u00ed A2, A3, A4<\/li>\n<li>S\u1ed1 ti\u1ebfp theo s\u1ebd l\u00e0 s\u1ed1 200,\u00a0ch\u00ednh l\u00e0 s\u1ed1 l\u1edbn h\u01a1n g\u1ea7n nh\u1ea5t v\u1edbi\u00a0s\u1ed1 195,\u00a0\u0111\u01b0\u1ee3c x\u00e1c\u00a0\u0111\u1ecbnh b\u1edfi h\u00e0m SMALL. K\u1ebft qu\u1ea3 s\u1ed1 nh\u1ecf h\u01a1n th\u1ee9 4\u00a0\u0111\u1ed3ng ngh\u0129a v\u1edbi s\u1ed1 l\u1edbn h\u01a1n g\u1ea7n nh\u1ea5t v\u1edbi s\u1ed1 195.<\/li>\n<\/ul>\n<p>Nh\u01b0 v\u1eady qua b\u00e0i vi\u1ebft n\u00e0y, ch\u00fang ta\u00a0\u0111\u00e3 bi\u1ebft th\u00eam 1\u00a0ph\u01b0\u01a1ng ph\u00e1p t\u00ecm gi\u00e1 tr\u1ecb l\u1edbn h\u01a1n g\u1ea7n nh\u1ea5t v\u1edbi 1 s\u1ed1 b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c h\u00e0m trong\u00a0Excel.<\/p>\n<p>Vi\u1ec7c s\u1eed d\u1ee5ng c\u00e1c h\u00e0m n\u00e0y th\u1eadt linh ho\u1ea1t v\u00e0\u00a0\u0111a d\u1ea1ng ph\u1ea3i kh\u00f4ng n\u00e0o. Khi ch\u00fang ta bi\u1ebft c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c h\u00e0m trong\u00a0excel, bi\u1ebft ph\u00e1t tri\u1ec3n t\u01b0 duy logic th\u00ec h\u1ea7u h\u1ebft m\u1ecdi v\u1ea5n\u00a0\u0111\u1ec1\u00a0\u0111\u1ec1u c\u00f3 th\u1ec3 gi\u1ea3i quy\u1ebft\u00a0\u0111\u01b0\u1ee3c.<\/p>\n<p>Ngo\u00e0i ra c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o m\u1ed9t s\u1ed1\u00a0b\u00e0i vi\u1ebft\u00a0\u0111\u1ec3 m\u1edf r\u1ed9ng th\u00eam ki\u1ebfn th\u1ee9c:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-4-cach-tim-gia-tri-lon-nhat-va-nho-nhat-trong-excel.html\">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<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/tim-gia-tri-gan-dung-nhat-bang-vba.html\">T\u00ecm gi\u00e1 tr\u1ecb g\u1ea7n \u0111\u00fang nh\u1ea5t b\u1eb1ng VBA<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-long-ghep-ham-viet-ham-long-nhau-trong-excel.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch l\u1ed3ng gh\u00e9p h\u00e0m, vi\u1ebft h\u00e0m l\u1ed3ng nhau trong Excel<\/a><\/p>\n<h3><\/h3>\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-43.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":9361,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-9360","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\/9360","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=9360"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/9360\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/9361"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=9360"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=9360"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=9360"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}