{"id":45172,"date":"2021-11-29T01:08:44","date_gmt":"2021-11-28T18:08:44","guid":{"rendered":"https:\/\/ben.com.vn\/tin-tuc\/?p=45172"},"modified":"2021-12-04T11:43:15","modified_gmt":"2021-12-04T04:43:15","slug":"loi-value-trong-excel","status":"publish","type":"post","link":"https:\/\/ben.com.vn\/tin-tuc\/loi-value-trong-excel\/","title":{"rendered":"C\u00e1ch s\u1eeda L\u1ed7i value trong Excel c\u1ef1c k\u1ef3 \u0111\u01a1n gi\u1ea3n, hi\u1ec7u qu\u1ea3 100%"},"content":{"rendered":"

L\u1ed7i value trong Excel<\/strong> l\u00e0 m\u1ed9t l\u1ed7i r\u1ea5t ph\u1ed5 bi\u1ebfn m\u00e0 ch\u1eafc ch\u1eafn nh\u1eefng ai th\u01b0\u1eddng xuy\u00ean s\u1eed d\u1ee5ng h\u00e0m \u0111\u1ec3 t\u00ednh to\u00e1n \u0111\u1ec1u t\u1eebng g\u1eb7p m\u1ed9t l\u1ea7n. Nhi\u1ec1u ng\u01b0\u1eddi l\u1ea7n \u0111\u1ea7u g\u1eb7p l\u1ed7i n\u00e0y c\u00f2n hoang mang kh\u00f4ng bi\u1ebft \u0111\u00e2y l\u00e0 l\u1ed7i g\u00ec v\u00e0 l\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 kh\u1eafc ph\u1ee5c \u0111\u01b0\u1ee3c l\u1ed7i n\u00e0y. Trong b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y, Ben s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch kh\u1eafc ph\u1ee5c l\u1ed7i n\u00e0y m\u1ed9t c\u00e1ch chi ti\u1ebft v\u00e0 \u0111\u01a1n gi\u1ea3n nh\u1ea5t.<\/p>\n

I. L\u1ed7i #value trong excel l\u00e0 g\u00ec?<\/strong><\/h2>\n

L\u1ed7i value trong Excel l\u00e0 m\u1ed9t l\u1ed7i d\u1ec5 x\u1ea3y ra n\u1ebfu c\u00e1c b\u1ea1n nh\u1eadp c\u00f4ng th\u1ee9c sai ho\u1eb7c gi\u00e1 tr\u1ecb trong \u00f4 b\u1ea1n tham chi\u1ebfu c\u00f3 v\u1ea5n \u0111\u1ec1.<\/p>\n

\"L\u1ed7i<\/p>\n

Nguy\u00ean nh\u00e2n c\u1ee7a l\u1ed7i n\u00e0y kh\u00f4ng c\u1ed1 \u0111\u1ecbnh v\u00e0 r\u1ea5t kh\u00f3 \u0111\u1ec3 ki\u1ec3m ch\u1ee9ng nguy\u00ean nh\u00e2n do \u0111\u00e2u. V\u1ec1 c\u01a1 b\u1ea3n, c\u00e1c nguy\u00ean nh\u00e2n th\u01b0\u1eddng g\u1eb7p g\u00e2y ra l\u1ed7i #value trong Excel<\/strong> l\u00e0:<\/p>\n

    \n
  • Ch\u1ee9a k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t trong c\u00e1c \u00f4 gi\u00e1 tr\u1ecb<\/li>\n
  • C\u00f3 kho\u1ea3ng tr\u1ed1ng gi\u1eefa c\u00e1c gi\u00e1 tr\u1ecb<\/li>\n
  • ….<\/li>\n<\/ul>\n

    V\u1edbi m\u1ed7i nguy\u00ean nh\u00e2n n\u00eau tr\u00ean, c\u00e1c b\u1ea1n s\u1ebd c\u00f3 nh\u1eefng c\u00e1ch kh\u1eafc ph\u1ee5c kh\u00e1c nhau. D\u01b0\u1edbi \u0111\u00e2y, Ben Computer s\u1ebd h\u01b0\u1edbng d\u1eabn c\u1ee5 th\u1ec3 t\u1eebng c\u00e1ch kh\u1eafc ph\u1ee5c \u1ee9ng v\u1edbi m\u1ed7i nguy\u00ean nh\u00e2n.<\/p>\n

    II. H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eeda l\u1ed7i value trong Excel \u0111\u01a1n gi\u1ea3n<\/strong><\/h2>\n

    1. C\u00e1ch s\u1eeda l\u1ed7i do ch\u1ee9a k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t<\/strong><\/h3>\n

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

    L\u1ed7i value trong Excel do c\u00f3 k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t<\/em><\/p>\n

    N\u1ebfu nh\u01b0 trong \u00f4 tham chi\u1ebfu c\u00f3 b\u1ea5t k\u1ef3 k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t n\u00e0o c\u0169ng s\u1ebd khi\u1ebfn cho vi\u1ec7c t\u00ednh to\u00e1n trong Excel b\u1ecb l\u1ed7i v\u00e0 th\u00f4ng b\u00e1o l\u1ed7i Value. \u0110\u1ec3 kh\u1eafc ph\u1ee5c, c\u00e1c b\u1ea1n c\u1ea7n lo\u1ea1i b\u1ecf \u0111i nh\u1eefng k\u00fd t\u1ef1 \u0111\u00f3. N\u1ebfu nh\u01b0 k\u00fd t\u1ef1 l\u1ea1 d\u1ec5 nh\u1eadn bi\u1ebft v\u00e0 s\u1ed1 \u00f4 gi\u00e1 tr\u1ecb \u00edt th\u00ec c\u00f3 th\u1ec3 ki\u1ec3m tra th\u1ee7 c\u00f4ng \u0111\u01b0\u1ee3c. Tuy nhi\u00ean, n\u1ebfu trong tr\u01b0\u1eddng h\u1ee3p s\u1ed1 l\u01b0\u1ee3ng \u00f4 gi\u00e1 tr\u1ecb qu\u00e1 nhi\u1ec1u v\u00e0 kh\u00f3 t\u00ecm ra \u0111\u01b0\u1ee3c k\u00fd t\u1ef1 l\u1ea1 th\u00ec c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 l\u00e0m theo c\u00e1ch sau:<\/p>\n

    B\u01b0\u1edbc 1:<\/strong> T\u1ea1o th\u00eam m\u1ed9t c\u1ed9t b\u00ean c\u1ea1nh c\u1ed9t c\u00f3 d\u1eef li\u1ec7u \u0111ang c\u1ea7n ki\u1ec3m tra. Nh\u1eadp c\u00f4ng th\u1ee9c h\u00e0m ISTEXT (h\u00e0m ki\u1ec3m tra k\u00fd t\u1ef1 l\u1ea1 trong \u00f4) v\u00e0o \u00f4 trong c\u1ed9t m\u1edbi t\u1ea1o t\u01b0\u01a1ng \u1ee9ng v\u1edbi \u00f4 \u0111\u1ea7u ti\u00ean c\u1ee7a c\u1ed9t \u0111ang c\u1ea7n ki\u1ec3m tra gi\u00e1 tr\u1ecb.<\/p>\n

    V\u00ed d\u1ee5: \u00f4 \u0111ang c\u1ea7n ki\u1ec3m tra gi\u00e1 tr\u1ecb l\u00e0 B2, h\u00e3y nh\u1eadp = ISTEXT (B2)<\/p>\n

    \"c\u00e1ch<\/p>\n

    Nh\u1eadp c\u00f4ng th\u1ee9c h\u00e0m ISTEXT<\/em><\/p>\n

    B\u01b0\u1edbc 2:<\/strong> \u1ede c\u00e1c \u00f4 kh\u00e1c trong c\u1ed9t, b\u1ea1n sao ch\u00e9p v\u00e0 \u0111i\u1ec1n c\u00f4ng th\u1ee9c t\u01b0\u01a1ng t\u1ef1 nh\u01b0 \u00f4 \u0111\u1ea7u.<\/p>\n

    Khi \u0111\u00f3, c\u00e1c b\u1ea1n s\u1ebd th\u1ea5y k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 t\u1ea1i \u00f4 True v\u00e0 False.<\/p>\n

      \n
    • True<\/strong>: \u00f4 c\u00f3 ch\u1ee9a k\u00fd t\u1ef1 l\u1ea1<\/li>\n
    • False:<\/strong> \u00f4 kh\u00f4ng ch\u1ee9a k\u00fd t\u1ef1 l\u1ea1<\/li>\n<\/ul>\n

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

      Sao ch\u00e9p v\u00e0 \u0111i\u1ec1n c\u00f4ng th\u1ee9c t\u01b0\u01a1ng t\u1ef1 nh\u01b0 \u00f4 \u0111\u1ea7u<\/em><\/p>\n

      B\u01b0\u1edbc 3:<\/strong> Sau \u0111\u00f3, c\u00e1c b\u1ea1n h\u00e3y ki\u1ec3m tra v\u00e0 x\u00f3a nh\u1eefng k\u00fd t\u1ef1 l\u1ea1 c\u00f3 trong \u00f4 b\u00e1o True cho \u0111\u1ebfn khi t\u1ea5t c\u1ea3 c\u00e1c \u00f4 tr\u1ea3 v\u1ec1 False.<\/p>\n

      \"l\u1ed7i<\/p>\n

      Ki\u1ec3m tra v\u00e0 x\u00f3a nh\u1eefng k\u00fd t\u1ef1 l\u1ea1 c\u00f3 trong \u00f4 b\u00e1o True<\/em><\/p>\n

      B\u01b0\u1edbc 4:<\/strong> X\u00f3a b\u1ecf c\u1ed9t th\u00eam l\u00fac \u0111\u1ea7u, k\u1ebft qu\u1ea3 s\u1ebd kh\u00f4ng b\u00e1o Value n\u1eefa.<\/p>\n

      \"excel<\/p>\n

      X\u00f3a b\u1ecf c\u1ed9t th\u00eam l\u00fac \u0111\u1ea7u<\/em><\/p>\n

      2. C\u00e1ch s\u1eeda l\u1ed7i value trong Excel do kho\u1ea3ng tr\u1ed1ng gi\u1eefa c\u00e1c gi\u00e1 tr\u1ecb<\/strong><\/h3>\n

      Kho\u1ea3ng tr\u1ed1ng gi\u1eefa c\u00e1c gi\u00e1 tr\u1ecb l\u00e0 nguy\u00ean nh\u00e2n kh\u00f3 nh\u1eadn di\u1ec7n nh\u1ea5t trong s\u1ed1 c\u00e1c nguy\u00ean nh\u00e2n. B\u1edfi b\u1eb1ng m\u1eaft th\u01b0\u1eddng, m\u1ecdi ng\u01b0\u1eddi s\u1ebd kh\u00f3 nh\u1eadn ra \u0111\u01b0\u1ee3c kho\u1ea3ng tr\u1ed1ng th\u1eeba \u1edf ch\u1ed7 n\u00e0o. \u0110\u1ec3 x\u00f3a nh\u1eefng kho\u1ea3ng tr\u1ed1ng kh\u00f4ng c\u1ea7n thi\u1ebft, c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n theo hai c\u00e1ch d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n

      2.1. D\u00f9ng c\u00f4ng c\u1ee5 t\u00ecm ki\u1ebfm v\u00e0 thay th\u1ebf \u0111\u1ec3 b\u1ecf \u0111i nh\u1eefng kho\u1ea3ng tr\u1ed1ng<\/strong><\/h4>\n

      \"c\u00e1ch<\/p>\n

      Kh\u1eafc ph\u1ee5c l\u1ed7i value trong excel do c\u00f3 \u00f4 tr\u1eafng<\/em><\/p>\n

      B\u01b0\u1edbc 1:<\/strong> Ch\u1ecdn nh\u1eefng \u00f4 \u0111\u1ecbnh tham chi\u1ebfu => b\u1ea5m t\u1ed5 h\u1ee3p Ctrl + H<\/p>\n

      B\u01b0\u1edbc 2:<\/strong> Sau khi c\u1eeda s\u1ed5 Find and replace<\/strong> hi\u1ec7n l\u00ean, m\u1edf v\u00e0o tab replace<\/strong>, t\u1ea1i \u00f4 find what<\/strong>, \u1ea5n 1 l\u1ea7n d\u1ea5u c\u00e1ch. C\u00f2n t\u1ea1i ph\u1ea7n replace with<\/strong>, c\u00e1c b\u1ea1n h\u00e3y \u0111\u1ec3 nguy\u00ean => ch\u1ecdn Replace all.<\/strong><\/p>\n

      \"b\u1ecb<\/p>\n

      Nh\u1eadp 1 d\u1ea5u c\u00e1ch v\u00e0o \u00f4 find what, \u0111\u1ec3 nguy\u00ean ph\u1ea7n replace with => Replace all<\/em><\/p>\n

      2.2. D\u00f9ng b\u1ed9 l\u1ecdc \u0111\u1ec3 l\u1ecdc \u0111i kho\u1ea3ng tr\u1ed1ng<\/strong><\/h4>\n

      B\u01b0\u1edbc 1:<\/strong> Ch\u1ecdn nh\u1eefng \u00f4 mu\u1ed1n l\u1ecdc b\u1ecf \u0111i kho\u1ea3ng tr\u1ed1ng =><\/strong> Tr\u00ean thanh menu, ch\u1ecdn Data<\/strong> =><\/strong> ch\u1ecdn Filter.<\/strong><\/p>\n

      \"kh\u1eafc<\/p>\n

      Ch\u1ecdn nh\u1eefng \u00f4 mu\u1ed1n l\u1ecdc b\u1ecf \u0111i kho\u1ea3ng tr\u1ed1ng =><\/strong>Data<\/strong> =><\/strong> Filter<\/strong><\/em><\/p>\n

      B\u01b0\u1edbc 2:\u00a0<\/strong>T\u1ea1i \u00f4 \u0111\u1ea7u ti\u00ean c\u1ee7a c\u1ed9t \u0111\u00e3 \u0111\u01b0\u1ee3c \u0111\u1eb7t b\u1ed9 l\u1ecdc, ch\u1ecdn m\u1edf r\u1ed9ng b\u1ed9 l\u1ecdc => t\u00edch ch\u1ecdn duy nh\u1ea5t \u00f4 Blank => ch\u1ecdn Ok.<\/p>\n

      \"\u1ea9n<\/p>\n

      Ch\u1ecdn m\u1edf r\u1ed9ng b\u1ed9 l\u1ecdc t\u1ea1i \u00f4 \u0111\u1ea7u ti\u00ean => t\u00edch ch\u1ecdn duy nh\u1ea5t \u00f4 Blank => ch\u1ecdn Ok<\/em><\/p>\n

      B\u01b0\u1edbc 3:<\/strong> Sau khi l\u1ecdc, m\u00e0n h\u00ecnh s\u1ebd hi\u1ec3n th\u1ecb nh\u1eefng \u00f4 c\u00f3 ch\u1ee9a kho\u1ea3ng tr\u1eafng => ch\u1ecdn h\u1ebft nh\u1eefng \u00f4 \u0111\u00f3 v\u00e0 b\u1ea5m n\u00fat Delete tr\u00ean b\u00e0n ph\u00edm.<\/p>\n

      \"b\u00e1o<\/p>\n

      Ch\u1ecdn h\u1ebft nh\u1eefng \u00f4 c\u00f3 kho\u1ea3ng tr\u1eafng tr\u00ean m\u00e0n h\u00ecnh v\u00e0 b\u1ea5m n\u00fat Delete tr\u00ean b\u00e0n ph\u00edm<\/em><\/p>\n

      B\u01b0\u1edbc 4:\u00a0<\/strong>Sau khi x\u00f3a h\u1ebft c\u00e1c \u00f4 ch\u1ee9a kho\u1ea3ng tr\u1ed1ng, c\u00e1c b\u1ea1n ch\u1ecdn m\u1edf r\u1ed9ng b\u1ed9 l\u1ecdc m\u1ed9t l\u1ea7n n\u1eefa =><\/strong> ch\u1ecdn Clear Filter From… => Ok.\u00a0<\/strong><\/p>\n

      \"gi\u00e1<\/p>\n

      Ch\u1ecdn m\u1edf r\u1ed9ng b\u1ed9 l\u1ecdc m\u1ed9t l\u1ea7n n\u1eefa => ch\u1ecdn Clear Filter From… => Ok<\/em><\/p>\n

      B\u01b0\u1edbc 5:<\/strong> T\u1eaft b\u1ed9 l\u1ecdc, m\u00e0n h\u00ecnh s\u1ebd hi\u1ec3n th\u1ecb nh\u01b0 d\u01b0\u1edbi, k\u1ebft qu\u1ea3 \u0111\u01b0\u1ee3c t\u00ednh ch\u00ednh x\u00e1c v\u00e0 kh\u00f4ng c\u00f2n l\u1ed7i.<\/p>\n

      \"l\u1ed7i<\/p>\n

      K\u1ebft qu\u1ea3 sau khi l\u1ecdc<\/em><\/p>\n

      K\u1ebft lu\u1eadn:\u00a0<\/strong>Tr\u00ean \u0111\u00e2y l\u00e0 h\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eeda l\u1ed7i Value trong Excel<\/strong> c\u1ef1c k\u1ef3 \u0111\u01a1n gi\u1ea3n v\u00e0 nhanh ch\u00f3ng. Ch\u00fac b\u1ea1n th\u1ef1c hi\u1ec7n th\u00e0nh c\u00f4ng. N\u1ebfu c\u00f2n b\u1ea5t c\u1ee9 th\u1eafc m\u1eafc n\u00e0o c\u1ea7n gi\u1ea3i \u0111\u00e1p, h\u00e3y comment xu\u1ed1ng ph\u00eda d\u01b0\u1edbi \u0111\u1ec3 th\u1ea3o lu\u1eadn c\u00f9ng Ben Computer nh\u00e9.<\/p>\n","protected":false},"excerpt":{"rendered":"

      L\u1ed7i value trong Excel l\u00e0 m\u1ed9t l\u1ed7i r\u1ea5t ph\u1ed5 bi\u1ebfn m\u00e0 ch\u1eafc ch\u1eafn nh\u1eefng ai th\u01b0\u1eddng xuy\u00ean s\u1eed d\u1ee5ng h\u00e0m \u0111\u1ec3 t\u00ednh to\u00e1n \u0111\u1ec1u t\u1eebng g\u1eb7p m\u1ed9t l\u1ea7n. Nhi\u1ec1u ng\u01b0\u1eddi l\u1ea7n \u0111\u1ea7u g\u1eb7p l\u1ed7i n\u00e0y c\u00f2n hoang mang kh\u00f4ng bi\u1ebft \u0111\u00e2y l\u00e0 l\u1ed7i g\u00ec v\u00e0 l\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 kh\u1eafc ph\u1ee5c \u0111\u01b0\u1ee3c l\u1ed7i n\u00e0y. Trong […]<\/p>\n","protected":false},"author":18,"featured_media":45256,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_links_to":"","_links_to_target":""},"categories":[11],"tags":[],"class_list":["post-45172","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-thu-thuat-van-phong"],"_links":{"self":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/45172","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/users\/18"}],"replies":[{"embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/comments?post=45172"}],"version-history":[{"count":5,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/45172\/revisions"}],"predecessor-version":[{"id":46820,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/45172\/revisions\/46820"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/media\/45256"}],"wp:attachment":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/media?parent=45172"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/categories?post=45172"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/tags?post=45172"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}