{"id":9373,"date":"2025-01-02T02:55:56","date_gmt":"2025-01-02T02:55:56","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/02\/huong-dan-cach-tim-gia-tri-nho-hon-gan-nhat-voi-gia-tri-so-sanh\/"},"modified":"2025-01-02T02:55:56","modified_gmt":"2025-01-02T02:55:56","slug":"huong-dan-cach-tim-gia-tri-nho-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-nho-hon-gan-nhat-voi-gia-tri-so-sanh\/","title":{"rendered":"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"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Khi\u00a0d\u00f2 t\u00ecm, tham chi\u1ebfu theo c\u00e1c gi\u00e1 tr\u1ecb s\u1ed1,\u00a0c\u00f3 th\u1ec3 b\u1ea1n s\u1ebd g\u1eb7p ph\u1ea3i y\u00eau c\u1ea7u t\u00ecm ra c\u00e1c gi\u00e1 tr\u1ecb nh\u1ecf h\u01a1n v\u00e0 g\u1ea7n nh\u1ea5t v\u1edbi gi\u00e1 tr\u1ecb so s\u00e1nh. V\u1eady l\u00e0m c\u00e1ch n\u00e0o\u00a0\u0111\u1ec3 th\u1ef1c hi\u1ec7n y\u00eau c\u1ea7u n\u00e0y? H\u00e3y c\u00f9ng t\u00ecm hi\u1ec3u c\u00e1ch l\u00e0m trong b\u00e0i vi\u1ebft n\u00e0y nh\u00e9.<\/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-6776003c1abc1\" 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-nho-hon-gan-nhat-voi-gia-tri-so-sanh.html#Tim_gia_tri_nho_hon_gan_nhat_trong_danh_sach_duoc_sap_xep\" title=\"T\u00ecm gi\u00e1 tr\u1ecb nh\u1ecf h\u01a1n g\u1ea7n nh\u1ea5t trong danh s\u00e1ch\u00a0\u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp\">T\u00ecm gi\u00e1 tr\u1ecb nh\u1ecf h\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-nho-hon-gan-nhat-voi-gia-tri-so-sanh.html#Su_dung_ham_LOOKUP\" title=\"S\u1eed d\u1ee5ng h\u00e0m LOOKUP\">S\u1eed d\u1ee5ng h\u00e0m LOOKUP<\/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-nho-hon-gan-nhat-voi-gia-tri-so-sanh.html#Su_dung_ham_VLOOKUP\" title=\"S\u1eed d\u1ee5ng h\u00e0m VLOOKUP\">S\u1eed d\u1ee5ng h\u00e0m VLOOKUP<\/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-nho-hon-gan-nhat-voi-gia-tri-so-sanh.html#Tim_gia_tri_nho_hon_gan_nhat_trong_danh_sach_khong_duoc_sap_xep\" title=\"T\u00ecm gi\u00e1 tr\u1ecb nh\u1ecf h\u01a1n g\u1ea7n nh\u1ea5t trong danh s\u00e1ch kh\u00f4ng\u00a0\u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp\">T\u00ecm gi\u00e1 tr\u1ecb nh\u1ecf h\u01a1n g\u1ea7n nh\u1ea5t trong danh s\u00e1ch kh\u00f4ng\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-5\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-tim-gia-tri-nho-hon-gan-nhat-voi-gia-tri-so-sanh.html#Xac_dinh_thu_tu_cua_so_nho_hon_gan_nhat_voi_ham_COUNTIF\" title=\"X\u00e1c\u00a0\u0111\u1ecbnh th\u1ee9 t\u1ef1 c\u1ee7a s\u1ed1 nh\u1ecf h\u01a1n g\u1ea7n nh\u1ea5t v\u1edbi h\u00e0m COUNTIF\">X\u00e1c\u00a0\u0111\u1ecbnh th\u1ee9 t\u1ef1 c\u1ee7a s\u1ed1 nh\u1ecf h\u01a1n g\u1ea7n nh\u1ea5t v\u1edbi h\u00e0m COUNTIF<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-tim-gia-tri-nho-hon-gan-nhat-voi-gia-tri-so-sanh.html#Xac_dinh_gia_tri_so_nho_hon_gan_nhat_voi_ham_LARGE\" title=\"X\u00e1c\u00a0\u0111\u1ecbnh\u00a0gi\u00e1\u00a0tr\u1ecb\u00a0s\u1ed1 nh\u1ecf h\u01a1n g\u1ea7n nh\u1ea5t v\u1edbi h\u00e0m\u00a0LARGE\">X\u00e1c\u00a0\u0111\u1ecbnh\u00a0gi\u00e1\u00a0tr\u1ecb\u00a0s\u1ed1 nh\u1ecf h\u01a1n g\u1ea7n nh\u1ea5t v\u1edbi h\u00e0m\u00a0LARGE<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Tim_gia_tri_nho_hon_gan_nhat_trong_danh_sach_duoc_sap_xep\"><\/span>T\u00ecm gi\u00e1 tr\u1ecb nh\u1ecf h\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><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24708\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/yeu-cau-01-tim-so-nho-hon-gan-nhat-ds-duoc-sap-xep.png\" width=\"494\" height=\"165\" title=\"yeu-cau-01-tim-so-nho-hon-gan-nhat-ds-duoc-sap-xep\"><\/p>\n<p>V\u00ed d\u1ee5 ch\u00fang ta c\u00f3 danh s\u00e1ch c\u00e1c s\u1ed1 ti\u00eau chu\u1ea9n\u00a0\u1edf c\u1ed9t A, t\u1eeb A2:A6. Trong danh s\u00e1ch c\u00e1c s\u1ed1\u1ed1 n\u00e0y\u00a0\u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp theo th\u1ee9 t\u1ef1 t\u0103ng d\u1ea7n.<\/p>\n<p>X\u00e1c\u00a0\u0111\u1ecbnh s\u1ed1\u00a0nh\u1ecf h\u01a1n g\u1ea7n nh\u1ea5t v\u1edbi gi\u00e1 tr\u1ecb s\u1ed1\u00a0\u1edf\u00a0\u00f4 C3.<\/p>\n<p>\u0110\u1ec3 th\u1ef1c hi\u1ec7n y\u00eau c\u1ea7u n\u00e0y, ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng 2 h\u00e0m l\u00e0 LOOKUP v\u00e0 VLOOKUP. C\u00e1ch l\u00e0m c\u1ee5 th\u1ec3 nh\u01b0 sau:<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Su_dung_ham_LOOKUP\"><\/span>S\u1eed d\u1ee5ng h\u00e0m LOOKUP<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/ham-lookup-va-cong-thuc-vi-du-trong-excel-2016-2013-2010-2007-2003.html\">H\u00e0m LOOKUP<\/a> l\u00e0 1 h\u00e0m t\u00ecm ki\u1ebfm c\u01a1 b\u1ea3n trong\u00a0Excel, trong\u00a0\u0111\u00f3 khi b\u1ea3ng d\u1eef li\u1ec7u ch\u1ee9a c\u00e1c gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm\u00a0\u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp theo th\u1ee9 t\u1ef1 t\u0103ng d\u1ea7n th\u00ec ch\u00fang ta c\u00f3 th\u1ec3 t\u00ecm\u00a0\u0111\u01b0\u1ee3c s\u1ed1 nh\u1ecf h\u01a1n g\u1ea7n nh\u1ea5t v\u1edbi s\u1ed1 c\u1ea7n t\u00ecm.<\/p>\n<p>T\u1ea1i\u00a0\u00f4 D3 ch\u00fang ta d\u00f9ng c\u00f4ng th\u1ee9c nh\u01b0 sau:<\/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-45.gif\" title=\"ex101_92019-nho-45\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24710\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/yeu-cau-01-tim-so-nho-hon-gan-nhat-ham-lookup.png\" width=\"574\" height=\"211\" title=\"yeu-cau-01-tim-so-nho-hon-gan-nhat-ham-lookup\"><\/p>\n<p>=LOOKUP(C3,$A$2:$A$6)<\/p>\n<p>Trong\u00a0\u0111\u00f3:<\/p>\n<ul>\n<li>Lookup_value = C3 l\u00e0 gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm<\/li>\n<li>Lookup_vector = A2:A6 l\u00e0 v\u00f9ng ch\u1ee9a c\u00e1c gi\u00e1 tr\u1ecb tham chi\u1ebfu.<\/li>\n<\/ul>\n<p>K\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m l\u00e0 200, l\u00e0 s\u1ed1 nh\u1ecf h\u01a1n 230 v\u00e0 g\u1ea7n nh\u1ea5t v\u1edbi s\u1ed1 230.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Su_dung_ham_VLOOKUP\"><\/span>S\u1eed d\u1ee5ng h\u00e0m VLOOKUP<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/ham-hlookup-trong-excel-va-cac-ung-dung-nang-cao-thuong-gap.html\">H\u00e0m VLOOKUP<\/a> c\u0169ng l\u00e0 1 h\u00e0m r\u1ea5t hay s\u1eed d\u1ee5ng trong\u00a0Excel. Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m VLOOKUP nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24712\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/yeu-cau-01-tim-so-nho-hon-gan-nhat-ham-vlookup.png\" width=\"609\" height=\"213\" title=\"yeu-cau-01-tim-so-nho-hon-gan-nhat-ham-vlookup\"><\/p>\n<p>E3=VLOOKUP(C3,$A$2:$A$6,1,1)<\/p>\n<ul>\n<li>lookup_value = C3 l\u00e0 gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm<\/li>\n<li>table_array = A2:A6 l\u00e0 v\u00f9ng c\u1ea7n tham chi\u1ebfu<\/li>\n<li>col_index_num = 1 v\u00ec ch\u1ec9 c\u00f3 1 c\u1ed9t trong v\u00f9ng tham chi\u1ebfu<\/li>\n<li>range_lookup = 1 l\u00e0 t\u00ecm ki\u1ebfm t\u01b0\u01a1ng\u00a0\u0111\u1ed1i, k\u1ebft qu\u1ea3 l\u00e0 gi\u00e1 tr\u1ecb nh\u1ecf h\u01a1n g\u1ea7n nh\u1ea5t.<\/li>\n<\/ul>\n<p>Khi s\u1eed d\u1ee5ng h\u00e0m VLOOKUP v\u1edbi range_lookup = 1 (hay TRUE) th\u00ec h\u00e0m s\u1ebd t\u00ecm ki\u1ebfm theo ph\u01b0\u01a1ng ph\u00e1p t\u01b0\u01a1ng\u00a0\u0111\u1ed1i, k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 l\u00e0 gi\u00e1 tr\u1ecb nh\u1ecf h\u01a1n g\u1ea7n nh\u1ea5t v\u1edbi s\u1ed1 c\u1ea7n t\u00ecm.<\/p>\n<p>Ch\u1ec9 th\u1ef1c hi\u1ec7n\u00a0\u0111\u01b0\u1ee3c\u00a0\u0111i\u1ec1u n\u00e0y khi:<\/p>\n<ul>\n<li>T\u00ecm ki\u1ebfm theo gi\u00e1 tr\u1ecb S\u1ed1<\/li>\n<li>V\u00f9ng c\u1ea7n tham chi\u1ebfu (v\u00f9ng k\u1ebft qu\u1ea3 c\u1ea7n t\u00ecm)\u00a0\u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp theo th\u1ee9 t\u1ef1 t\u0103ng d\u1ea7n<\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"Tim_gia_tri_nho_hon_gan_nhat_trong_danh_sach_khong_duoc_sap_xep\"><\/span>T\u00ecm gi\u00e1 tr\u1ecb nh\u1ecf h\u01a1n g\u1ea7n nh\u1ea5t trong danh s\u00e1ch kh\u00f4ng\u00a0\u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24713\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/yeu-cau-02-tim-so-nho-hon-gan-nhat-ds-ko-duoc-sap-xep.png\" width=\"583\" height=\"168\" title=\"yeu-cau-02-tim-so-nho-hon-gan-nhat-ds-ko-duoc-sap-xep\"><\/p>\n<p>Hai tr\u01b0\u1eddng h\u1ee3p tr\u00ean ch\u00fang ta\u00a0\u0111\u1ec1u th\u1ea5y danh s\u00e1ch Ti\u00eau chu\u1ea9n c\u1ea7n ph\u1ea3i\u00a0\u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp theo th\u1ee9 t\u1ef1 t\u0103ng d\u1ea7n th\u00ec m\u1edbi l\u00e0m\u00a0\u0111\u01b0\u1ee3c. V\u1eady n\u1ebfu nh\u01b0 danh s\u00e1ch n\u00e0y kh\u00f4ng\u00a0\u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp th\u00ec sao?<\/p>\n<p>\u0110\u1ec3 gi\u1ea3i quy\u1ebft y\u00eau c\u1ea7u n\u00e0y, ch\u00fang ta s\u1eed d\u1ee5ng 2 h\u00e0m LARGE v\u00e0 COUNTIF k\u1ebft h\u1ee3p v\u1edbi nhau.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Xac_dinh_thu_tu_cua_so_nho_hon_gan_nhat_voi_ham_COUNTIF\"><\/span>X\u00e1c\u00a0\u0111\u1ecbnh th\u1ee9 t\u1ef1 c\u1ee7a s\u1ed1 nh\u1ecf h\u01a1n g\u1ea7n nh\u1ea5t v\u1edbi h\u00e0m COUNTIF<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0110\u1ec3 t\u00ecm\u00a0\u0111\u01b0\u1ee3c s\u1ed1 nh\u1ecf h\u01a1n g\u1ea7n nh\u1ea5t, ch\u00fang ta s\u1ebd ngh\u0129 theo h\u01b0\u1edbng:<\/p>\n<ul>\n<li>C\u00f3 bao nhi\u00eau s\u1ed1 l\u1edbn h\u01a1n s\u1ed1 c\u1ea7n t\u00ecm?<\/li>\n<li>S\u1ed1 nh\u1ecf h\u01a1n g\u1ea7n nh\u1ea5t l\u00e0 v\u1ecb tr\u00ed th\u1ee9 m\u1ea5y?<\/li>\n<\/ul>\n<p>Khi\u00a0\u0111\u00f3 ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng <a href=\"http:\/\/blog.ezworkapp.com\/dem-co-dieu-kien-ham-countif-co-ban.html\">h\u00e0m COUNTIF<\/a> nh\u01b0 sau:<\/p>\n<blockquote>\n<p>D3=COUNTIF(A2:A6,\u201d&gt;\u201d&amp;C3)+1<\/p>\n<\/blockquote>\n<p>\u00dd ngh\u0129a c\u1ee7a h\u00e0m n\u00e0y l\u00e0:<\/p>\n<ul>\n<li>COUNTIF(A2:A6,\u201d&gt;\u201d&amp;C3)\u00a0\u0111\u1ebfm xem c\u00f3 bao nhi\u00eau s\u1ed1 trong v\u00f9ng A2:A6 c\u00f3 gi\u00e1 tr\u1ecb l\u1edbn h\u01a1n gi\u00e1 tr\u1ecb\u00a0\u1edf\u00a0\u00f4 C3<\/li>\n<li>COUNTIF(A2:A6,\u201d&gt;\u201d&amp;C3)+1 khi\u00a0\u0111\u00f3 gi\u00e1 tr\u1ecb nh\u1ecf h\u01a1n g\u1ea7n nh\u1ea5t s\u1ebd n\u1eb1m\u00a0\u1edf v\u1ecb tr\u00ed ti\u1ebfp theo (+1).<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24714\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/yeu-cau-02-tim-so-nho-hon-gan-nhat-ds-ko-duoc-sap-xep-countif.png\" width=\"604\" height=\"210\" title=\"yeu-cau-02-tim-so-nho-hon-gan-nhat-ds-ko-duoc-sap-xep-countif\"><\/p>\n<p>Trong v\u00ed d\u1ee5 tr\u00ean, ta th\u1ea5y k\u1ebft qu\u1ea3 b\u1eb1ng 2, t\u1ee9c l\u00e0:<\/p>\n<ul>\n<li>C\u00f3 1 s\u1ed1 trong danh s\u00e1ch Ti\u00eau chu\u1ea9n\u00a0l\u1edbn h\u01a1n s\u1ed1 230<\/li>\n<li>V\u1ecb tr\u00ed s\u1ed1 nh\u1ecf h\u01a1n g\u1ea7n nh\u1ea5t v\u1edbi s\u1ed1 230 l\u00e0 v\u1ecb tr\u00ed s\u1ed1 l\u1edbn th\u1ee9 2 trong danh s\u00e1ch Ti\u00eau chu\u1ea9n<\/li>\n<\/ul>\n<p>=&gt;\u00a0\u0110\u1ec3 x\u00e1c\u00a0\u0111\u1ecbnh c\u1ee5 th\u1ec3\u00a0\u0111\u00f3 l\u00e0 s\u1ed1\u00a0n\u00e0o, ch\u00fang ta d\u00f9ng th\u00eam h\u00e0m LARGE<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Xac_dinh_gia_tri_so_nho_hon_gan_nhat_voi_ham_LARGE\"><\/span>X\u00e1c\u00a0\u0111\u1ecbnh\u00a0gi\u00e1\u00a0tr\u1ecb\u00a0s\u1ed1 nh\u1ecf h\u01a1n g\u1ea7n nh\u1ea5t v\u1edbi h\u00e0m\u00a0LARGE<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/ham-large-va-ham-small-trong-excel.html\">H\u00e0m Large<\/a> l\u00e0 h\u00e0m gi\u00fap t\u00ecm s\u1ed1 l\u1edbn th\u1ee9 m\u1ea5y\u00a0\u1edf trong 1 d\u00e3y s\u1ed1.<\/p>\n<p>Trong h\u00e0m COUNTIF\u00a0\u1edf tr\u00ean, ch\u00fang ta\u00a0\u0111\u00e3 x\u00e1c\u00a0\u0111\u1ecbnh\u00a0\u0111\u01b0\u1ee3c s\u1ed1 nh\u1ecf h\u01a1n g\u1ea7n nh\u1ea5t n\u1eb1m\u00a0\u1edf v\u1ecb tr\u00ed s\u1ed1 l\u1edbn th\u1ee9 m\u1ea5y trong danh s\u00e1ch. V\u00ec v\u1eady s\u1ebd r\u1ea5t\u00a0\u0111\u01a1n gi\u1ea3n\u00a0\u0111\u1ec3\u00a0\u00e1p d\u1ee5ng v\u1edbi h\u00e0m LARGE.<\/p>\n<p>C\u00e1ch l\u00e0m nh\u01b0 sau:<\/p>\n<blockquote>\n<p>E3=LARGE(A2:A6,D3)<\/p>\n<p>hay\u00a0E3=LARGE(A2:A6,COUNTIF(A2:A6,\u201d&gt;\u201d&amp;C3)+1)<\/p>\n<\/blockquote>\n<p>K\u1ebft qu\u1ea3 nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24715\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/yeu-cau-02-tim-so-nho-hon-gan-nhat-ds-ko-duoc-sap-xep-large.png\" width=\"583\" height=\"212\" title=\"yeu-cau-02-tim-so-nho-hon-gan-nhat-ds-ko-duoc-sap-xep-large\"><\/p>\n<p>X\u00e9t v\u00ed d\u1ee5 s\u1ed1 kh\u00e1c:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24716\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ket-qua-ham-large-tim-so-nho-hon-gan-nhat-02.png\" width=\"578\" height=\"165\" title=\"ket-qua-ham-large-tim-so-nho-hon-gan-nhat-02\"><\/p>\n<p>R\u1ea5t th\u00fa v\u1ecb ph\u1ea3i kh\u00f4ng n\u00e0o. Ngo\u00e0i ra c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 t\u00ecm hi\u1ec3u th\u00eam m\u1ed9t s\u1ed1 b\u00e0i vi\u1ebft\u00a0c\u00f3 ch\u1ee7\u00a0\u0111\u1ec1 t\u01b0\u01a1ng t\u1ef1:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-tim-gia-tri-lon-hon-gan-nhat-voi-gia-tri-so-sanh.html\">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<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/cach-su-dung-ham-vlookup-ket-hop-ham-match-khi-tim-theo-nhieu-cot-chua-ket-qua.html\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m vlookup k\u1ebft h\u1ee3p h\u00e0m Match khi t\u00ecm theo nhi\u1ec1u c\u1ed9t ch\u1ee9a k\u1ebft qu\u1ea3<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/ham-tim-kiem-vlookup-va-hlookup-trong-excel.html\">H\u00e0m t\u00ecm ki\u1ebfm VLOOKUP v\u00e0 HLOOKUP trong Excel<\/a><\/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\/cach-tra-cuu-ngay-lon-nhat-hay-gia-tri-thoa-man-nhieu-dieu-kien.html\">C\u00e1ch tra c\u1ee9u ng\u00e0y l\u1edbn nh\u1ea5t hay gi\u00e1 tr\u1ecb th\u1ecfa m\u00e3n nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/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<\/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-45.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":9374,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-9373","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\/9373","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=9373"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/9373\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/9374"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=9373"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=9373"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=9373"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}