{"id":5917,"date":"2025-12-05T17:20:48","date_gmt":"2025-12-05T10:20:48","guid":{"rendered":"https:\/\/autofillform.com\/blog\/cach-dung-ham-min-max-trong-excel-va-vi-du-cu-the\/"},"modified":"2025-12-05T17:20:48","modified_gmt":"2025-12-05T10:20:48","slug":"cach-dung-ham-min-max-trong-excel-va-vi-du-cu-the","status":"publish","type":"post","link":"https:\/\/autofillform.com\/blog\/cach-dung-ham-min-max-trong-excel-va-vi-du-cu-the\/","title":{"rendered":"C\u00e1ch d\u00f9ng h\u00e0m MIN MAX trong Excel v\u00e0 v\u00ed d\u1ee5 c\u1ee5 th\u1ec3"},"content":{"rendered":"
\n
\u00a0<\/div>\n

Trong Excel, h\u00e0m MIN v\u00e0 MAX l\u00e0 hai c\u00f4ng c\u1ee5 quan tr\u1ecdng gi\u00fap b\u1ea1n nhanh ch\u00f3ng x\u00e1c \u0111\u1ecbnh gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t v\u00e0 l\u1edbn nh\u1ea5t trong d\u1eef li\u1ec7u. Vi\u1ec7c n\u1eafm v\u1eefng c\u00e1ch s\u1eed d\u1ee5ng hai h\u00e0m n\u00e0y kh\u00f4ng ch\u1ec9 h\u1ed7 tr\u1ee3 ph\u00e2n t\u00edch ch\u00ednh x\u00e1c m\u00e0 c\u00f2n ti\u1ebft ki\u1ec7m th\u1eddi gian khi x\u1eed l\u00fd b\u1ea3ng t\u00ednh. H\u00e3y c\u00f9ng t\u00ecm hi\u1ec3u chi ti\u1ebft c\u00e1ch d\u00f9ng MIN v\u00e0 MAX trong b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y.<\/p>\n

\"C\u00e1chH\u01b0\u1edbng d\u1eabn chi ti\u1ebft c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m MIN, MAX trong Excel<\/em><\/p>\n

\n

1. H\u00e0m MAX<\/h2>\n<\/div>\n
\n

1.1 C\u00f4ng th\u1ee9c h\u00e0m MAX<\/h3>\n<\/div>\n

H\u00e0m MAX \u0111\u01b0\u1ee3c d\u00f9ng r\u1ed9ng r\u00e3i trong th\u1ed1ng k\u00ea v\u00e0 ph\u00e2n t\u00edch d\u1eef li\u1ec7u nh\u1eb1m t\u00ecm gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t trong m\u1ed9t ph\u1ea1m vi. \u0110\u00e2y l\u00e0 h\u00e0m quan tr\u1ecdng \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh \u0111i\u1ec3m cao nh\u1ea5t, doanh s\u1ed1 t\u1ed1t nh\u1ea5t ho\u1eb7c m\u1ee9c t\u0103ng tr\u01b0\u1edfng n\u1ed5i b\u1eadt trong b\u1ea3ng t\u00ednh.<\/p>\n

C\u00fa ph\u00e1p c\u1ee7a h\u00e0m MAX: <\/strong>=MAX(number1, number2,…)<\/p>\n

Trong \u0111\u00f3:<\/p>\n

    \n
  • number1, number2, \u2026<\/strong>: L\u00e0 c\u00e1c s\u1ed1 ho\u1eb7c gi\u00e1 tr\u1ecb m\u00e0 b\u1ea1n mu\u1ed1n so s\u00e1nh \u0111\u1ec3 t\u00ecm ra gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t.<\/li>\n<\/ul>\n

    \"C\u00faC\u00f4ng th\u1ee9c s\u1eed d\u1ee5ng h\u00e0m MAX trong Excel<\/em><\/p>\n

    \n

    1.2 V\u00ed d\u1ee5 v\u1ec1 h\u00e0m MAX<\/h3>\n<\/div>\n

    V\u00ed d\u1ee5 1: <\/strong>T\u00ecm \u0111i\u1ec3m cao nh\u1ea5t trong l\u1edbp<\/p>\n

    B\u01b0\u1edbc 1:<\/strong> T\u1ea1i \u00f4 b\u1ea1n mu\u1ed1n hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3, h\u00e3y g\u00f5 c\u00f4ng th\u1ee9c: =MAX(C2:E6).<\/p>\n

    Trong \u0111\u00f3, C2:E6 l\u00e0 ph\u1ea1m vi ch\u1ee9a c\u00e1c \u0111i\u1ec3m c\u1ea7n so s\u00e1nh \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t.<\/p>\n

    \"G\u00f5Nh\u1eadp h\u00e0m MAX \u0111\u1ec3 t\u00ecm \u0111i\u1ec3m cao nh\u1ea5t l\u1edbp<\/em><\/p>\n

    B\u01b0\u1edbc 2:<\/strong> Nh\u1ea5n ENTER \u0111\u1ec3 Excel x\u1eed l\u00fd v\u00e0 tr\u1ea3 v\u1ec1 \u0111i\u1ec3m cao nh\u1ea5t trong v\u00f9ng d\u1eef li\u1ec7u \u0111\u00e3 ch\u1ecdn.<\/p>\n

    \"K\u1ebftK\u1ebft qu\u1ea3 \u0111i\u1ec3m cao nh\u1ea5t sau khi d\u00f9ng h\u00e0m MAX<\/em><\/p>\n

    V\u00ed d\u1ee5 2: <\/strong>T\u00ecm m\u1ee9c doanh thu cao nh\u1ea5t trong th\u00e1ng<\/p>\n

    B\u01b0\u1edbc 1: <\/strong>T\u1ea1i \u00f4 d\u00f9ng \u0111\u1ec3 hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3, nh\u1eadp c\u00f4ng th\u1ee9c: =MAX(D23:D27).<\/p>\n

    \"Nh\u1eadpNh\u1eadp c\u00f4ng th\u1ee9c MAX \u0111\u1ec3 t\u00ecm doanh s\u1ed1 cao nh\u1ea5t<\/em><\/p>\n

    B\u01b0\u1edbc 2: <\/strong>Nh\u1ea5n ENTER \u0111\u1ec3 ho\u00e0n t\u1ea5t. Excel s\u1ebd t\u1ef1 \u0111\u1ed9ng t\u00ednh to\u00e1n v\u00e0 hi\u1ec3n th\u1ecb m\u1ee9c doanh s\u1ed1 cao nh\u1ea5t trong danh s\u00e1ch. C\u1ee5 th\u1ec3 k\u1ebft qu\u1ea3 \u1edf \u0111\u00e2y l\u00e0 150.000.000<\/p>\n

    \"K\u1ebftK\u1ebft qu\u1ea3 doanh s\u1ed1 cao nh\u1ea5t sau khi d\u00f9ng h\u00e0m MAX<\/em><\/p>\n

    \n

    1.3 L\u01b0u \u00fd khi d\u00f9ng h\u00e0m MAX<\/h3>\n<\/div>\n

    Khi s\u1eed d\u1ee5ng h\u00e0m MAX trong Excel, b\u1ea1n c\u1ea7n l\u01b0u \u00fd m\u1ed9t s\u1ed1 \u0111i\u1ec3m quan tr\u1ecdng \u0111\u1ec3 tr\u00e1nh sai s\u00f3t trong qu\u00e1 tr\u00ecnh t\u00ednh to\u00e1n:<\/p>\n

      \n
    • N\u1ebfu b\u1ea1n nh\u1eadp v\u00e0o h\u00e0m c\u00e1c gi\u00e1 tr\u1ecb kh\u00f4ng ph\u1ea3i d\u1ea1ng s\u1ed1, Excel s\u1ebd b\u00e1o l\u1ed7i #VALUE!.<\/li>\n
    • Tr\u01b0\u1eddng h\u1ee3p c\u00e1c tham s\u1ed1 kh\u00f4ng ch\u1ee9a s\u1ed1, h\u00e0m MAX s\u1ebd tr\u1ea3 v\u1ec1 0.<\/li>\n
    • MAX s\u1ebd kh\u00f4ng t\u00ednh \u0111\u1ebfn nh\u1eefng \u00f4 r\u1ed7ng ho\u1eb7c nh\u1eefng \u00f4 kh\u00f4ng c\u00f3 gi\u00e1 tr\u1ecb ph\u00f9 h\u1ee3p.<\/li>\n
    • N\u1ebfu b\u1ea3ng t\u00ednh c\u1ee7a b\u1ea1n c\u00f3 ch\u1ee9a gi\u00e1 tr\u1ecb TRUE\/FALSE, h\u00e3y d\u00f9ng h\u00e0m MAXA v\u00ec h\u00e0m n\u00e0y chuy\u1ec3n \u0111\u1ed5i TRUE th\u00e0nh 1 v\u00e0 FALSE th\u00e0nh 0 tr\u01b0\u1edbc khi t\u00ednh to\u00e1n.<\/li>\n
    • Trong Excel 2010 tr\u1edf \u0111i, h\u00e0m MAX cho ph\u00e9p s\u1eed d\u1ee5ng t\u1ed1i \u0111a 255 tham s\u1ed1.<\/li>\n
    • C\u00e1c gi\u00e1 tr\u1ecb \u0111\u01b0a v\u00e0o h\u00e0m MAX c\u00f3 th\u1ec3 l\u00e0 s\u1ed1, t\u00ean v\u00f9ng, m\u1ea3ng ho\u1eb7c \u00f4 tham chi\u1ebfu c\u00f3 ch\u1ee9a gi\u00e1 tr\u1ecb s\u1ed1.<\/li>\n<\/ul>\n
      Xem th\u00eam: <\/strong>C\u00e1ch d\u00f9ng h\u00e0m REPLACE v\u00e0 REPLACEB trong Excel c\u1ef1c chi ti\u1ebft<\/div>\n
      \n

      2. H\u00e0m MIN<\/h2>\n<\/div>\n
      \n

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

      H\u00e0m MIN l\u00e0 c\u00f4ng c\u1ee5 \u0111\u1ed1i l\u1eadp v\u1edbi h\u00e0m MAX, d\u00f9ng \u0111\u1ec3 t\u00ecm gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t trong m\u1ed9t v\u00f9ng d\u1eef li\u1ec7u. Nh\u1edd kh\u1ea3 n\u0103ng n\u00e0y, h\u00e0m \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng r\u1ed9ng r\u00e3i trong c\u00e1c t\u00e1c v\u1ee5 nh\u01b0 \u0111\u00e1nh gi\u00e1 r\u1ee7i ro, ph\u00e2n t\u00edch m\u1ee9c th\u1ea5p nh\u1ea5t ho\u1eb7c tr\u00edch xu\u1ea5t gi\u00e1 tr\u1ecb t\u1ed1i thi\u1ec3u t\u1eeb m\u1ed9t t\u1eadp th\u00f4ng tin.<\/p>\n

      C\u00fa ph\u00e1p c\u1ee7a h\u00e0m MIN:<\/strong> =MIN(number1, number2, …)<\/p>\n

      Gi\u1ea3i th\u00edch:<\/p>\n

        \n
      • number1, number2, \u2026<\/strong> l\u00e0 c\u00e1c gi\u00e1 tr\u1ecb ho\u1eb7c tham chi\u1ebfu m\u00e0 h\u00e0m s\u1ebd xem x\u00e9t \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh s\u1ed1 nh\u1ecf nh\u1ea5t trong nh\u00f3m d\u1eef li\u1ec7u \u0111\u00f3.<\/li>\n<\/ul>\n

        \"C\u00faC\u00f4ng th\u1ee9c s\u1eed d\u1ee5ng h\u00e0m MIN trong Excel<\/em><\/p>\n

        \n

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

        V\u00ed d\u1ee5 1: <\/strong>S\u1eed d\u1ee5ng h\u00e0m MIN \u0111\u1ec3 t\u00ecm ra \u0111i\u1ec3m th\u1ea5p nh\u1ea5t trong l\u1edbp<\/p>\n

        B\u01b0\u1edbc 1: <\/strong>T\u1ea1i \u00f4 d\u00f9ng \u0111\u1ec3 hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3, h\u00e3y nh\u1eadp c\u00f4ng th\u1ee9c: =MIN(E2:E6)<\/p>\n

        B\u01b0\u1edbc 2: <\/strong>Nh\u1ea5n ENTER v\u00e0 k\u1ebft qu\u1ea3 l\u00e0 \u0111i\u1ec3m th\u1ea5p nh\u1ea5t trong v\u00f9ng d\u1eef li\u1ec7u s\u1ebd \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb.<\/p>\n

        \"S\u1eed\u0110i\u1ec3m th\u1ea5p nh\u1ea5t \u0111\u01b0\u1ee3c Excel tr\u1ea3 v\u1ec1 sau khi t\u00ednh MIN<\/em><\/p>\n

        V\u00ed d\u1ee5 2: <\/strong>B\u1ea1n mu\u1ed1n bi\u1ebft trong l\u1edbp, ai c\u00f3 \u0111i\u1ec3m V\u0103n th\u1ea5p nh\u1ea5t trong b\u1ea3ng d\u1eef li\u1ec7u t\u1eeb \u00f4 E2 \u0111\u1ebfn E6. Th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/p>\n

        B\u01b0\u1edbc 1:<\/strong> Ch\u1ecdn \u00f4 n\u01a1i b\u1ea1n mu\u1ed1n k\u1ebft qu\u1ea3 hi\u1ec3n th\u1ecb. Sau \u0111\u00f3 nh\u1eadp c\u00f4ng th\u1ee9c: =MIN(E2:E6)<\/p>\n

        B\u01b0\u1edbc 2: <\/strong>Nh\u1ea5n ENTER. Ngay l\u1eadp t\u1ee9c, Excel s\u1ebd tr\u1ea3 v\u1ec1 \u0111i\u1ec3m V\u0103n nh\u1ecf nh\u1ea5t n\u1eb1m trong ph\u1ea1m vi \u0111\u00e3 ch\u1ecdn.<\/p>\n

        \"K\u1ebftGi\u00e1 tr\u1ecb \u0111i\u1ec3m V\u0103n th\u1ea5p nh\u1ea5t \u0111\u01b0\u1ee3c h\u00e0m MIN tr\u1ea3 v\u1ec1<\/em><\/p>\n

        \n

        2.3 L\u01b0u \u00fd khi d\u00f9ng h\u00e0m MIN<\/h3>\n<\/div>\n

        \u0110\u1ec3 s\u1eed d\u1ee5ng h\u00e0m MIN m\u1ed9t c\u00e1ch ch\u00ednh x\u00e1c v\u00e0 tr\u00e1nh g\u1eb7p l\u1ed7i trong qu\u00e1 tr\u00ecnh t\u00ednh to\u00e1n, b\u1ea1n c\u1ea7n l\u01b0u \u00fd m\u1ed9t s\u1ed1 \u0111\u1eb7c \u0111i\u1ec3m quan tr\u1ecdng sau:<\/p>\n

          \n
        • Khi c\u00e1c tham s\u1ed1 \u0111\u01b0a v\u00e0o kh\u00f4ng ph\u1ea3i d\u1ea1ng s\u1ed1, h\u00e0m MIN s\u1ebd tr\u1ea3 v\u1ec1 l\u1ed7i #VALUE!.<\/li>\n
        • N\u1ebfu trong c\u00e1c \u0111\u1ed1i s\u1ed1 kh\u00f4ng c\u00f3 gi\u00e1 tr\u1ecb s\u1ed1 n\u00e0o, k\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m s\u1ebd l\u00e0 0.<\/li>\n
        • H\u00e0m MIN t\u1ef1 \u0111\u1ed9ng b\u1ecf qua nh\u1eefng \u00f4 \u0111\u1ec3 tr\u1ed1ng ho\u1eb7c kh\u00f4ng ch\u1ee9a d\u1eef li\u1ec7u.<\/li>\n
        • C\u00e1c gi\u00e1 tr\u1ecb logic \u0111\u01b0\u1ee3c nh\u1eadp d\u01b0\u1edbi d\u1ea1ng v\u0103n b\u1ea3n (v\u00ed d\u1ee5: \u201cTRUE\u201d, \u201cFALSE\u201d) s\u1ebd \u0111\u01b0\u1ee3c t\u00ednh l\u00e0 m\u1ed9t \u0111\u1ed1i s\u1ed1 h\u1ee3p l\u1ec7.<\/li>\n
        • N\u1ebfu \u0111\u1ed1i s\u1ed1 l\u00e0 v\u0103n b\u1ea3n kh\u00f4ng th\u1ec3 chuy\u1ec3n \u0111\u1ed5i th\u00e0nh s\u1ed1 ho\u1eb7c l\u00e0 gi\u00e1 tr\u1ecb l\u1ed7i, Excel s\u1ebd kh\u00f4ng x\u1eed l\u00fd \u0111\u01b0\u1ee3c v\u00e0 g\u00e2y ra l\u1ed7i khi t\u00ednh to\u00e1n.<\/li>\n
        • Trong tr\u01b0\u1eddng h\u1ee3p ph\u1ea1m vi d\u1eef li\u1ec7u kh\u00f4ng bao g\u1ed3m gi\u00e1 tr\u1ecb logic, b\u1ea1n n\u00ean d\u00f9ng h\u00e0m MINA thay cho MIN. H\u00e0m MINA s\u1ebd quy \u0111\u1ed5i TRUE th\u00e0nh 1 v\u00e0 FALSE th\u00e0nh 0 tr\u01b0\u1edbc khi th\u1ef1c hi\u1ec7n t\u00ednh to\u00e1n.<\/li>\n<\/ul>\n
          \n

          3. K\u1ebft h\u1ee3p h\u00e0m MAX, MIN v\u1edbi c\u00e1c h\u00e0m kh\u00e1c<\/h2>\n<\/div>\n

          MIN v\u00e0 MAX l\u00e0 n\u1ec1n t\u1ea3ng cho nhi\u1ec1u c\u00f4ng th\u1ee9c n\u00e2ng cao khi b\u1ea1n mu\u1ed1n ph\u00e2n t\u00edch d\u1eef li\u1ec7u s\u00e2u h\u01a1n ho\u1eb7c \u00e1p d\u1ee5ng \u0111i\u1ec1u ki\u1ec7n l\u1ecdc. Vi\u1ec7c k\u1ebft h\u1ee3p ch\u00fang v\u1edbi h\u00e0m IF, AVERAGE ho\u1eb7c COUNT gi\u00fap b\u1ea1n x\u00e2y d\u1ef1ng nh\u1eefng c\u00f4ng th\u1ee9c th\u00f4ng minh h\u01a1n.<\/p>\n

          \n

          3.1 K\u1ebft h\u1ee3p v\u1edbi H\u00e0m IF<\/h3>\n<\/div>\n

          V\u00ed d\u1ee5:<\/strong> T\u00ecm thu nh\u1eadp nh\u1ecf nh\u1ea5t v\u00e0 l\u1edbn nh\u1ea5t c\u1ee7a th\u00e0nh ph\u1ed1 Ngh\u1ec7 An<\/p>\n

          B\u01b0\u1edbc 1: <\/strong>Nh\u1eadp c\u00f4ng th\u1ee9c =MIN(IF($B$2:$B$15=D4, $C$2:$C$15)) v\u00e0o \u00f4 \u1edf c\u1ed9t Min.<\/p>\n

          Gi\u1ea3i th\u00edch:<\/p>\n

            \n
          • $B$2:$B$15 = D4: <\/strong>D\u00f9ng \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh h\u00e0ng n\u00e0o thu\u1ed9c \u0111\u00fang th\u00e0nh ph\u1ed1 m\u00e0 b\u1ea1n mu\u1ed1n l\u1ecdc<\/li>\n
          • $C$2:$C$15: <\/strong>L\u00e0 v\u00f9ng ch\u1ee9a c\u00e1c gi\u00e1 tr\u1ecb c\u1ea7n l\u1ea5y<\/li>\n<\/ul>\n

            \"\u00a0K\u1ebftNh\u1eadp c\u00f4ng th\u1ee9c k\u1ebft h\u1ee3p h\u00e0m MIN v\u00e0 h\u00e0m IF<\/em><\/p>\n

            B\u01b0\u1edbc 2: <\/strong>Nh\u1ea5n t\u1ed5 h\u1ee3p ph\u00edm Ctrl + Shift + Enter \u0111\u1ec3 nh\u1eadn k\u1ebft qu\u1ea3.<\/p>\n

            \"Nh\u1ea5nK\u1ebft qu\u1ea3 thu \u0111\u01b0\u1ee3c l\u00e0 gi\u00e1 tr\u1ecb thu nh\u1eadp nh\u1ecf nh\u1ea5t c\u1ee7a TP. Ngh\u1ec7 An<\/em><\/p>\n

            B\u01b0\u1edbc 3:<\/strong> Th\u1ef1c hi\u1ec7n t\u01b0\u01a1ng t\u1ef1 nh\u01b0 v\u1eady cho gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t, nh\u01b0ng thay MIN b\u1eb1ng MAX.<\/p>\n

            \n

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

            B\u1ea1n c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p MIN\/ MAX v\u1edbi h\u00e0m AVERAGE b\u1eb1ng c\u00e1ch d\u00f9ng c\u00f4ng th\u1ee9c =MAX \/ MIN(range) \u2013 AVERAGE(range) \u0111\u1ec3 t\u00ednh m\u1ee9c ch\u00eanh l\u1ec7ch gi\u1eefa gi\u00e1 tr\u1ecb th\u1ea5p nh\u1ea5t v\u00e0 trung b\u00ecnh trong m\u1ed9t t\u1eadp d\u1eef li\u1ec7u. C\u00e1ch l\u00e0m n\u00e0y gi\u00fap b\u1ea1n x\u00e1c \u0111\u1ecbnh xem gi\u00e1 tr\u1ecb t\u1ed1i thi\u1ec3u \u0111ang th\u1ea5p h\u01a1n trung b\u00ecnh bao nhi\u00eau, t\u1eeb \u0111\u00f3 \u0111\u00e1nh gi\u00e1 m\u1ee9c \u0111\u1ed9 bi\u1ebfn \u0111\u1ed9ng c\u1ee7a d\u1eef li\u1ec7u.<\/p>\n

            \n

            3.3 S\u1eed d\u1ee5ng trong t\u00ednh to\u00e1n kho\u1ea3ng c\u00e1ch<\/h3>\n<\/div>\n

            B\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng h\u00e0m MAX \u0111\u1ec3 t\u00ecm ra kho\u1ea3ng c\u00e1ch l\u1edbn nh\u1ea5t, ho\u1eb7c d\u00f9ng h\u00e0m MIN \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh kho\u1ea3ng c\u00e1ch nh\u1ecf nh\u1ea5t trong m\u1ed9t t\u1eadp d\u1eef li\u1ec7u. C\u00e1ch l\u00e0m n\u00e0y r\u1ea5t h\u1eefu \u00edch khi c\u1ea7n \u0111\u00e1nh gi\u00e1 m\u1ee9c \u0111\u1ed9 thay \u0111\u1ed5i ho\u1eb7c ph\u00e2n t\u00edch s\u1ef1 ch\u00eanh l\u1ec7ch theo t\u1eebng gi\u00e1 tr\u1ecb.<\/p>\n

            Excel cung c\u1ea5p nhi\u1ec1u h\u00e0m h\u1ed7 tr\u1ee3 ph\u00e2n t\u00edch d\u1eef li\u1ec7u hi\u1ec7u qu\u1ea3, trong \u0111\u00f3 MIN v\u00e0 MAX l\u00e0 nh\u1eefng c\u00f4ng c\u1ee5 \u0111\u01a1n gi\u1ea3n nh\u01b0ng c\u1ef1c k\u1ef3 h\u1eefu \u00edch. Khi \u00e1p d\u1ee5ng \u0111\u00fang, b\u1ea1n c\u00f3 th\u1ec3 r\u00fat ng\u1eafn th\u1eddi gian t\u00ednh to\u00e1n v\u00e0 ki\u1ec3m so\u00e1t d\u1eef li\u1ec7u ch\u1eb7t ch\u1ebd h\u01a1n. \u0110\u1eebng qu\u00ean 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 th\u00eam nhi\u1ec1u th\u00f4ng tin h\u1eefu \u00edch.<\/p>\n

            N\u1ebfu b\u1ea1n \u0111ang t\u00ecm ki\u1ebfm m\u1ed9t thi\u1ebft b\u1ecb ph\u00f9 h\u1ee3p \u0111\u1ec3 h\u1ecdc Excel ho\u1eb7c l\u00e0m vi\u1ec7c v\u0103n ph\u00f2ng, h\u00e3y tham kh\u1ea3o c\u00e1c d\u00f2ng \u0111i\u1ec7n tho\u1ea1i, m\u00e1y t\u00ednh b\u1ea3ng v\u00e0 laptop v\u1edbi hi\u1ec7u n\u0103ng \u1ed5n \u0111\u1ecbnh t\u1ea1i Si\u00eau Th\u1ecb \u0110i\u1ec7n M\u00e1y – N\u1ed9i Th\u1ea5t Ch\u1ee3 L\u1edbn. Nh\u1eefng thi\u1ebft b\u1ecb n\u00e0y gi\u00fap b\u1ea1n thao t\u00e1c nhanh h\u01a1n, x\u1eed l\u00fd b\u1ea3ng t\u00ednh m\u01b0\u1ee3t m\u00e0 v\u00e0 t\u1ed1i \u01b0u c\u00f4ng vi\u1ec7c h\u00e0ng ng\u00e0y.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

            \u00a0 Trong Excel, h\u00e0m MIN v\u00e0 MAX l\u00e0 hai c\u00f4ng c\u1ee5 quan tr\u1ecdng gi\u00fap b\u1ea1n nhanh ch\u00f3ng x\u00e1c \u0111\u1ecbnh gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t v\u00e0 l\u1edbn nh\u1ea5t trong d\u1eef li\u1ec7u. Vi\u1ec7c n\u1eafm v\u1eefng c\u00e1ch s\u1eed d\u1ee5ng hai h\u00e0m n\u00e0y kh\u00f4ng ch\u1ec9 h\u1ed7 tr\u1ee3 ph\u00e2n t\u00edch ch\u00ednh x\u00e1c m\u00e0 c\u00f2n ti\u1ebft ki\u1ec7m th\u1eddi gian khi x\u1eed l\u00fd […]<\/p>\n","protected":false},"author":1,"featured_media":5918,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-5917","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\/12\/19586.jpg","_links":{"self":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts\/5917","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=5917"}],"version-history":[{"count":0,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts\/5917\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/media\/5918"}],"wp:attachment":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/media?parent=5917"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/categories?post=5917"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/tags?post=5917"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}