{"id":436,"date":"2025-07-16T13:55:51","date_gmt":"2025-07-16T05:55:51","guid":{"rendered":"https:\/\/alisonyip.viekee.com\/?p=436"},"modified":"2025-07-16T13:55:51","modified_gmt":"2025-07-16T05:55:51","slug":"%e8%ae%a1%e7%ae%97%e8%a1%a8%e6%a0%bc%e5%8c%b9%e9%85%8d%e5%86%85%e5%ae%b9%ef%bc%8c%e7%ac%a6%e5%90%88%e5%ad%97%e7%ac%a6%e6%95%b0","status":"publish","type":"post","link":"https:\/\/alisonyip.viekee.com\/?p=436","title":{"rendered":"\u8ba1\u7b97\u8868\u683c\u5339\u914d\u5185\u5bb9\uff0c\u7b26\u5408\u5b57\u7b26\u6570"},"content":{"rendered":"\n<h4 class=\"wp-block-heading\">\u65b9\u68481\uff1a\u53bb\u91cd\u7edf\u8ba1\u6cd5\uff08\u63a8\u8350\uff09<\/h4>\n\n\n\n<p><code>=SUM(--(LEN(M14)-LEN(SUBSTITUTE(M14,MID(B14,SEQUENCE(LEN(B14)),1),\"\"))>0))<\/code><\/p>\n\n\n\n<ul>\n<li>\u200c<strong>\u539f\u7406<\/strong>\u200c\uff1a<br>\u7edf\u8ba1B14\u6bcf\u4e2a\u5b57\u7b26\u5728M14\u4e2d\u662f\u5426\u81f3\u5c11\u51fa\u73b01\u6b21\uff08\u4e0d\u91cd\u590d\u7d2f\u8ba1\uff09<\/li>\n\n\n\n<li>\u200c<strong>\u6267\u884c\u7ed3\u679c<\/strong>\u200c\uff1a<br>\u4ec5\u5f53\u5b57\u7b26\u5728M14\u5b58\u5728\u65f6\u8ba11\u6b21\uff0c\u907f\u514d\u91cd\u590d\u8ba1\u6570<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\">\u65b9\u68482\uff1a\u552f\u4e00\u5b57\u7b26\u5339\u914d<\/h4>\n\n\n\n<p>excelCopy Code<\/p>\n\n\n\n<p><code>=SUMPRODUCT(--ISNUMBER(SEARCH(UNIQUE(MID(B14,SEQUENCE(LEN(B14)),1)),M14)))<\/code><\/p>\n\n\n\n<ul>\n<li>\u200c<strong>\u8981\u6c42<\/strong>\u200c\uff1a\u9700Excel 365\u652f\u6301<code>UNIQUE<\/code>\u51fd\u6570<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\">\u65b9\u68483\uff1a\u4f20\u7edf\u6570\u7ec4\u516c\u5f0f<\/h4>\n\n\n\n<p>excelCopy Code<\/p>\n\n\n\n<p><code>=SUM(IF(FREQUENCY(IFERROR(MATCH(MID(B14,ROW(INDIRECT(\"1:\"&amp;LEN(B14))),1),MID(M14,ROW(INDIRECT(\"1:\"&amp;LEN(M14))),1),0),\"\"),ROW(INDIRECT(\"1:\"&amp;LEN(B14))))&gt;0,1))<\/code><\/p>\n\n\n\n<ul>\n<li>\u200c<strong>\u517c\u5bb9\u6027<\/strong>\u200c\uff1a\u652f\u6301\u65e7\u7248Excel\uff08\u9700Ctrl+Shift+Enter\u8f93\u5165\uff09<\/li>\n<\/ul>\n\n\n\n<p><\/p>\n\n\n\n<p>LEN\uff08\u5355\u5143\u683c\uff09<\/p>\n\n\n\n<p>\u7edf\u8ba1\u5355\u5143\u683c\u5185\u5b57\u7b26\u6570<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>\u7528\u4e0a\u9762\u516c\u5f0f\/len\uff0c\u8ba1\u7b97\u7b26\u5408\u7a0b\u5ea6<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u65b9\u68481\uff1a\u53bb\u91cd\u7edf\u8ba1\u6cd5\uff08\u63a8\u8350\uff09 =SUM(&#8211;(LEN(M14)-LEN(SUBSTITUTE(M14,MID(B14,SEQUENCE(LEN(B14)),1),&#8230;<\/p>\n<p class=\"read-more\"><a class=\"btn btn-default\" href=\"https:\/\/alisonyip.viekee.com\/?p=436\"> Read More<span class=\"screen-reader-text\">  Read More<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"_links":{"self":[{"href":"https:\/\/alisonyip.viekee.com\/index.php?rest_route=\/wp\/v2\/posts\/436"}],"collection":[{"href":"https:\/\/alisonyip.viekee.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/alisonyip.viekee.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/alisonyip.viekee.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/alisonyip.viekee.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=436"}],"version-history":[{"count":1,"href":"https:\/\/alisonyip.viekee.com\/index.php?rest_route=\/wp\/v2\/posts\/436\/revisions"}],"predecessor-version":[{"id":437,"href":"https:\/\/alisonyip.viekee.com\/index.php?rest_route=\/wp\/v2\/posts\/436\/revisions\/437"}],"wp:attachment":[{"href":"https:\/\/alisonyip.viekee.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=436"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/alisonyip.viekee.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=436"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/alisonyip.viekee.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=436"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}