{"id":4916,"date":"2025-11-19T18:23:55","date_gmt":"2025-11-19T11:23:55","guid":{"rendered":"https:\/\/autofillform.com\/blog\/ham-row-trong-excel-tra-lai-so-thu-tu-hang-trong-o-tham-chieu\/"},"modified":"2025-11-19T18:23:55","modified_gmt":"2025-11-19T11:23:55","slug":"ham-row-trong-excel-tra-lai-so-thu-tu-hang-trong-o-tham-chieu","status":"publish","type":"post","link":"https:\/\/autofillform.com\/blog\/ham-row-trong-excel-tra-lai-so-thu-tu-hang-trong-o-tham-chieu\/","title":{"rendered":"H\u00e0m ROW trong Excel tr\u1ea3 l\u1ea1i s\u1ed1 th\u1ee9 t\u1ef1 h\u00e0ng trong \u00f4 tham chi\u1ebfu"},"content":{"rendered":"
\n
\u00a0<\/div>\n

H\u00e0m ROW trong Excel gi\u00fap b\u1ea1n truy xu\u1ea5t nhanh s\u1ed1 th\u1ee9 t\u1ef1 h\u00e0ng v\u00e0 t\u1ea1o n\u1ec1n t\u1ea3ng cho nhi\u1ec1u c\u00f4ng th\u1ee9c t\u1ef1 \u0111\u1ed9ng h\u00f3a d\u1eef li\u1ec7u. Nh\u1edd c\u00e1ch ho\u1ea1t \u0111\u1ed9ng linh ho\u1ea1t, h\u00e0m n\u00e0y h\u1ed7 tr\u1ee3 t\u1ed1i \u01b0u khi x\u1eed l\u00fd danh s\u00e1ch ho\u1eb7c thi\u1ebft l\u1eadp tham chi\u1ebfu \u0111\u1ed9ng trong b\u1ea3ng t\u00ednh. B\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m ROW trong Excel m\u1ed9t c\u00e1ch \u0111\u01a1n gi\u1ea3n, d\u1ec5 \u00e1p d\u1ee5ng.<\/p>\n

\"S\u1eedH\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m ROW trong Excel<\/em><\/p>\n

\n

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

H\u00e0m ROW trong Excel d\u00f9ng \u0111\u1ec3 l\u1ea5y s\u1ed1 th\u1ee9 t\u1ef1 c\u1ee7a m\u1ed9t h\u00e0ng d\u1ef1a tr\u00ean \u00f4 ho\u1eb7c v\u00f9ng d\u1eef li\u1ec7u m\u00e0 b\u1ea1n tham chi\u1ebfu. Nh\u1edd \u0111\u00f3, b\u1ea1n c\u00f3 th\u1ec3 nhanh ch\u00f3ng x\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed h\u00e0ng c\u1ee7a m\u1ed9t \u00f4 b\u1ea5t k\u1ef3 ho\u1eb7c t\u00ecm s\u1ed1 h\u00e0ng \u0111\u1ea7u ti\u00ean trong m\u1ed9t m\u1ea3ng d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch thu\u1eadn ti\u1ec7n v\u00e0 ch\u00ednh x\u00e1c.<\/p>\n

\n

2. C\u00f4ng th\u1ee9c c\u1ee7a h\u00e0m ROW trong Excel<\/h2>\n<\/div>\n

C\u00fa ph\u00e1p h\u00e0m ROW: =ROW(reference)<\/strong><\/p>\n

Trong \u0111\u00f3 reference l\u00e0 \u00f4 ho\u1eb7c ph\u1ea1m vi \u00f4 m\u00e0 b\u1ea1n mu\u1ed1n l\u1ea5y s\u1ed1 h\u00e0ng.<\/p>\n

L\u01b0u \u00fd khi d\u00f9ng h\u00e0m ROW<\/strong><\/p>\n

    \n
  • N\u1ebfu b\u1ecf tr\u1ed1ng reference, h\u00e0m s\u1ebd tr\u1ea3 v\u1ec1 s\u1ed1 h\u00e0ng c\u1ee7a ch\u00ednh \u00f4 \u0111ang ch\u1ee9a c\u00f4ng th\u1ee9c.<\/li>\n
  • reference ch\u1ec9 \u0111\u01b0\u1ee3c ph\u00e9p tham chi\u1ebfu \u0111\u1ebfn m\u1ed9t v\u00f9ng li\u00ean t\u1ee5c. B\u1ea1n kh\u00f4ng th\u1ec3 nh\u1eadp nhi\u1ec1u v\u00f9ng c\u00f9ng l\u00fac, v\u00ed d\u1ee5: =ROW(F6,H6) (kh\u00f4ng h\u1ee3p l\u1ec7)<\/li>\n
  • N\u1ebfu reference l\u00e0 m\u1ed9t v\u00f9ng nhi\u1ec1u \u00f4 v\u00e0 c\u00f4ng th\u1ee9c \u0111\u01b0\u1ee3c nh\u1eadp theo d\u1ea1ng m\u1ea3ng d\u1ecdc, th\u00ec h\u00e0m ROW s\u1ebd tr\u1ea3 v\u1ec1 t\u1eadp c\u00e1c s\u1ed1 h\u00e0ng t\u01b0\u01a1ng \u1ee9ng v\u1edbi t\u1eebng \u00f4 trong v\u00f9ng tham chi\u1ebfu.<\/li>\n<\/ul>\n

    Ph\u00e2n bi\u1ec7t h\u00e0m ROW v\u00e0 ROWS<\/strong><\/p>\n

      \n
    • ROW: Tr\u1ea3 v\u1ec1 v\u1ecb tr\u00ed s\u1ed1 h\u00e0ng c\u1ee7a m\u1ed9t \u00f4 tham chi\u1ebfu.<\/li>\n
    • ROWS: Tr\u1ea3 v\u1ec1 t\u1ed5ng s\u1ed1 h\u00e0ng c\u1ee7a m\u1ed9t v\u00f9ng d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c tham chi\u1ebfu.<\/li>\n<\/ul>\n

      \"C\u00faC\u00f4ng th\u1ee9c h\u00e0m ROW trong Excel<\/em><\/p>\n

      Xem th\u00eam: <\/strong>H\u00e0m AGGREGATE trong Excel l\u00e0 g\u00ec? H\u01b0\u1edbng d\u1eabn c\u00e1ch d\u00f9ng<\/div>\n
      \n

      3. C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m ROW<\/h2>\n<\/div>\n

      B\u01b0\u1edbc 1: Ch\u1ecdn \u00f4 s\u1ebd hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3<\/strong><\/p>\n

      Khi \u0111\u00e3 m\u1edf file Excel, h\u00e3y x\u00e1c \u0111\u1ecbnh \u00f4 m\u00e0 b\u1ea1n mu\u1ed1n hi\u1ec3n th\u1ecb s\u1ed1 th\u1ee9 t\u1ef1 h\u00e0ng, sau \u0111\u00f3 nh\u1ea5p chu\u1ed9t v\u00e0o \u00f4 \u0111\u00f3 \u0111\u1ec3 b\u1eaft \u0111\u1ea7u nh\u1eadp c\u00f4ng th\u1ee9c.<\/p>\n

      B\u01b0\u1edbc 2: Nh\u1eadp c\u00f4ng th\u1ee9c h\u00e0m ROW<\/strong><\/p>\n

      T\u1ea1i \u00f4 v\u1eeba ch\u1ecdn, nh\u1eadp c\u00fa ph\u00e1p: =ROW(reference)<\/strong><\/p>\n

      V\u00ed d\u1ee5:<\/strong> N\u1ebfu b\u1ea1n mu\u1ed1n bi\u1ebft s\u1ed1 h\u00e0ng c\u1ee7a \u00f4 D7, th\u00ec nh\u1eadp: =ROW(D7)<\/strong> \u2192 K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 l\u00e0 7 v\u00ec D7 n\u1eb1m \u1edf h\u00e0ng s\u1ed1 7.<\/p>\n

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

        \n
      • ROW:<\/strong> T\u00ean h\u00e0m d\u00f9ng \u0111\u1ec3 l\u1ea5y s\u1ed1 th\u1ee9 t\u1ef1 h\u00e0ng.<\/li>\n
      • D7:<\/strong> L\u00e0 \u00f4 m\u00e0 h\u00e0m d\u00f9ng l\u00e0m tham chi\u1ebfu \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh s\u1ed1 h\u00e0ng.<\/li>\n<\/ul>\n

        \"S\u1eedC\u00f4ng th\u1ee9c ROW tham chi\u1ebfu \u00f4 D7<\/em><\/p>\n

        B\u01b0\u1edbc 3: Nh\u1ea5n Enter \u0111\u1ec3 xem k\u1ebft qu\u1ea3<\/strong><\/p>\n

        Sau khi nh\u1eadp xong c\u00f4ng th\u1ee9c, nh\u1ea5n Enter. Excel s\u1ebd t\u00ednh to\u00e1n v\u00e0 hi\u1ec3n th\u1ecb s\u1ed1 h\u00e0ng c\u1ee7a \u00f4 (ho\u1eb7c v\u00f9ng \u00f4) m\u00e0 b\u1ea1n \u0111\u00e3 tham chi\u1ebfu.<\/p>\n

        \"H\u00e0mK\u1ebft qu\u1ea3 h\u00e0m ROW tr\u1ea3 v\u1ec1 s\u1ed1 h\u00e0ng<\/em><\/p>\n

        \n

        4. G\u1ee3i \u00fd m\u1ed9t s\u1ed1 c\u00e1ch d\u00f9ng h\u00e0m ROW<\/h2>\n<\/div>\n
        \n

        4.1 H\u00e0m ROW v\u1edbi ph\u1ea1m vi \u00f4<\/h3>\n<\/div>\n

        Khi s\u1eed d\u1ee5ng h\u00e0m ROW v\u1edbi ph\u1ea1m vi \u00f4, c\u00fa ph\u00e1p s\u1ebd nh\u01b0 sau: =ROW(start_cell:end_cell)<\/strong><\/p>\n

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

          \n
        • start_cell v\u00e0 end_cell l\u00e0 hai \u00f4 x\u00e1c \u0111\u1ecbnh ph\u1ea1m vi.<\/li>\n
        • H\u00e0m s\u1ebd l\u1ea5y s\u1ed1 h\u00e0ng c\u1ee7a \u00f4 \u0111\u1ea7u ti\u00ean trong ph\u1ea1m vi \u0111\u00f3 l\u00e0m k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1.<\/li>\n<\/ul>\n

          V\u00ed d\u1ee5:<\/strong> Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 danh s\u00e1ch sinh vi\u00ean n\u1eb1m trong c\u1ed9t B, t\u1eeb B3 \u0111\u1ebfn B5. Y\u00eau c\u1ea7u l\u00e0 \u0111i\u1ec1n s\u1ed1 th\u1ee9 t\u1ef1 t\u01b0\u01a1ng \u1ee9ng cho t\u1eebng sinh vi\u00ean v\u00e0o c\u1ed9t A (t\u1eeb A3 \u0111\u1ebfn A5).<\/p>\n

          B\u01b0\u1edbc 1:<\/strong> T\u1ea1i \u00f4 A3, b\u1ea1n nh\u1eadp c\u00f4ng th\u1ee9c: =ROW(B3:B5)<\/strong><\/p>\n

          \"S\u1eedNh\u1eadp h\u00e0m ROW cho ph\u1ea1m vi B3:B5<\/em><\/p>\n

          B\u01b0\u1edbc 2:<\/strong> Sau \u0111\u00f3 nh\u1ea5n Enter<\/strong>, Excel s\u1ebd tr\u1ea3 v\u1ec1 s\u1ed1 h\u00e0ng c\u1ee7a B3 (t\u1ee9c l\u00e0 3) t\u1ea1i \u00f4 A3.<\/p>\n

          \u0110\u1ec3 \u0111i\u1ec1n s\u1ed1 th\u1ee9 t\u1ef1 cho to\u00e0n b\u1ed9 danh s\u00e1ch, b\u1ea1n ch\u1ec9 c\u1ea7n k\u00e9o \u00f4 A3 xu\u1ed1ng A5, Excel s\u1ebd t\u1ef1 \u0111\u1ed9ng tr\u1ea3 v\u1ec1:<\/p>\n

            \n
          • A3 \u2192 3<\/li>\n
          • A4 \u2192 4<\/li>\n
          • A5 \u2192 5<\/li>\n<\/ul>\n

            \"K\u1ebftS\u1ed1 th\u1ee9 t\u1ef1 hi\u1ec3n th\u1ecb theo h\u00e0ng<\/em><\/p>\n

            \n

            4.2 K\u1ebft h\u1ee3p v\u1edbi h\u00e0m CONCATENATE<\/h3>\n<\/div>\n

            B\u1ea1n c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p h\u00e0m ROW v\u1edbi h\u00e0m CONCATENATE (ho\u1eb7c to\u00e1n t\u1eed &) \u0111\u1ec3 t\u1ea1o chu\u1ed7i v\u0103n b\u1ea3n k\u00e8m theo s\u1ed1 th\u1ee9 t\u1ef1 h\u00e0ng. C\u00fa ph\u00e1p s\u1eed d\u1ee5ng nh\u01b0 sau:<\/p>\n

            =CONCATENATE(“Chu\u1ed7i v\u0103n b\u1ea3n”, ROW(reference))<\/strong><\/p>\n

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

              \n
            • “Chu\u1ed7i v\u0103n b\u1ea3n”<\/strong> l\u00e0 ph\u1ea7n n\u1ed9i dung b\u1ea1n mu\u1ed1n gh\u00e9p th\u00eam.<\/li>\n
            • ROW(reference)<\/strong> s\u1ebd l\u1ea5y s\u1ed1 h\u00e0ng c\u1ee7a \u00f4 \u0111\u01b0\u1ee3c tham chi\u1ebfu v\u00e0 n\u1ed1i v\u00e0o cu\u1ed1i chu\u1ed7i.<\/li>\n<\/ul>\n

              V\u00ed d\u1ee5:<\/strong> Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 danh s\u00e1ch s\u1ea3n ph\u1ea9m \u1edf c\u1ed9t A, b\u1eaft \u0111\u1ea7u t\u1eeb \u00f4 A2 v\u1edbi c\u00e1c t\u00ean nh\u01b0: T\u00e1o, Cam, Xo\u00e0i,\u2026Y\u00eau c\u1ea7u: T\u1ea1o t\u00ean g\u1ecdi m\u1edbi theo d\u1ea1ng \u201cT\u00ean s\u1ea3n ph\u1ea9m + s\u1ed1 th\u1ee9 t\u1ef1 h\u00e0ng\u201d, v\u00ed d\u1ee5: T\u00e1o 1, Cam 2, \u2026<\/p>\n

              B\u01b0\u1edbc 1:<\/strong> T\u1ea1i \u00f4 c\u1ea1nh t\u00ean s\u1ea3n ph\u1ea9m \u0111\u1ea7u ti\u00ean (v\u00ed d\u1ee5 \u00f4 B2), nh\u1eadp c\u00f4ng th\u1ee9c: =CONCATENATE(A2, ” “, ROW(A2)-1)<\/strong><\/p>\n

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

                \n
              • A2:<\/strong> Ch\u1ee9a t\u00ean s\u1ea3n ph\u1ea9m.<\/li>\n
              • ” “:<\/strong> Th\u00eam kho\u1ea3ng tr\u1eafng gi\u1eefa t\u00ean v\u00e0 s\u1ed1 th\u1ee9 t\u1ef1.<\/li>\n
              • ROW(A2)-1:<\/strong> Tr\u1ea3 v\u1ec1 s\u1ed1 h\u00e0ng c\u1ee7a A2 (l\u00e0 2), tr\u1eeb \u0111i 1 \u0111\u1ec3 s\u1ed1 th\u1ee9 t\u1ef1 b\u1eaft \u0111\u1ea7u t\u1eeb 1.<\/li>\n<\/ul>\n

                \"T\u1ea1oC\u00f4ng th\u1ee9c CONCATENATE t\u1ea1o t\u00ean g\u1ecdi<\/em><\/p>\n

                B\u01b0\u1edbc 2:<\/strong> Nh\u1ea5n Enter<\/strong> \u0111\u1ec3 xem k\u1ebft qu\u1ea3<\/p>\n

                \"K\u1ebftT\u00ean s\u1ea3n ph\u1ea9m k\u00e8m s\u1ed1 th\u1ee9 t\u1ef1<\/em><\/p>\n

                B\u01b0\u1edbc 3:<\/strong> Nh\u1ea5p v\u00e0o \u00f4 v\u1eeba c\u00f3 k\u1ebft qu\u1ea3 (B2), sau \u0111\u00f3 k\u00e9o ch\u1ed1t nh\u1ecf \u1edf g\u00f3c d\u01b0\u1edbi b\u00ean ph\u1ea3i \u00f4 xu\u1ed1ng c\u00e1c d\u00f2ng b\u00ean d\u01b0\u1edbi \u0111\u1ec3 \u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c cho to\u00e0n b\u1ed9 danh s\u00e1ch.<\/p>\n

                \n

                4.3 S\u1eed d\u1ee5ng h\u00e0m ROW trong c\u00f4ng th\u1ee9c m\u1ea3ng<\/h3>\n<\/div>\n

                B\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m ROW trong c\u00e1c c\u00f4ng th\u1ee9c m\u1ea3ng \u0111\u1ec3 x\u1eed l\u00fd d\u1eef li\u1ec7u tr\u00ean nhi\u1ec1u \u00f4 c\u00f9ng l\u00fac, \u0111\u1eb7c bi\u1ec7t khi c\u1ea7n th\u1ef1c hi\u1ec7n c\u00e1c ph\u00e9p t\u00ednh ph\u1ee9c t\u1ea1p.<\/p>\n

                V\u00ed d\u1ee5: =SUM(A1:A10 * ROW(A1:A10))<\/strong><\/p>\n

                C\u00f4ng th\u1ee9c n\u00e0y k\u1ebft h\u1ee3p h\u00e0m SUM v\u00e0 ROW \u0111\u1ec3 th\u1ef1c hi\u1ec7n ph\u00e9p nh\u00e2n t\u1eebng ph\u1ea7n t\u1eed trong v\u00f9ng A1:A10 v\u1edbi s\u1ed1 th\u1ee9 t\u1ef1 h\u00e0ng t\u01b0\u01a1ng \u1ee9ng, r\u1ed3i c\u1ed9ng t\u1ea5t c\u1ea3 c\u00e1c k\u1ebft qu\u1ea3 l\u1ea1i.<\/p>\n

                M\u1ed7i gi\u00e1 tr\u1ecb trong A1:A10 s\u1ebd \u0111\u01b0\u1ee3c nh\u00e2n v\u1edbi s\u1ed1 h\u00e0ng c\u1ee7a ch\u00ednh \u00f4 \u0111\u00f3. To\u00e0n b\u1ed9 c\u00e1c t\u00edch s\u1ebd \u0111\u01b0\u1ee3c c\u1ed9ng l\u1ea1i \u0111\u1ec3 t\u1ea1o ra t\u1ed5ng cu\u1ed1i c\u00f9ng.<\/p>\n

                \n

                4.4 K\u1ebft h\u1ee3p v\u1edbi h\u00e0m INDIRECT<\/h3>\n<\/div>\n

                V\u00ed d\u1ee5:<\/strong> T\u1ea1o tham chi\u1ebfu \u0111\u1ed9ng gi\u1eefa hai b\u1ea3ng b\u1eb1ng h\u00e0m ROW<\/p>\n

                B\u01b0\u1edbc 1:<\/strong> T\u1ea1i \u00f4 n\u01a1i b\u1ea1n mu\u1ed1n l\u1ea5y d\u1eef li\u1ec7u t\u1eeb B\u1ea3ng 1, h\u00e3y nh\u1eadp c\u00f4ng th\u1ee9c: =INDIRECT(“A” & ROW(A1))<\/strong><\/p>\n

                Gi\u1ea3i th\u00edch c\u00f4ng th\u1ee9c:<\/p>\n

                  \n
                • ROW(A1): Tr\u1ea3 v\u1ec1 s\u1ed1 th\u1ee9 t\u1ef1 h\u00e0ng c\u1ee7a \u00f4 A1, ngh\u0129a l\u00e0 1.<\/li>\n
                • “A” & ROW(A1): Gh\u00e9p k\u00fd t\u1ef1 \u201cA\u201d v\u1edbi s\u1ed1 h\u00e0ng v\u1eeba l\u1ea5y \u0111\u01b0\u1ee3c \u2192 T\u1ea1o th\u00e0nh chu\u1ed7i “A1”.<\/li>\n
                • INDIRECT(“A1”): Chuy\u1ec3n chu\u1ed7i v\u0103n b\u1ea3n \u201cA1\u201d th\u00e0nh m\u1ed9t tham chi\u1ebfu th\u1eadt trong Excel v\u00e0 tr\u1ea3 v\u1ec1 \u0111\u00fang gi\u00e1 tr\u1ecb n\u1eb1m trong \u00f4 A1.<\/li>\n<\/ul>\n

                  \"D\u00f9ngC\u00f4ng th\u1ee9c INDIRECT tham chi\u1ebfu \u0111\u1ed9ng<\/em><\/p>\n

                  B\u01b0\u1edbc 2:<\/strong> Sau \u0111\u00f3, nh\u1ea5n Enter<\/strong> \u0111\u1ec3 hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3<\/p>\n

                  \"K\u1ebftGi\u00e1 tr\u1ecb t\u1eeb \u00f4 tham chi\u1ebfu \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb<\/em><\/p>\n

                  H\u00e0m ROW mang \u0111\u1ebfn s\u1ef1 linh ho\u1ea1t trong x\u1eed l\u00fd d\u1eef li\u1ec7u v\u00e0 gi\u00fap t\u1ed1i \u01b0u nhi\u1ec1u thao t\u00e1c tr\u00ean b\u1ea3ng t\u00ednh. Khi n\u1eafm r\u00f5 c\u00e1ch v\u1eadn d\u1ee5ng, b\u1ea1n c\u00f3 th\u1ec3 m\u1edf r\u1ed9ng \u1ee9ng d\u1ee5ng c\u1ee7a h\u00e0m n\u00e0y trong nhi\u1ec1u t\u00ecnh hu\u1ed1ng kh\u00e1c nhau \u0111\u1ec3 l\u00e0m vi\u1ec7c hi\u1ec7u qu\u1ea3 h\u01a1n trong Excel.<\/p>\n

                  \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 c\u00e1c m\u1eb9o Excel v\u00e0 th\u1ee7 thu\u1eadt v\u0103n ph\u00f2ng h\u1eefu \u00edch.<\/p>\n

                  N\u1ebfu b\u1ea1n th\u01b0\u1eddng xuy\u00ean l\u00e0m vi\u1ec7c v\u1edbi Excel, m\u1ed9t chi\u1ebfc m\u00e1y t\u00ednh b\u1ea3ng ho\u1eb7c \u0111i\u1ec7n tho\u1ea1i c\u1ea5u h\u00ecnh m\u1ea1nh s\u1ebd gi\u00fap thao t\u00e1c nhanh v\u00e0 linh ho\u1ea1t h\u01a1n. Kh\u00e1m ph\u00e1 ngay c\u00e1c s\u1ea3n ph\u1ea9m ch\u00ednh h\u00e3ng, \u01b0u \u0111\u00e3i h\u1ea5p d\u1eabn t\u1ea1i Si\u00eau Th\u1ecb \u0110i\u1ec7n M\u00e1y – N\u1ed9i Th\u1ea5t Ch\u1ee3 L\u1edbn \u0111\u1ec3 t\u1ed1i \u01b0u c\u00f4ng vi\u1ec7c m\u1ed7i ng\u00e0y.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

                  \u00a0 H\u00e0m ROW trong Excel gi\u00fap b\u1ea1n truy xu\u1ea5t nhanh s\u1ed1 th\u1ee9 t\u1ef1 h\u00e0ng v\u00e0 t\u1ea1o n\u1ec1n t\u1ea3ng cho nhi\u1ec1u c\u00f4ng th\u1ee9c t\u1ef1 \u0111\u1ed9ng h\u00f3a d\u1eef li\u1ec7u. Nh\u1edd c\u00e1ch ho\u1ea1t \u0111\u1ed9ng linh ho\u1ea1t, h\u00e0m n\u00e0y h\u1ed7 tr\u1ee3 t\u1ed1i \u01b0u khi x\u1eed l\u00fd danh s\u00e1ch ho\u1eb7c thi\u1ebft l\u1eadp tham chi\u1ebfu \u0111\u1ed9ng trong b\u1ea3ng t\u00ednh. B\u00e0i vi\u1ebft […]<\/p>\n","protected":false},"author":1,"featured_media":4917,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-4916","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\/19371.jpg","_links":{"self":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts\/4916","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=4916"}],"version-history":[{"count":0,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts\/4916\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/media\/4917"}],"wp:attachment":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/media?parent=4916"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/categories?post=4916"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/tags?post=4916"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}