{"id":5063,"date":"2025-11-21T11:38:24","date_gmt":"2025-11-21T04:38:24","guid":{"rendered":"https:\/\/autofillform.com\/blog\/ham-large-trong-excel-va-cach-su-dung-hieu-qua\/"},"modified":"2025-11-21T11:38:24","modified_gmt":"2025-11-21T04:38:24","slug":"ham-large-trong-excel-va-cach-su-dung-hieu-qua","status":"publish","type":"post","link":"https:\/\/autofillform.com\/blog\/ham-large-trong-excel-va-cach-su-dung-hieu-qua\/","title":{"rendered":"H\u00e0m LARGE trong Excel v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng hi\u1ec7u qu\u1ea3"},"content":{"rendered":"
\n
\u00a0<\/div>\n

H\u00e0m LARGE l\u00e0 c\u00f4ng c\u1ee5 h\u1eefu \u00edch khi b\u1ea1n c\u1ea7n x\u00e1c \u0111\u1ecbnh c\u00e1c gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t theo th\u1ee9 h\u1ea1ng trong Excel. B\u00e0i vi\u1ebft n\u00e0y s\u1ebd gi\u00fap b\u1ea1n hi\u1ec3u r\u00f5 h\u00e0m LARGE trong Excel, t\u1eeb kh\u00e1i ni\u1ec7m, c\u00fa ph\u00e1p, v\u00ed d\u1ee5 minh h\u1ecda \u0111\u1ebfn c\u00e1ch k\u1ebft h\u1ee3p v\u1edbi c\u00e1c h\u00e0m kh\u00e1c nh\u01b0 INDEX, MATCH v\u00e0 \u1ee9ng d\u1ee5ng trong \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n, k\u00e8m theo nh\u1eefng l\u01b0u \u00fd quan tr\u1ecdng khi s\u1eed d\u1ee5ng.<\/p>\n

\"H\u01b0\u1edbngC\u00e1ch s\u1eed d\u1ee5ng h\u00e0m LARGE trong Excel hi\u1ec7u qu\u1ea3<\/em><\/p>\n

\n

1. H\u00e0m LARGE l\u00e0 g\u00ec?<\/h2>\n<\/div>\n

H\u00e0m LARGE trong Excel l\u00e0 h\u00e0m d\u00f9ng \u0111\u1ec3 tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb l\u1edbn th\u1ee9 k trong m\u1ed9t t\u1eadp d\u1eef li\u1ec7u. H\u00e0m gi\u00fap b\u1ea1n truy xu\u1ea5t m\u1ed9t gi\u00e1 tr\u1ecb d\u1ef1a tr\u00ean v\u1ecb tr\u00ed x\u1ebfp h\u1ea1ng c\u1ee7a n\u00f3 theo th\u1ee9 t\u1ef1 t\u1eeb l\u1edbn \u0111\u1ebfn nh\u1ecf. Nh\u1edd \u0111\u00f3, b\u1ea1n c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng l\u1ea5y ra \u0111i\u1ec3m cao nh\u1ea5t, cao th\u1ee9 hai, cao th\u1ee9 ba ho\u1eb7c b\u1ea5t k\u1ef3 th\u1ee9 h\u1ea1ng n\u00e0o trong danh s\u00e1ch s\u1ed1 li\u1ec7u.<\/p>\n

Xem th\u00eam: <\/strong>H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m SMALL trong Excel c\u1ef1c d\u1ec5 hi\u1ec3u<\/div>\n
\n

2. C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m LARGE trong Excel<\/h2>\n<\/div>\n
\n

2.1. C\u00f4ng th\u1ee9c h\u00e0m LARGE<\/h3>\n<\/div>\n

C\u00fa ph\u00e1p c\u01a1 b\u1ea3n c\u1ee7a h\u00e0m l\u00e0: =LARGE(array, k)<\/strong><\/p>\n

Trong \u0111\u00f3, hai tham s\u1ed1 \u0111\u1ec1u b\u1eaft bu\u1ed9c:<\/p>\n

    \n
  • array:<\/strong> V\u00f9ng d\u1eef li\u1ec7u ho\u1eb7c t\u1eadp gi\u00e1 tr\u1ecb m\u00e0 b\u1ea1n mu\u1ed1n t\u00ecm s\u1ed1 \u0111\u1ee9ng \u1edf v\u1ecb tr\u00ed k t\u00ednh t\u1eeb l\u1edbn xu\u1ed1ng nh\u1ecf.<\/li>\n
  • k: <\/strong>Th\u1ee9 h\u1ea1ng c\u1ea7n l\u1ea5y trong danh s\u00e1ch (1 l\u00e0 l\u1edbn nh\u1ea5t, ti\u1ebfp theo l\u00e0 2, 3,\u2026).<\/li>\n<\/ul>\n

    N\u1ebfu ph\u1ea1m vi c\u00f3 n gi\u00e1 tr\u1ecb, b\u1ea1n c\u00f3 th\u1ec3 hi\u1ec3u nhanh nh\u01b0 sau:<\/p>\n

      \n
    • LARGE(array,1) <\/strong>s\u1ebd tr\u1ea3 v\u1ec1 s\u1ed1 l\u1edbn nh\u1ea5t trong danh s\u00e1ch.<\/li>\n
    • LARGE(array,n)<\/strong> s\u1ebd tr\u1ea3 v\u1ec1 s\u1ed1 nh\u1ecf nh\u1ea5t trong danh s\u00e1ch.<\/li>\n<\/ul>\n

      \"C\u00faC\u00fa ph\u00e1p c\u1ee7a h\u00e0m LARGE trong Excel<\/em><\/p>\n

      \n

      2.2. V\u00ed d\u1ee5 v\u1ec1 h\u00e0m LARGE<\/h3>\n<\/div>\n

      X\u00e1c \u0111\u1ecbnh gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t v\u00e0 l\u1edbn th\u1ee9 hai trong d\u00e3y s\u1ed1<\/strong><\/p>\n

      B\u01b0\u1edbc 1: <\/strong>T\u1ea1i \u00f4 B7<\/strong>, nh\u1eadp c\u00f4ng th\u1ee9c: =LARGE(A2:B6,1)<\/strong><\/p>\n

      Trong \u0111\u00f3 A2:B6 l\u00e0 v\u00f9ng d\u1eef li\u1ec7u c\u1ea7n ph\u00e2n t\u00edch v\u00e0 1 \u0111\u1ea1i di\u1ec7n cho gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t.<\/p>\n

      B\u01b0\u1edbc 2: <\/strong>Nh\u1ea5n Enter<\/strong> \u0111\u1ec3 hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3, \u0111\u00e2y ch\u00ednh l\u00e0 s\u1ed1 l\u1edbn nh\u1ea5t trong to\u00e0n b\u1ed9 ph\u1ea1m vi.<\/p>\n

      \"V\u00ed\u1ee8ng d\u1ee5ng h\u00e0m LARGE \u0111\u1ec3 t\u00ecm gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t trong danh s\u00e1ch<\/em><\/p>\n

      Ti\u1ebfp theo, \u0111\u1ec3 l\u1ea5y s\u1ed1 l\u1edbn th\u1ee9 hai:<\/p>\n

      B\u01b0\u1edbc 1:<\/strong> T\u1ea1i \u00f4 B8<\/strong>, nh\u1eadp c\u00f4ng th\u1ee9c: =LARGE(A2:B6,2)<\/strong><\/p>\n

      Tham s\u1ed1 2<\/strong> y\u00eau c\u1ea7u h\u00e0m tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb \u0111\u1ee9ng th\u1ee9 hai theo th\u1ee9 t\u1ef1 gi\u1ea3m d\u1ea7n.<\/p>\n

      B\u01b0\u1edbc 2:<\/strong> Nh\u1ea5n Enter<\/strong> \u0111\u1ec3 xem k\u1ebft qu\u1ea3 s\u1ed1 l\u1edbn th\u1ee9 hai trong d\u00e3y d\u1eef li\u1ec7u.<\/p>\n

      \"V\u00edC\u00e1ch l\u1ea5y gi\u00e1 tr\u1ecb l\u1edbn th\u1ee9 hai trong danh s\u00e1ch b\u1eb1ng h\u00e0m LARGE<\/em><\/p>\n

      \n

      3. H\u00e0m LARGE k\u1ebft h\u1ee3p v\u1edbi m\u1ed9t s\u1ed1 h\u00e0m kh\u00e1c<\/h2>\n<\/div>\n
      \n

      3.1. K\u1ebft h\u1ee3p v\u1edbi h\u00e0m INDEX v\u00e0 h\u00e0m MATCH<\/h3>\n<\/div>\n

      B\u1ea1n c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p h\u00e0m LARGE v\u1edbi INDEX v\u00e0 MATCH \u0111\u1ec3 t\u00ecm gi\u00e1 tr\u1ecb l\u1edbn th\u1ee9 n v\u00e0 \u0111\u1ed3ng th\u1eddi l\u1ea5y th\u00f4ng tin li\u00ean quan \u1edf c\u1ed9t kh\u00e1c. C\u00e1ch k\u1ebft h\u1ee3p n\u00e0y r\u1ea5t h\u1eefu \u00edch khi b\u1ea1n mu\u1ed1n truy xu\u1ea5t t\u00ean h\u1ecdc sinh theo th\u1ee9 h\u1ea1ng \u0111i\u1ec3m s\u1ed1, nh\u01b0 \u0111i\u1ec3m cao nh\u1ea5t, cao th\u1ee9 hai ho\u1eb7c c\u00e1c v\u1ecb tr\u00ed ti\u1ebfp theo trong b\u1ea3ng.<\/p>\n

      Gi\u1ea3 s\u1eed b\u1ea3ng d\u1eef li\u1ec7u c\u00f3 c\u1ed9t T\u00ean<\/strong> v\u00e0 \u0110i\u1ec3m<\/strong>, v\u00e0 b\u1ea1n mu\u1ed1n t\u00ecm h\u1ecdc sinh c\u00f3 \u0111i\u1ec3m cao th\u1ee9 hai<\/strong>.<\/p>\n

      Khi \u0111\u00f3, b\u1ea1n d\u00f9ng c\u00f4ng th\u1ee9c:<\/p>\n

      =INDEX(A2:A10, MATCH(LARGE(B2:B10, 2), B2:B10, 0))<\/strong><\/p>\n

      \"H\u00e0mC\u00e1ch d\u00f9ng LARGE k\u1ebft h\u1ee3p INDEX v\u00e0 MATCH \u0111\u1ec3 t\u00ecm t\u00ean theo th\u1ee9 h\u1ea1ng<\/em><\/p>\n

      Gi\u1ea3i th\u00edch c\u00f4ng th\u1ee9c theo d\u1eef li\u1ec7u trong h\u00ecnh:<\/strong><\/p>\n

        \n
      • LARGE(B2:B10, 2): <\/strong>Tr\u1ea3 v\u1ec1 \u0111i\u1ec3m l\u1edbn th\u1ee9 hai trong danh s\u00e1ch, ch\u00ednh l\u00e0 91.<\/li>\n
      • MATCH(91, B2:B10, 0):<\/strong> T\u00ecm v\u1ecb tr\u00ed c\u1ee7a \u0111i\u1ec3m 91 trong c\u1ed9t \u0110i\u1ec3m.<\/li>\n
      • INDEX(A2:A10, \u2026):<\/strong> D\u00f9ng v\u1ecb tr\u00ed v\u1eeba t\u00ecm \u0111\u1ec3 tr\u1ea3 v\u1ec1 t\u00ean h\u1ecdc sinh t\u01b0\u01a1ng \u1ee9ng \u1edf c\u1ed9t T\u00ean \u2192 k\u1ebft qu\u1ea3 l\u00e0 Vy.<\/li>\n<\/ul>\n

        V\u1edbi b\u1ea3ng d\u1eef li\u1ec7u tr\u00ean, c\u00f4ng th\u1ee9c s\u1ebd tr\u1ea3 v\u1ec1 \u201cVy<\/strong>\u201d, l\u00e0 h\u1ecdc sinh c\u00f3 \u0111i\u1ec3m \u0111\u1ee9ng th\u1ee9 hai.<\/p>\n

        \"H\u00e0mK\u1ebft qu\u1ea3 truy xu\u1ea5t t\u00ean h\u1ecdc sinh x\u1ebfp h\u1ea1ng th\u1ee9 hai<\/em><\/p>\n

        \n

        3.2. K\u1ebft h\u1ee3p ch\u1ee9c n\u0103ng \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n<\/h3>\n<\/div>\n

        B\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng h\u00e0m LARGE c\u00f9ng t\u00ednh n\u0103ng \u0110\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n \u0111\u1ec3 l\u00e0m n\u1ed5i b\u1eadt c\u00e1c gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t trong b\u1ea3ng d\u1eef li\u1ec7u. C\u00e1ch n\u00e0y gi\u00fap nhanh ch\u00f3ng nh\u1eadn ra nh\u1eefng con s\u1ed1 quan tr\u1ecdng, ch\u1eb3ng h\u1ea1n nh\u01b0 top 3 doanh thu cao nh\u1ea5t.<\/p>\n

        V\u00ed d\u1ee5: T\u00f4 m\u00e0u 3 gi\u00e1 tr\u1ecb doanh thu l\u1edbn nh\u1ea5t<\/strong><\/p>\n

        B\u01b0\u1edbc 1: <\/strong>Ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u doanh thu (B2:B10).<\/p>\n

        \"Ch\u1ecdnT\u00f4 v\u00f9ng d\u1eef li\u1ec7u doanh thu<\/em><\/p>\n

        B\u01b0\u1edbc 2:<\/strong> V\u00e0o Home <\/strong>\u2192 Conditional Formatting<\/strong> \u2192 New Rule<\/strong>.<\/p>\n

        \"M\u1edfThi\u1ebft l\u1eadp quy t\u1eafc m\u1edbi trong Conditional Formatting<\/em><\/p>\n

        B\u01b0\u1edbc 3<\/strong>: Ch\u1ecdn Use a formula to determine which cells to format<\/strong>.<\/p>\n

        \"Thi\u1ebftThi\u1ebft l\u1eadp c\u00f4ng th\u1ee9c \u0111\u1ec3 \u00e1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n theo gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t<\/em><\/p>\n

        B\u01b0\u1edbc 4:<\/strong> Nh\u1eadp c\u00f4ng th\u1ee9c \u0111\u1ec3 t\u00f4 m\u00e0u t\u1eebng gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t, v\u00ed d\u1ee5:<\/p>\n

          \n
        • =B2=LARGE($B$2:$B$10,1)<\/li>\n
        • =B2=LARGE($B$2:$B$10,2)<\/li>\n
        • =B2=LARGE($B$2:$B$10,3)<\/li>\n<\/ul>\n

          Thi\u1ebft l\u1eadp m\u00e0u n\u1ec1n cho m\u1ed7i quy t\u1eafc v\u00e0 l\u1ea7n l\u01b0\u1ee3t t\u1ea1o \u0111\u1ee7 3 quy t\u1eafc.<\/p>\n

          \"H\u00e0mNh\u1eadp c\u00f4ng th\u1ee9c s\u1eed d\u1ee5ng h\u00e0m LARGE \u0111\u1ec3 l\u00e0m n\u1ed5i b\u1eadt t\u1eebng gi\u00e1 tr\u1ecb \u0111\u1ee9ng \u0111\u1ea7u<\/em><\/p>\n

          Sau khi ho\u00e0n t\u1ea5t, c\u00e1c \u00f4 ch\u1ee9a top 3 doanh thu s\u1ebd \u0111\u01b0\u1ee3c l\u00e0m n\u1ed5i b\u1eadt, gi\u00fap b\u1ea1n quan s\u00e1t v\u00e0 so s\u00e1nh d\u1eef li\u1ec7u d\u1ec5 d\u00e0ng h\u01a1n.<\/p>\n

          \"B\u1ea3ngK\u1ebft qu\u1ea3 t\u00f4 m\u00e0u top 3 doanh thu sau khi \u00e1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n<\/em><\/p>\n

          \n

          4. M\u1ed9t s\u1ed1 l\u01b0u \u00fd khi s\u1eed d\u1ee5ng h\u00e0m LARGE trong Excel<\/h2>\n<\/div>\n

          Trong qu\u00e1 tr\u00ecnh d\u00f9ng h\u00e0m LARGE, b\u1ea1n c\u00f3 th\u1ec3 g\u1eb7p m\u1ed9t s\u1ed1 l\u1ed7i ph\u1ed5 bi\u1ebfn sau:<\/p>\n

            \n
          • N\u1ebfu array<\/strong> kh\u00f4ng ch\u1ee9a d\u1eef li\u1ec7u, h\u00e0m s\u1ebd tr\u1ea3 v\u1ec1 l\u1ed7i #NUM!<\/strong><\/li>\n
          • N\u1ebfu k<\/strong> nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng 0, ho\u1eb7c l\u1edbn h\u01a1n t\u1ed5ng s\u1ed1 gi\u00e1 tr\u1ecb trong m\u1ea3ng, k\u1ebft qu\u1ea3 c\u0169ng s\u1ebd l\u00e0 l\u1ed7i #NUM!<\/strong><\/li>\n<\/ul>\n

            \"L\u1ed7iL\u1ed7i #NUM khi tham s\u1ed1 c\u1ee7a h\u00e0m LARGE kh\u00f4ng h\u1ee3p l\u1ec7<\/em><\/p>\n

            H\u00e0m LARGE gi\u00fap b\u1ea1n nhanh ch\u00f3ng x\u00e1c \u0111\u1ecbnh c\u00e1c gi\u00e1 tr\u1ecb n\u1ed5i b\u1eadt trong b\u1ea3ng d\u1eef li\u1ec7u v\u00e0 h\u1ed7 tr\u1ee3 ph\u00e2n t\u00edch hi\u1ec7u qu\u1ea3 h\u01a1n. N\u1ebfu mu\u1ed1n h\u1ecdc th\u00eam nhi\u1ec1u m\u1eb9o Excel h\u1eefu \u00edch, h\u00e3y theo d\u00f5i chuy\u00ean m\u1ee5c Kinh nghi\u1ec7m c\u1ee7a Si\u00eau Th\u1ecb \u0110i\u1ec7n M\u00e1y – N\u1ed9i Th\u1ea5t Ch\u1ee3 L\u1edbn \u0111\u1ec3 c\u1eadp nh\u1eadt ki\u1ebfn th\u1ee9c m\u1ed7i ng\u00e0y.<\/p>\n

            N\u1ebfu b\u1ea1n mu\u1ed1n n\u00e2ng c\u1ea5p thi\u1ebft b\u1ecb ph\u1ee5c v\u1ee5 h\u1ecdc t\u1eadp v\u00e0 l\u00e0m vi\u1ec7c, h\u00e3y tham kh\u1ea3o ngay c\u00e1c m\u1eabu \u0111i\u1ec7n tho\u1ea1i v\u00e0 m\u00e1y t\u00ednh b\u1ea3ng hi\u1ec7u n\u0103ng t\u1ed1t, m\u00e0n h\u00ecnh s\u1eafc n\u00e9t \u0111ang \u0111\u01b0\u1ee3c \u01b0u \u0111\u00e3i t\u1ea1i Si\u00eau Th\u1ecb \u0110i\u1ec7n M\u00e1y – N\u1ed9i Th\u1ea5t Ch\u1ee3 L\u1edbn.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

            \u00a0 H\u00e0m LARGE l\u00e0 c\u00f4ng c\u1ee5 h\u1eefu \u00edch khi b\u1ea1n c\u1ea7n x\u00e1c \u0111\u1ecbnh c\u00e1c gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t theo th\u1ee9 h\u1ea1ng trong Excel. B\u00e0i vi\u1ebft n\u00e0y s\u1ebd gi\u00fap b\u1ea1n hi\u1ec3u r\u00f5 h\u00e0m LARGE trong Excel, t\u1eeb kh\u00e1i ni\u1ec7m, c\u00fa ph\u00e1p, v\u00ed d\u1ee5 minh h\u1ecda \u0111\u1ebfn c\u00e1ch k\u1ebft h\u1ee3p v\u1edbi c\u00e1c h\u00e0m kh\u00e1c nh\u01b0 INDEX, MATCH […]<\/p>\n","protected":false},"author":1,"featured_media":5064,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-5063","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-thu-thuat"],"jetpack_featured_media_url":"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/11\/19405.jpg","_links":{"self":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts\/5063","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/comments?post=5063"}],"version-history":[{"count":0,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts\/5063\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/media\/5064"}],"wp:attachment":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/media?parent=5063"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/categories?post=5063"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/tags?post=5063"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}