{"id":9361,"date":"2021-09-15T09:07:52","date_gmt":"2021-09-15T02:07:52","guid":{"rendered":"https:\/\/tct.vn\/blog\/?p=9361"},"modified":"2021-09-15T09:07:52","modified_gmt":"2021-09-15T02:07:52","slug":"cach-danh-so-thu-tu-trong-excel-nhanh-nhat","status":"publish","type":"post","link":"https:\/\/tct.vn\/blog\/cach-danh-so-thu-tu-trong-excel-nhanh-nhat\/","title":{"rendered":"C\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel nhanh nh\u1ea5t"},"content":{"rendered":"

C\u00e1ch 1 <\/span>K\u00e9o chu\u1ed9t \u0111\u1ec3 \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1<\/h3>\n

C\u00e1ch n\u00e0y th\u1ef1c hi\u1ec7n r\u1ea5t nhanh ch\u00f3ng v\u00e0 \u0111\u01a1n gi\u1ea3n. B\u1ea1n ti\u1ebfn h\u00e0nh c\u00e1c thao t\u00e1c sau:<\/p>\n

B\u01b0\u1edbc 1:\u00a0<\/strong>Nh\u1eadp v\u00e0o 2 s\u1ed1 \u0111\u1ea7u ti\u00ean li\u00ean t\u1ee5c v\u00e0o 2 \u00f4 \u0111\u1ea7u ti\u00ean trong m\u1ea3ng (thao chi\u1ec1u ngang ho\u1eb7c chi\u1ec1u d\u1ecdc) m\u00e0 b\u1ea1n mu\u1ed1n \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 t\u1ef1 \u0111\u1ed9ng.<\/p>\n

V\u00ed d\u1ee5,\u00a0\u0111\u1ec3 \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 cho c\u1ed9t STT \u1edf b\u1ea3ng tr\u00ean, b\u1ea1n nh\u1eadp s\u1ed1 1 v\u00e0o \u00f4 A2, nh\u1eadp s\u1ed1 2 v\u00e0o \u00f4 A3.<\/p>\n

\"Nh\u1eadp<\/p>\n

B\u01b0\u1edbc 2:<\/strong>\u00a0B\u1ea1n ch\u1ecdn 2 \u00f4 ch\u1ee9a 2 s\u1ed1 v\u1eeba nh\u1eadp (t\u1ee9c l\u00e0 A2 v\u00e0 A3), sau \u0111\u00f3 di chu\u1ed9t \u0111\u1ebfn bi\u1ec3u t\u01b0\u1ee3ng h\u00ecnh d\u1ea5u c\u1ed9ng \u1edf g\u00f3c d\u01b0\u1edbi, b\u00ean ph\u1ea3i \u00f4 A3. B\u1ea1n nh\u1ea5n gi\u1eef d\u1ea5u c\u1ed9ng n\u00e0y v\u00e0 k\u00e9o chu\u1ed9t \u0111\u1ebfn h\u1ebft \u00f4 c\u1ea7n \u0111\u00e1nh s\u1ed1 t\u1ef1 \u0111\u1ed9ng m\u00e0 b\u1ea1n mong mu\u1ed1n.<\/p>\n

\"B\u1ea1n<\/p>\n

K\u1ebft qu\u1ea3 s\u1ebd nh\u01b0 sau:\u00a0\"K\u1ebft<\/p>\n

C\u00e1ch 2 <\/span>S\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c \u0111\u01a1n gi\u1ea3n<\/h3>\n

B\u1ea1n th\u1ef1c hi\u1ec7n theo c\u00e1c b\u01b0\u1edbc sau:<\/p>\n

B\u01b0\u1edbc 1:<\/strong>\u00a0Nh\u1eadp s\u1ed1 th\u1ee9 t\u1ef1 cho \u00f4 \u0111\u1ea7u ti\u00ean trong h\u00e0ng, c\u1ed9t m\u00e0 b\u1ea1n mu\u1ed1n \u0111i\u1ec1n s\u1ed1 th\u1ee9 t\u1ef1 t\u1ef1 \u0111\u1ed9ng. \u1ede \u00f4 ti\u1ebfp thep, b\u1ea1n nh\u1eadp c\u00f4ng th\u1ee9c:<\/p>\n

=”v\u1ecb tr\u00ed \u00f4 v\u1eeba \u0111i\u1ec1n” + x<\/strong>\u00a0(v\u1edbi x l\u00e0 b\u01b0\u1edbc nh\u1ea3y – t\u1ee9c l\u00e0 kho\u1ea3ng c\u00e1ch gi\u1eefa 2 s\u1ed1 th\u1ee9 t\u1ef1 li\u00ean ti\u1ebfp) > Nh\u1ea5n\u00a0Enter<\/strong>.<\/p>\n

V\u00ed d\u1ee5, v\u1edbi s\u1ed1 kh\u1edfi \u0111\u1ea7u l\u00e0 1, b\u1ea1n mu\u1ed1n Excel \u0111i\u1ec1n s\u1ed1 th\u1ee9 t\u1ef1 theo ki\u1ec3u 1, 2, 3,…. th\u00ec ch\u1ecdn x l\u00e0 1; theo ki\u1ec3u 1, 3, 5,… th\u00ec ch\u1ecdn x l\u00e0 2.<\/p>\n

\"Nh\u1eadp<\/p>\n

B\u01b0\u1edbc 2:\u00a0<\/strong>Di chu\u1ed9t \u0111\u1ebfn bi\u1ec3u t\u01b0\u1ee3ng h\u00ecnh d\u1ea5u c\u1ed9ng \u1edf g\u00f3c d\u01b0\u1edbi, b\u00ean ph\u1ea3i \u00f4 b\u1ea1n v\u1eeba nh\u1eadp c\u00f4ng th\u1ee9c > Nh\u1ea5n gi\u1eef d\u1ea5u c\u1ed9ng n\u00e0y v\u00e0 k\u00e9o th\u1ea3 chu\u1ed9t \u0111\u1ebfn h\u1ebft \u00f4 c\u1ea7n \u0111\u00e1nh s\u1ed1 t\u1ef1 \u0111\u1ed9ng m\u00e0 b\u1ea1n mong mu\u1ed1n.<\/p>\n

\"Nh\u1ea5n<\/p>\n

K\u1ebft qu\u1ea3 s\u1ebd nh\u01b0 sau:<\/p>\n

\"K\u1ebft<\/p>\n

C\u00e1ch 3 <\/span>S\u1eed d\u1ee5ng Auto fill<\/h3>\n

B\u1ea1n th\u1ef1c hi\u1ec7n thao t\u00e1c sau:<\/p>\n

B\u01b0\u1edbc 1:\u00a0<\/strong>Nh\u1eadp s\u1ed1 th\u1ee9 t\u1ef1 cho \u00f4 \u0111\u1ea7u ti\u00ean > V\u00e0o Th\u1ebb\u00a0Home\u00a0<\/strong>> Ch\u1ecdn\u00a0Fill\u00a0<\/strong>> Ch\u1ecdn\u00a0Series.<\/strong><\/p>\n

(V\u1edbi phi\u00ean b\u1ea3n Excel c\u0169 h\u01a1n Excel 2016, b\u1ea1n c\u00f3 th\u1ec3 v\u00e0o\u00a0Editing > Ch\u1ecdn Fill > Series).<\/p>\n

\"V\u00e0o<\/p>\n

C\u1eeda s\u1ed5\u00a0Series\u00a0<\/strong>hi\u1ec3n th\u1ecb nh\u01b0 h\u00ecnh d\u01b0\u1edbi.<\/p>\n

\"C\u1eeda<\/p>\n

– M\u1ee5c\u00a0“Series in”<\/em>\u00a0cho ph\u00e9p b\u1ea1n l\u1ef1a ch\u1ecdn \u0111\u00e1nh th\u1ee9 t\u1ef1 theo d\u00f2ng hay c\u1ed9t. Ch\u1ecdn\u00a0Rows n\u1ebfu \u0111\u00e1nh s\u1ed1 theo h\u00e0ng v\u00e0 ch\u1ecdn Columns n\u1ebfu \u0111\u00e1nh s\u1ed1 theo c\u1ed9t.<\/p>\n

– M\u1ee5c\u00a0“Type”<\/em>\u00a0cho ph\u00e9p b\u1ea1n l\u1ef1a ch\u1ecdn lo\u1ea1i \u0111\u00e1nh s\u1ed1. Excel h\u1ed7 tr\u1ee3 4 lo\u1ea1i \u0111\u00e1nh s\u1ed1:<\/p>\n

    \n
  • Linear<\/strong>: \u0110\u00e1nh s\u1ed1 theo ki\u1ec3u t\u0103ng d\u1ea7n.<\/li>\n
  • Growth<\/strong>: Ki\u1ec3u l\u0169y ti\u1ebfn (T\u0103ng theo quy lu\u1eadt n\u00e0o \u0111\u00f3).<\/li>\n
  • Date<\/strong>: Ki\u1ec3u ng\u00e0y th\u00e1ng (N\u1ebfu tick Date th\u00ec Date Unit s\u1ebd xu\u1ea5t hi\u1ec7n).<\/li>\n
  • AutoFill<\/strong>: Ki\u1ec3u t\u1ef1 \u0111\u1ed9ng \u0111i\u1ec1n.<\/li>\n<\/ul>\n

    – M\u1ee5c “Step value”<\/em>\u00a0(B\u01b0\u1edbc nh\u1ea3y): Ch\u1ecdn kho\u1ea3ng c\u00e1ch gi\u1eefa hai s\u1ed1 th\u1ee9 t\u1ef1. V\u00ed d\u1ee5, v\u1edbi s\u1ed1 \u0111\u1ea7u ti\u00ean l\u00e0 1, n\u1ebfu \u0111\u1eb7t Step value l\u00e0 1 v\u00e0 th\u00ec s\u1ed1 th\u1ee9 t\u1ef1 s\u1ebd hi\u1ec3n th\u1ecb l\u00e0 1, 2, 3,… c\u00f2n n\u1ebfu \u0111\u1eb7t Step value l\u00e0 2 th\u00ec s\u1ed1 th\u1ee9 t\u1ef1 s\u1ebd hi\u1ec3n th\u1ecb l\u00e0 1, 3, 5,…<\/p>\n

    – M\u1ee5c\u00a0“Stop value”<\/em>\u00a0(Gi\u00e1 tr\u1ecb cu\u1ed1i): Gi\u00e1 tr\u1ecb cu\u1ed1i c\u00f9ng b\u1ea1n c\u1ea7n \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 t\u1ef1 \u0111\u1ed9ng. V\u00ed d\u1ee5, b\u1ea3ng ch\u1ec9 c\u1ea7n \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 t\u1edbi 10 th\u00ec \u0111\u1eb7t Stop value l\u00e0 10.<\/p>\n

    B\u01b0\u1edbc 2:<\/strong>\u00a0Sau khi ch\u1ecdn c\u00e1c th\u00f4ng s\u1ed1 tr\u00ean, b\u1ea1n nh\u1ea5n\u00a0OK<\/strong>. K\u1ebft qu\u1ea3 s\u1ebd nh\u01b0 h\u00ecnh sau:<\/p>\n

    \"K\u1ebft<\/p>\n

    C\u00e1ch 4 <\/span>S\u1eed d\u1ee5ng h\u00e0m SUBTOTAL l\u1ed3ng v\u1edbi IF<\/h3>\n
    \n

    L\u01b0u \u00fd:<\/strong><\/p>\n

      \n
    • B\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng c\u00e1ch n\u00e0y khi s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng Filter.<\/li>\n
    • S\u1ed1 th\u1ee9 t\u1ef1 c\u1ee7a gi\u00e1 tr\u1ecb \u0111\u01b0\u1ee3c ch\u1ecdn s\u1ebd \u0111\u01b0\u1ee3c \u0111\u00e1nh l\u1ea1i t\u1eeb \u0111\u1ea7u khi s\u1eed d\u1ee5ng\u00a0h\u00e0m SUBTOTAL.<\/li>\n
    • C\u00e1ch n\u00e0y ch\u1ec9 \u00e1p d\u1ee5ng \u0111\u01b0\u1ee3c khi \u0111\u00e1nh th\u1ee9 t\u1ef1 theo c\u1ed9t.<\/li>\n<\/ul>\n<\/div>\n

      C\u00fa ph\u00e1p:<\/strong><\/p>\n

      =IF(logical_test, value_if_true, SUBTOTAL(funtion_num, ref1,…))<\/div>\n

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

      C\u00f4ng th\u1ee9c h\u00e0m IF l\u00e0\u00a0=IF(logical_test, value_if_true,\u00a0value_if_false), v\u1edbi:<\/p>\n

        \n
      • logical_test<\/strong>:<\/em>\u00a0\u0110i\u1ec1u ki\u1ec7n c\u1ee7a h\u00e0m IF.<\/li>\n
      • value_if_true<\/strong>:<\/em>\u00a0Gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1 n\u1ebfu \u0111i\u1ec1u ki\u1ec7n \u0111\u00fang.<\/li>\n
      • value_if_false<\/strong>:\u00a0<\/em>Gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1 n\u1ebfu \u0111i\u1ec1u ki\u1ec7n sai. \u1ede \u0111\u00e2y ch\u00fang ta d\u00f9ng h\u00e0m\u00a0SUBTOTAL.<\/li>\n<\/ul>\n

        Trong h\u00e0m\u00a0SUBTOTAL\u00a0c\u00f3 c\u00e1c \u0111\u1ed1i s\u1ed1:<\/p>\n

          \n
        • funtion_num<\/strong>:\u00a0<\/em>Con s\u1ed1 x\u00e1c \u0111\u1ecbnh ch\u1ee9c n\u0103ng th\u1ef1c hi\u1ec7n, t\u1eeb s\u1ed1\u00a01 – 11 l\u00e0 b\u1ecf qua c\u00e1c \u00f4 \u0111\u00e3 \u0111\u01b0\u1ee3c l\u1ecdc ra, nh\u01b0ng \u0111\u1ec3 l\u1ea1i c\u00e1c h\u00e0ng \u0111\u01b0\u1ee3c \u1ea9n th\u1ee7 c\u00f4ng; c\u00f2n s\u1ed1 t\u1eeb 101 \u2013 111 l\u00e0 b\u1ecf qua c\u00e1c \u00f4 \u1ea9n – c\u00e1c \u00f4 \u0111\u00e3 \u0111\u01b0\u1ee3c l\u1ecdc ra v\u00e0 \u1ea9n th\u1ee7 c\u00f4ng.\u00a0Khi nh\u1eadp h\u00e0m SUBTOTAL v\u00e0o 1 \u00f4 ho\u1eb7c tr\u00ean thanh c\u00f4ng th\u1ee9c, Excel s\u1ebd \u0111\u01b0a ra danh s\u00e1ch c\u00e1c con s\u1ed1 n\u00e0y cho b\u1ea1n l\u1ef1a ch\u1ecdn.<\/li>\n
        • ref1<\/strong>,\u00a0ref2<\/strong>,…:\u00a0<\/em>V\u00f9ng ch\u1ee9a s\u1ed1 th\u1ee9 t\u1ef1. Ref1 b\u1eaft bu\u1ed9c ph\u1ea3i c\u00f3, t\u1eeb ref2 \u0111\u1ebfn 254 l\u00e0 t\u00f9y ch\u1ecdn.<\/li>\n<\/ul>\n

          H\u01b0\u1edbng d\u1eabn c\u00e1ch d\u00f9ng:<\/strong><\/p>\n

          Gi\u1ea3 s\u1eed, b\u1ea1n c\u00f3 1 b\u1ea3ng d\u1eef li\u1ec7u nh\u01b0 h\u00ecnh d\u01b0\u1edbi v\u1edbi c\u00e1c d\u00f2ng tr\u1ed1ng v\u00e0 kh\u00f4ng tr\u1ed1ng l\u1eabn l\u1ed9n. Nhi\u1ec7m v\u1ee5 c\u1ee7a b\u1ea1n l\u00e0 \u0111i\u1ec1n s\u1ed1 th\u1ee9 t\u1ef1 \u1ee9ng v\u1edbi c\u00e1c t\u00ean trong danh s\u00e1ch n\u00e0y m\u1ed9t c\u00e1ch t\u1ef1 \u0111\u1ed9ng, tr\u1eeb c\u00e1c \u00f4 tr\u1ed1ng.<\/p>\n

          \"B\u1ea3ng<\/p>\n

          \u0110\u1ec3 \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 t\u1ef1 \u0111\u1ed9ng b\u1eb1ng c\u00e1ch d\u00f9ng h\u00e0m SUBTOTAL k\u1ebft h\u1ee3p h\u00e0m IF b\u1ea1n l\u00e0m theo thao t\u00e1c sau:<\/p>\n

          B\u01b0\u1edbc 1:\u00a0<\/strong>Nh\u1eadp c\u00fa ph\u00e1p t\u1ea1i \u00f4 \u0111\u1ea7u ti\u00ean c\u1ea7n \u0111i\u1ec1n s\u1ed1 th\u1ee9 t\u1ef1 (\u00f4 A2):<\/p>\n

          =IF(B2=””,””,SUBTOTAL(3,$B$2:B2))<\/strong><\/p>\n

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

          H\u00e0m ch\u00ednh c\u1ea7n d\u00f9ng s\u1ebd l\u00e0 IF. N\u1ebfu nh\u01b0 c\u00f3 m\u1ed9t \u00f4 r\u1ed7ng th\u00ec b\u1ecf qua kh\u00f4ng \u0111\u1ebfm. N\u1ebfu \u00f4 kh\u00f4ng r\u1ed7ng th\u00ec d\u00f9ng\u00a0SUBTOTAL \u0111\u1ec3 \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1.<\/p>\n

          Trong h\u00e0m SUBTOTAL c\u00f3 c\u00e1c \u0111\u1ed1i s\u1ed1 c\u1ea7n \u0111i\u1ec1n l\u00e0:<\/p>\n

            \n
          • function_num\u00a0<\/em>l\u00e0 3: \u1ee8ng v\u1edbi c\u00e1ch t\u00ednh l\u00e0 COUNTA – \u0111\u1ebfm \u00f4 kh\u00f4ng tr\u1ed1ng.<\/li>\n
          • ref1<\/em>\u00a0l\u00e0 $B$2:B2: \u0110\u1ebfm k\u00fd t\u1ef1 ph\u00e1t sinh trong kho\u1ea3ng $B$2:B2, trong \u0111\u00f3 \u00f4 B2 \u0111\u01b0\u1ee3c c\u1ed1 \u0111\u1ecbnh b\u1eb1ng d\u1ea5u”$” \u1edf tr\u01b0\u1edbc \u0111\u1ecba ch\u1ec9 h\u00e0ng v\u00e0 \u00f4. N\u1ebfu sao ch\u00e9p c\u00f4ng th\u1ee9c xu\u1ed1ng d\u01b0\u1edbi, gi\u00e1 tr\u1ecb s\u1ebd thay \u0111\u1ed5i theo ki\u1ec3u:\u00a0$B$2:B3,\u00a0$B$2:B4,\u00a0$B$2:B5,… v\u00e0 h\u00e0m s\u1ebd \u0111\u1ebfm \u0111\u00fang, mang v\u1ec1 k\u1ebft qu\u1ea3 nh\u01b0 mong mu\u1ed1n.<\/li>\n<\/ul>\n

            B\u01b0\u1edbc 2:\u00a0<\/strong>Sau khi nh\u1eadp c\u00f4ng th\u1ee9c, b\u1ea1n nh\u1ea5n\u00a0Enter\u00a0<\/strong>r\u1ed3i ti\u1ebfp t\u1ee5c sao ch\u00e9p c\u00f4ng th\u1ee9c \u0111\u1ebfn h\u1ebft b\u1ea3ng (nh\u01b0 \u0111\u00e3 h\u01b0\u1edbng d\u1eabn \u1edf m\u1ee5c 2). K\u1ebft qu\u1ea3 s\u1ebd nh\u01b0 sau:<\/p>\n

            \"T\u1ea1i<\/p>\n

            M\u1ed9t c\u00e1ch kh\u00e1c l\u00e0 s\u1eed d\u1ee5ng h\u00e0m IF k\u1ebft h\u1ee3p COUNTA v\u1edbi c\u00fa ph\u00e1p:<\/p>\n

            =IF(B2=””,””,COUNTA($B$2:B2))<\/strong><\/p>\n

            K\u1ebft qu\u1ea3 sau khi \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 xong s\u1ebd h\u1ec7t nh\u01b0 khi b\u1ea1n nh\u1eadp h\u00e0m IF k\u1ebft h\u1ee3p v\u1edbi SUBTOTAL.<\/p>\n

            \"K\u1ebft<\/p>\n

            Tuy nhi\u00ean, c\u00e1ch n\u00e0y ch\u1ec9 n\u00ean th\u1ef1c hi\u1ec7n khi b\u1ea1n kh\u00f4ng c\u00f3 \u00fd \u0111\u1ecbnh l\u1ecdc d\u1eef li\u1ec7u \u0111\u1ec3 l\u1ea5y qua m\u1ed9t file\/sheet kh\u00e1c, v\u00ec sau khi l\u1ecdc h\u00e0m COUNTA s\u1ebd gi\u1eef nguy\u00ean s\u1ed1 th\u1ee9 t\u1ef1 ban \u0111\u1ea7u \u0111\u01b0\u1ee3c \u0111i\u1ec1n ch\u1ee9 kh\u00f4ng nh\u01b0 SUBTOTAL.<\/p>\n

            Gi\u1ea3 s\u1eed, t\u1eeb b\u1ea3ng d\u1eef li\u1ec7u tr\u00ean b\u1ea1n mu\u1ed1n l\u1ecdc ra danh s\u00e1ch c\u00e1c th\u00e0nh vi\u00ean \u0111\u1ed9i C. B\u1ea1n ti\u1ebfn th\u00e0nh b\u00f4i \u0111en (ch\u1ecdn) b\u1ea3ng d\u1eef li\u1ec7u, v\u00e0o th\u1ebb\u00a0Home > Sort and Filter > Filter<\/strong>.<\/p>\n

            (V\u1edbi phi\u00ean b\u1ea3n Excel c\u0169 h\u01a1n Excel 2016, b\u1ea1n c\u00f3 th\u1ec3 v\u00e0o\u00a0Editing > Ch\u1ecdn Sort and Filter > Filter).<\/p>\n

            \"V\u00e0o<\/p>\n

            T\u1ea1i c\u1ed9t “\u0110\u1ed9i” b\u1ea1n nh\u1ea5p chu\u1ed9t v\u00e0o d\u1ea5u m\u0169i t\u00ean nh\u1ecf h\u00ecnh tam gi\u00e1c ng\u01b0\u1ee3c \u0111\u01b0\u1ee3c b\u1ecdc vi\u1ec1n vu\u00f4ng (nh\u01b0 h\u00ecnh d\u01b0\u1edbi), tick ch\u1ecdn C (\u0111\u1ec3 l\u1ecdc \u0111\u1ed9i C) sau \u0111\u00f3 nh\u1ea5n\u00a0OK<\/strong>.<\/p>\n

            \"Ti\u1ebfn<\/p>\n

            B\u1ea1n c\u00f3 th\u1ec3 xem k\u1ebft qu\u1ea3 so s\u00e1nh d\u01b0\u1edbi \u0111\u00e2y \u0111\u1ec3 h\u00ecnh dung c\u00e1ch m\u00e0 SUBTOTAL v\u00e0 COUNTA ho\u1ea1t \u0111\u1ed9ng:<\/p>\n

            \"K\u1ebft<\/p>\n

            T\u1eeb k\u1ebft qu\u1ea3 \u1edf b\u1ea3ng tr\u00ean c\u00f3 th\u1ec3 th\u1ea5y:<\/p>\n

              \n
            • SUBTOTAL\u00a0<\/strong>ti\u1ebfn h\u00e0nh \u0111\u00e1nh l\u1ea1i s\u1ed1 th\u1ee9 t\u1ef1 khi b\u1ea1n l\u1ecdc d\u1eef li\u1ec7u, thu\u1eadn ti\u1ec7n cho vi\u1ec7c copy qua m\u1ed9t b\u1ea3ng kh\u00e1c \u0111\u1ec3 l\u1eadp danh s\u00e1ch theo d\u00f5i v\u00e0 g\u1eedi d\u1eef li\u1ec7u \u0111i.<\/li>\n
            • COUNTA\u00a0<\/strong>s\u1ebd gi\u1eef nguy\u00ean s\u1ed1 th\u1ee9 t\u1ef1 theo thi\u1ebft l\u1eadp ban \u0111\u1ea7u. B\u1ea1n s\u1ebd c\u1ea7n h\u00e0m n\u00e0y khi mu\u1ed1n gi\u1eef nguy\u00ean s\u1ed1 th\u1ee9 t\u1ef1 theo thi\u1ebft l\u1eadp ban \u0111\u1ea7u \u0111\u1ec3 ti\u1ec7n tra c\u1ee9u v\u00e0 theo d\u00f5i.<\/li>\n<\/ul>\n

              T\u00f9y theo m\u1ee5c \u0111\u00edch s\u1eed d\u1ee5ng b\u1ea1n ch\u1ecdn h\u00e0m ph\u00f9 h\u1ee3p cho d\u1eef li\u1ec7u c\u1ee7a m\u00ecnh nh\u00e9!<\/p>\n","protected":false},"excerpt":{"rendered":"

              C\u00e1ch 1 K\u00e9o chu\u1ed9t \u0111\u1ec3 \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 C\u00e1ch n\u00e0y th\u1ef1c hi\u1ec7n r\u1ea5t nhanh ch\u00f3ng v\u00e0 \u0111\u01a1n gi\u1ea3n. B\u1ea1n ti\u1ebfn h\u00e0nh c\u00e1c thao t\u00e1c sau: B\u01b0\u1edbc 1:\u00a0Nh\u1eadp v\u00e0o 2 s\u1ed1 \u0111\u1ea7u ti\u00ean li\u00ean t\u1ee5c v\u00e0o 2 \u00f4 \u0111\u1ea7u ti\u00ean trong m\u1ea3ng (thao chi\u1ec1u ngang ho\u1eb7c chi\u1ec1u d\u1ecdc) m\u00e0 b\u1ea1n mu\u1ed1n \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 […]<\/p>\n","protected":false},"author":3,"featured_media":9365,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[508],"tags":[],"class_list":["post-9361","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-office"],"_links":{"self":[{"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/posts\/9361","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/comments?post=9361"}],"version-history":[{"count":3,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/posts\/9361\/revisions"}],"predecessor-version":[{"id":9381,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/posts\/9361\/revisions\/9381"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/media\/9365"}],"wp:attachment":[{"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/media?parent=9361"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/categories?post=9361"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/tags?post=9361"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}