{"id":7582,"date":"2024-12-21T18:01:20","date_gmt":"2024-12-21T18:01:20","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/so-sanh-chuoi-tim-chuoi-gan-dung-trong-excel\/"},"modified":"2024-12-21T18:01:20","modified_gmt":"2024-12-21T18:01:20","slug":"so-sanh-chuoi-tim-chuoi-gan-dung-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/so-sanh-chuoi-tim-chuoi-gan-dung-trong-excel\/","title":{"rendered":"So s\u00e1nh chu\u1ed7i, t\u00ecm chu\u1ed7i g\u1ea7n \u0111\u00fang trong Excel"},"content":{"rendered":"
\n

B\u00e0i n\u00e0y, m\u00ecnh ch\u1ecdn l\u00e0m b\u00e0i \u0111\u1ea7u ti\u00ean trong Series VBA \u0111\u00e3 c\u1ee9u t\u00f4i nh\u01b0 th\u1ebf n\u00e0o \u2013 How did VBA save my ass? C\u00e1c b\u1ea1n ngh\u0129 c\u00f3 th\u1ec3 kh\u00f4ng c\u00f3 g\u00ec to t\u00e1t c\u1ea3, nh\u01b0ng v\u00e0o n\u0103m 3 \u0111\u1ea1i h\u1ecdc, v\u1edbi c\u00f4ng vi\u1ec7c th\u1ef1c t\u1eadp trong 1 t\u1eadp \u0111o\u00e0n t\u1ea7m c\u1ee1 qu\u1ed1c t\u1ebf v\u00e0 l\u00e0m vi\u1ec7c trong b\u1ed9 ph\u1eadn CIO Advisory th\u00ec v\u01b0\u1ee3t qua t\u1eebng ng\u00e0y l\u00e0m vi\u1ec7c trong su\u1ed1t 6 th\u00e1ng l\u00e0 c\u1ea3 1 k\u00ec t\u00edch. Kh\u00f4ng ph\u1ea3i v\u00ec m\u00ecnh d\u1ed1t, kh\u00f4ng ph\u1ea3i v\u00ec m\u00ecnh kh\u00f4ng l\u00e0m \u0111\u01b0\u1ee3c vi\u1ec7c. M\u00ecnh d\u1ed1t 1 c\u00e1ch b\u00ecnh th\u01b0\u1eddng, c\u00e1i kh\u00f3 \u1edf \u0111\u00e2y l\u00e0 l\u01b0\u1ee3ng c\u00f4ng vi\u1ec7c r\u1ea5t l\u1edbn v\u00e0 \u00e1p l\u1ef1c \u0111\u1ec3 ho\u00e0n th\u00e0nh c\u00f4ng vi\u1ec7c \u0111\u00f3 c\u0169ng qu\u00e1 l\u1edbn. M\u00ecnh s\u1ebd kh\u00f4ng d\u00e0i d\u00f2ng k\u1ec3 v\u1ec1 th\u1eddi \u0111\u00f3 n\u1eefa v\u00ec s\u1ebd l\u00e0m ch\u00e1n c\u00e1c b\u1ea1n.<\/p>\n

Ch\u00fang ta c\u00f3 1 nhi\u1ec7m v\u1ee5 \u0111\u01a1n gi\u1ea3n: c\u00f3 2 c\u1ed9t g\u1ed3m t\u00ean c\u1ee7a c\u00e1c c\u00f4ng ty, m\u1ed9t c\u1ed9t g\u1ed3m c\u00f3 2000 c\u00f4ng ty, m\u1ed9t c\u1ed9t g\u1ed3m c\u00f3 8000 c\u00f4ng ty, l\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 bi\u1ebft \u0111\u01b0\u1ee3c trong 2000 c\u00f4ng ty n\u00e0y th\u00ec c\u00f4ng ty n\u00e0o \u0111\u00e3 \u1edf trong s\u1ed1 8000 c\u00f4ng ty b\u00ean c\u1ed9t kia, t\u00ean c\u1ee7a c\u00e1c c\u00f4ng ty kh\u00f4ng tr\u00f9ng kh\u1edbp 100%, \u0111\u00f4i khi thi\u1ebfu 1 v\u00e0i ch\u1eef, th\u1eeba 1 v\u00e0i ch\u1eef, 1 v\u00e0i ch\u1eef kh\u00f4ng ch\u00ednh x\u00e1c. C\u00e1c h\u00e0m d\u00f2 t\u00ecm v\u00e0 t\u00ecm ki\u1ebfm s\u1ebd kh\u00f4ng gi\u00fap \u0111\u01b0\u1ee3c g\u00ec cho c\u00e1c b\u1ea1n trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y. C\u00e1c b\u1ea1n c\u00f3 2 ti\u1ebfng \u0111\u1ec3 \u0111\u01b0a ra k\u1ebft qu\u1ea3, l\u00e0m thuy\u1ebft tr\u00ecnh v\u00e0 b\u00e1o c\u00e1o.<\/p>\n

L\u00fac \u0111\u00f3, m\u00ecnh suy ngh\u0129 th\u1ebf n\u00e0y: b\u1eaft \u0111\u1ea7u t\u1eeb d\u1eef ki\u1ec7n, t\u00ean c\u00e1c c\u00f4ng ty ch\u1ec9 g\u1ea7n gi\u1ed1ng nhau ch\u1eef kh\u00f4ng gi\u1ed1ng nhau ho\u00e0n to\u00e0n, ch\u1eafc h\u1eb3n ph\u1ea3i c\u00f3 1 ch\u1ec9 s\u1ed1 n\u00e0o \u0111\u00f3 cho s\u1ef1 gi\u1ed1ng nhau gi\u1eefa 2 chu\u1ed7i. Ch\u00eca kho\u00e1 l\u00e0 \u0111\u00e2y, t\u1eeb kho\u00e1 l\u00e0 kia, th\u1ef1c ra v\u1ea5n \u0111\u1ec1 n\u00e0y kh\u00f4ng m\u1edbi, c\u00f3 1 v\u00e0i anh zai \u0111\u00e3 nghi\u00ean c\u1ee9u tr\u01b0\u1edbc r\u1ed3i, v\u00e0 ph\u01b0\u01a1ng ph\u00e1p hay t\u00ean c\u1ee7a c\u00e1c thu\u1eadt to\u00e1n \u0111\u01b0\u1ee3c l\u1ea5y theo t\u00ean c\u00e1c anh. M\u1ed9t v\u00e0i anh ti\u00eau bi\u1ec3u l\u00e0 Lehvenstein, Jaccard (\u0111\u1ecdc nh\u01b0 Gia C\u00e1t v\u1eady =)) ),\u00a0Jaro-Winkler v\u00e0\u00a0Longest common subsequence. T\u1edbi \u0111\u00e2y th\u00ec m\u00ecnh ch\u1ecdn anh Lehvenstein v\u00ec \u0111\u1eb9p trai. Sau \u0111\u00f3 bi\u1ebft \u0111\u01b0\u1ee3c thu\u1eadt to\u00e1n r\u1ed3i, th\u00ec code VBA nh\u01b0 sau \u0111\u1ec3 t\u1ea1o ra \u0111\u01b0\u1ee3c 1 c\u00e1i UDF c\u00f3 ch\u1ee9c n\u0103ng nh\u01b0 sau:<\/p>\n

    \n
  1. \u0110\u00e1nh gi\u00e1 s\u1ef1 gi\u1ed1ng nhau gi\u1eefa 2 \u0111o\u1ea1n Text<\/li>\n
  2. Tr\u1ea3 v\u1ec1 t\u00ean gi\u1ed1ng nh\u1ea5t<\/li>\n
  3. Tr\u1ea3 v\u1ec1 s\u1ed1 th\u1ee9 t\u1ef1 c\u1ee7a t\u00ean gi\u1ed1ng nh\u1ea5t<\/li>\n
  4. Tr\u1ea3 v\u1ec1 % gi\u1ed1ng nhau gi\u1eefa 2 c\u00e1i t\u00ean<\/li>\n<\/ol>\n

    C\u00e1c b\u1ea1n tham kh\u1ea3o code trong file Excel sau \u0111\u00e2y:<\/p>\n

    https:\/\/drive.google.com\/open?id=14J8Zgqj5B7NovcZjxpZrj-33WI87Oe1Y<\/a><\/p>\n

    C\u00e1ch s\u1eed d\u1ee5ng v\u00e0 h\u00ecnh minh ho\u1ea1 nh\u01b0 sau:<\/p>\n

    H\u00ecnh 1<\/p>\n

    \"ten-gan-giong-nhau-vba-01\"<\/a><\/p>\n

    \n
    \n
    \n
    \n<\/a>\n<\/div>\n<\/div>\n
    \n
    \n
    \n
    \n<\/a>\n<\/div>\n<\/div>\n

    H\u00ecnh 2<\/p>\n

    \"ten-gan-giong-nhau-vba-02\"<\/a><\/p>\n

    K\u1ebft qu\u1ea3 l\u00e0, t\u00ecm ki\u1ebfm v\u00e0 th\u1ef1c hi\u1ec7n gi\u1ea3i quy\u1ebft v\u1ea5n \u0111\u1ec1 trong v\u00f2ng 45 ph\u00fat, code ch\u1ea1y m\u1ea5t 45 ph\u00fat, l\u00e0m thuy\u1ebft tr\u00ecnh b\u00e1o c\u00e1o m\u1ea5t 15 ph\u00fat, u\u1ed1ng Cafe m\u1ea5t 5 ph\u00fat, m\u00ecnh c\u00f2n 10 ph\u00fat \u0111\u1ec3 chu\u1ea9n b\u1ecb v\u00e0o b\u00e1o c\u00e1o v\u00e0 k\u1ebft qu\u1ea3 l\u00e0 m\u1ecdi chuy\u1ec7n \u0111\u00e3 di\u1ec5n ra t\u1ed1t \u0111\u1eb9p.<\/p>\n

    T\u1eeb l\u00fac \u0111\u00f3 \u0111\u1ebfn nay l\u00e0 5 n\u0103m r\u1ed3i, ch\u1eafc h\u1eb3n c\u00f3 nhi\u1ec1u ph\u01b0\u01a1ng ph\u00e1p kh\u00e1c nhanh h\u01a1n v\u00e0 hi\u1ec7n \u0111\u1ea1i h\u01a1n s\u1eed d\u1ee5ng Fuzzy Search \/ Matching v\u1edbi c\u00e1c lo\u1ea1i Database Engine nh\u01b0ng v\u00e0o th\u1eddi \u0111i\u1ec3m \u0111\u00f3, ki\u1ebfm c\u1ee7a m\u00ecnh ch\u1ec9 l\u00e0 Excel v\u00e0 VBA. Ki\u1ebfm c\u1ee7a m\u00ecnh \u0111\u00e3 c\u1ee9u m\u00ecnh nh\u01b0 th\u1ebf.<\/p>\n

    Kh\u00e1m ph\u00e1 nh\u1eefng t\u00ednh n\u0103ng th\u1ea7n th\u00e1nh c\u1ee7a VBA t\u1ea1i\u00a0kho\u00e1 h\u1ecdc\u00a0VBA101 \u2013 VBA c\u01a1 b\u1ea3n d\u00e0nh cho ng\u01b0\u1eddi m\u1edbi b\u1eaft \u0111\u1ea7u<\/a> nh\u00e9. Th\u00f4ng tin chi ti\u1ebft v\u1ec1 kh\u00f3a h\u1ecdc, b\u1ea1n vui l\u00f2ng xem t\u1ea1i \u0111\u01b0\u1eddng link: https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau<\/a><\/p>\n<\/div>\n

    \n

    Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n

    T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0\ud83d\udcd6<\/span><\/a><\/p>\n

    H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n

    HKD H\u1ecdc Excel Online
    S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n

    \n

    \u00a9 document.currentScript.insertAdjacentHTML(‘afterend’, ” + new Intl.DateTimeFormat(document.documentElement.lang, {year: ‘numeric’}).format() + ”); H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

    \n
    \n
    \n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":7583,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-7582","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-nang-cao"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/7582","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/comments?post=7582"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/7582\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/7583"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=7582"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=7582"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=7582"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}