{"id":1496,"date":"2026-04-10T06:50:51","date_gmt":"2026-04-10T06:50:51","guid":{"rendered":"https:\/\/yuanstore.tw\/e-learning\/?p=1496"},"modified":"2026-04-20T14:44:27","modified_gmt":"2026-04-20T14:44:27","slug":"excel05-%e6%9f%a5%e8%a9%a2%e5%87%bd%e6%95%b8","status":"publish","type":"post","link":"https:\/\/yuanstore.tw\/e-learning\/excel05-%e6%9f%a5%e8%a9%a2%e5%87%bd%e6%95%b8\/","title":{"rendered":"Excel05 &#8211; \u67e5\u8a62\u51fd\u6578"},"content":{"rendered":"\n<div class=\"wp-block-uagb-container uagb-block-1e7243d1 alignfull uagb-is-root-container\"><div class=\"uagb-container-inner-blocks-wrap\">\n<div class=\"wp-block-uagb-advanced-heading uagb-block-eefac489\"><div id=\"ez-toc-container\" class=\"ez-toc-v2_0_87_1 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">\u5167\u5bb9\u76ee\u9304<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"\u986f\u793a\/\u96b1\u85cf\u5167\u5bb9\u76ee\u9304\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/yuanstore.tw\/e-learning\/excel05-%e6%9f%a5%e8%a9%a2%e5%87%bd%e6%95%b8\/#%F0%9F%8E%AF_%E5%AD%B8%E7%A8%8B%E7%9B%AE%E6%A8%99\" >\ud83c\udfaf \u5b78\u7a0b\u76ee\u6a19<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/yuanstore.tw\/e-learning\/excel05-%e6%9f%a5%e8%a9%a2%e5%87%bd%e6%95%b8\/#%F0%9F%93%9D%E6%9F%A5%E8%A9%A2%E5%87%BD%E6%95%B8\" >\ud83d\udcdd\u67e5\u8a62\u51fd\u6578<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/yuanstore.tw\/e-learning\/excel05-%e6%9f%a5%e8%a9%a2%e5%87%bd%e6%95%b8\/#%E6%9F%A5%E8%A9%A2%E7%9A%84%E6%9C%AC%E8%B3%AA\" >\u67e5\u8a62\u7684\u672c\u8cea<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/yuanstore.tw\/e-learning\/excel05-%e6%9f%a5%e8%a9%a2%e5%87%bd%e6%95%b8\/#VLOOKUP\" >VLOOKUP<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/yuanstore.tw\/e-learning\/excel05-%e6%9f%a5%e8%a9%a2%e5%87%bd%e6%95%b8\/#%E8%AA%9E%E6%B3%95\" >\u8a9e\u6cd5<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/yuanstore.tw\/e-learning\/excel05-%e6%9f%a5%e8%a9%a2%e5%87%bd%e6%95%b8\/#%E9%87%8D%E9%BB%9E\" >\u91cd\u9ede<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/yuanstore.tw\/e-learning\/excel05-%e6%9f%a5%e8%a9%a2%e5%87%bd%e6%95%b8\/#XLOOKUP\" >XLOOKUP<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/yuanstore.tw\/e-learning\/excel05-%e6%9f%a5%e8%a9%a2%e5%87%bd%e6%95%b8\/#%E8%AA%9E%E6%B3%95-2\" >\u8a9e\u6cd5<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/yuanstore.tw\/e-learning\/excel05-%e6%9f%a5%e8%a9%a2%e5%87%bd%e6%95%b8\/#%E9%87%8D%E9%BB%9E-2\" >\u91cd\u9ede<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/yuanstore.tw\/e-learning\/excel05-%e6%9f%a5%e8%a9%a2%e5%87%bd%e6%95%b8\/#%E9%A1%8C%E7%9B%AE\" >\u984c\u76ee<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/yuanstore.tw\/e-learning\/excel05-%e6%9f%a5%e8%a9%a2%e5%87%bd%e6%95%b8\/#INDEX%E3%80%81MATCH\" >INDEX\u3001MATCH<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/yuanstore.tw\/e-learning\/excel05-%e6%9f%a5%e8%a9%a2%e5%87%bd%e6%95%b8\/#MATCH%EF%BC%88%E6%89%BE%E4%BD%8D%E7%BD%AE%EF%BC%89\" >MATCH\uff08\u627e\u4f4d\u7f6e\uff09<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/yuanstore.tw\/e-learning\/excel05-%e6%9f%a5%e8%a9%a2%e5%87%bd%e6%95%b8\/#%E8%AA%9E%E6%B3%95-3\" >\u8a9e\u6cd5<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/yuanstore.tw\/e-learning\/excel05-%e6%9f%a5%e8%a9%a2%e5%87%bd%e6%95%b8\/#INDEX%EF%BC%88%E5%82%B3%E5%9B%9E%E8%B3%87%E6%96%99%EF%BC%89\" >INDEX\uff08\u50b3\u56de\u8cc7\u6599\uff09<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-15\" href=\"https:\/\/yuanstore.tw\/e-learning\/excel05-%e6%9f%a5%e8%a9%a2%e5%87%bd%e6%95%b8\/#%E8%AA%9E%E6%B3%95-4\" >\u8a9e\u6cd5<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-16\" href=\"https:\/\/yuanstore.tw\/e-learning\/excel05-%e6%9f%a5%e8%a9%a2%e5%87%bd%e6%95%b8\/#UNIQUE\" >UNIQUE<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-17\" href=\"https:\/\/yuanstore.tw\/e-learning\/excel05-%e6%9f%a5%e8%a9%a2%e5%87%bd%e6%95%b8\/#%E8%AA%9E%E6%B3%95-5\" >\u8a9e\u6cd5<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-18\" href=\"https:\/\/yuanstore.tw\/e-learning\/excel05-%e6%9f%a5%e8%a9%a2%e5%87%bd%e6%95%b8\/#FILTER\" >FILTER<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-19\" href=\"https:\/\/yuanstore.tw\/e-learning\/excel05-%e6%9f%a5%e8%a9%a2%e5%87%bd%e6%95%b8\/#%E8%AA%9E%E6%B3%95-6\" >\u8a9e\u6cd5<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-20\" href=\"https:\/\/yuanstore.tw\/e-learning\/excel05-%e6%9f%a5%e8%a9%a2%e5%87%bd%e6%95%b8\/#SORT%E3%80%81SORTBY\" >SORT\u3001SORTBY<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2 class=\"uagb-heading-text\"><span class=\"ez-toc-section\" id=\"%F0%9F%8E%AF_%E5%AD%B8%E7%A8%8B%E7%9B%AE%E6%A8%99\"><\/span>\ud83c\udfaf \u5b78\u7a0b\u76ee\u6a19<span class=\"ez-toc-section-end\"><\/span><\/h2><\/div>\n\n\n\n<ol class=\"wp-block-list has-medium-font-size\">\n<li>\u8cc7\u6599\u641c\u5c0b\uff0c\u8cc7\u6599\u95dc\u806f<\/li>\n\n\n\n<li>\u5efa\u7acb\u8cc7\u6599\u5eab\u6982\u5ff5&#8230;<\/li>\n<\/ol>\n<\/div><\/div>\n\n\n\n<div class=\"wp-block-uagb-container uagb-block-2532d548 alignfull uagb-is-root-container\"><div class=\"uagb-container-inner-blocks-wrap\">\n<div class=\"wp-block-uagb-container uagb-block-238cffc8\">\n<div class=\"wp-block-uagb-container uagb-block-6687656e\">\n<div class=\"wp-block-uagb-advanced-heading uagb-block-37b326f4\"><h3 class=\"uagb-heading-text\"><span class=\"ez-toc-section\" id=\"%F0%9F%93%9D%E6%9F%A5%E8%A9%A2%E5%87%BD%E6%95%B8\"><\/span>\ud83d\udcdd\u67e5\u8a62\u51fd\u6578<span class=\"ez-toc-section-end\"><\/span><\/h3><\/div>\n\n\n\n<p class=\"wp-block-paragraph\"><a href=\"https:\/\/yuanstore.tw\/e-learning\/wp-content\/uploads\/2026\/04\/Excel\u67e5\u8a62\u51fd\u6578.pdf\" data-type=\"attachment\" data-id=\"1508\" target=\"_blank\" rel=\"noreferrer noopener\">\u53c3\u8003\u8b1b\u7fa9<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u7bc4\u4f8b\uff1a<a href=\"https:\/\/yuanstore.tw\/e-learning\/wp-content\/uploads\/2026\/04\/\u51fa\u8ca8\u8a18\u9304.xlsx\" data-type=\"attachment\" data-id=\"1510\">\u4e0b\u8f09<\/a><\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-uagb-container uagb-block-d2db4a2f\">\n<div class=\"wp-block-uagb-advanced-heading uagb-block-cf216876\"><h3 class=\"uagb-heading-text\"><span class=\"ez-toc-section\" id=\"%E6%9F%A5%E8%A9%A2%E7%9A%84%E6%9C%AC%E8%B3%AA\"><\/span>\u67e5\u8a62\u7684\u672c\u8cea<span class=\"ez-toc-section-end\"><\/span><\/h3><\/div>\n\n\n\n<p class=\"wp-block-paragraph\"> Excel \u67e5\u8a62 =\u300c\u7528\u4e00\u500b\u503c\uff0c\u627e\u5230\u53e6\u4e00\u500b\u503c\u300d<\/p>\n\n\n\n<figure class=\"wp-block-table is-style-stripes\"><table class=\"has-fixed-layout\"><tbody><tr><td>\u54e1\u5de5\u7de8\u865f<\/td><td>\u59d3\u540d<\/td><td>\u90e8\u9580<\/td><\/tr><tr><td>A001<\/td><td>\u738b\u5c0f\u660e<\/td><td>\u696d\u52d9\u90e8<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\ud83d\udc49 \u7576\u8f38\u5165 A001 \u2192 \u81ea\u52d5\u5e36\u51fa\u300c\u738b\u5c0f\u660e\u300d<\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-uagb-container uagb-block-d8832890\">\n<div class=\"wp-block-uagb-advanced-heading uagb-block-482b2c70\"><h3 class=\"uagb-heading-text\"><span class=\"ez-toc-section\" id=\"VLOOKUP\"><\/span>VLOOKUP<span class=\"ez-toc-section-end\"><\/span><\/h3><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">\u4f9d\u7167\u7de8\u865f\u67e5\u627e\u5c0d\u61c9\u7684\u8cc7\u6599<\/p>\n\n\n\n<div class=\"wp-block-uagb-image uagb-block-29f1cc8a wp-block-uagb-image--layout-default wp-block-uagb-image--effect-static wp-block-uagb-image--align-none\"><figure class=\"wp-block-uagb-image__figure\"><img decoding=\"async\" src=\"https:\/\/yuanstore.tw\/e-learning\/wp-content\/uploads\/2026\/04\/vlookup-1024x559.png\" alt=\"vlookup\" class=\"uag-image-1519\" width=\"1024\" height=\"559\" title=\"vlookup\" loading=\"lazy\" role=\"img\" \/><\/figure><\/div>\n\n\n\n<div class=\"wp-block-uagb-image uagb-block-dad2438f wp-block-uagb-image--layout-default wp-block-uagb-image--effect-static wp-block-uagb-image--align-none\"><figure class=\"wp-block-uagb-image__figure\"><img decoding=\"async\" src=\"https:\/\/yuanstore.tw\/e-learning\/wp-content\/uploads\/2026\/04\/vlookup-true-2-1024x559.png\" alt=\"vlookup-true\" class=\"uag-image-1691\" width=\"1024\" height=\"559\" title=\"vlookup-true-2\" loading=\"lazy\" role=\"img\" \/><\/figure><\/div>\n\n\n\n<div class=\"wp-block-uagb-advanced-heading uagb-block-5d36580e\"><h4 class=\"uagb-heading-text\"><span class=\"ez-toc-section\" id=\"%E8%AA%9E%E6%B3%95\"><\/span>\u8a9e\u6cd5<span class=\"ez-toc-section-end\"><\/span><\/h4><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">=VLOOKUP(\u67e5\u8a62\u503c, \u7bc4\u570d, \u6b04\u4f4d\u7de8\u865f, \u7cbe\u78ba\/\u8fd1\u4f3c)<\/p>\n\n\n\n<div class=\"wp-block-uagb-advanced-heading uagb-block-5f0080d5\"><h4 class=\"uagb-heading-text\"><span class=\"ez-toc-section\" id=\"%E9%87%8D%E9%BB%9E\"><\/span>\u91cd\u9ede<span class=\"ez-toc-section-end\"><\/span><\/h4><\/div>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u67e5\u8a62\u503c\u4e00\u5b9a\u5728<strong>\u7b2c\u4e00\u6b04<\/strong><\/li>\n\n\n\n<li>FALSE = \u7cbe\u78ba\u6bd4\u5c0d\u3001TRUE=\u6a21\u7cca\u6bd4\u5c0d(\u5148\u6392\u5e8f)<\/li>\n<\/ul>\n\n\n\n<div class=\"wp-block-uagb-image uagb-block-267539ef wp-block-uagb-image--layout-default wp-block-uagb-image--effect-static wp-block-uagb-image--align-none\"><figure class=\"wp-block-uagb-image__figure\"><img decoding=\"async\" src=\"https:\/\/yuanstore.tw\/e-learning\/wp-content\/uploads\/2026\/04\/vlookup-true-1-1024x835.png\" alt=\"\" class=\"uag-image-1690\" width=\"1024\" height=\"835\" title=\"vlookup-true-1\" loading=\"lazy\" role=\"img\" \/><\/figure><\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-uagb-container uagb-block-f3750de3\">\n<div class=\"wp-block-uagb-advanced-heading uagb-block-b480cb96\"><h3 class=\"uagb-heading-text\"><span class=\"ez-toc-section\" id=\"XLOOKUP\"><\/span>XLOOKUP<span class=\"ez-toc-section-end\"><\/span><\/h3><\/div>\n\n\n\n<div class=\"wp-block-uagb-image uagb-block-e4eb065c wp-block-uagb-image--layout-default wp-block-uagb-image--effect-static wp-block-uagb-image--align-none\"><figure class=\"wp-block-uagb-image__figure\"><img decoding=\"async\" src=\"https:\/\/yuanstore.tw\/e-learning\/wp-content\/uploads\/2026\/04\/xlookup\u5716\u89e3-1024x559.png\" alt=\"xlookup\u5716\u89e3\" class=\"uag-image-1526\" width=\"1024\" height=\"559\" title=\"xlookup\u5716\u89e3\" loading=\"lazy\" role=\"img\" \/><\/figure><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">\u7bc4\u4f8b\uff1a<a href=\"https:\/\/yuanstore.tw\/e-learning\/wp-content\/uploads\/2026\/04\/XLOOKUP\u7bc4\u4f8b.xlsx\" data-type=\"attachment\" data-id=\"1525\">\u4e0b\u8f09<\/a><\/p>\n\n\n\n<div class=\"wp-block-uagb-advanced-heading uagb-block-329cc480\"><h4 class=\"uagb-heading-text\"><span class=\"ez-toc-section\" id=\"%E8%AA%9E%E6%B3%95-2\"><\/span>\u8a9e\u6cd5<span class=\"ez-toc-section-end\"><\/span><\/h4><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">=XLOOKUP(\u67e5\u8a62\u503c, \u67e5\u8a62\u7bc4\u570d, \u56de\u50b3\u7bc4\u570d, [\u627e\u4e0d\u5230\u6642], [\u6bd4\u5c0d\u6a21\u5f0f], [\u641c\u5c0b\u6a21\u5f0f])<\/p>\n\n\n\n<div class=\"wp-block-uagb-advanced-heading uagb-block-e41a9d7c\"><h4 class=\"uagb-heading-text\"><span class=\"ez-toc-section\" id=\"%E9%87%8D%E9%BB%9E-2\"><\/span>\u91cd\u9ede<span class=\"ez-toc-section-end\"><\/span><\/h4><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">\u53ef\u8a2d\u5b9a\u627e\u4e0d\u5230\u6642\u986f\u793a\u5167\u5bb9\u8655\u7406\u300c\u4e0d\u898f\u5247\u8cc7\u6599\u300d<strong>\u8207<\/strong>\u300c\u4f8b\u5916\u72c0\u6cc1\u300d<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u53ef\u5411\u5de6\u67e5\uff08VLOOKUP\u505a\u4e0d\u5230\uff09<\/li>\n\n\n\n<li>\u4e0d\u7528\u6578\u6b04\u4f4d<\/li>\n<\/ul>\n\n\n\n<div class=\"wp-block-uagb-advanced-heading uagb-block-af408892\"><h4 class=\"uagb-heading-text\"><span class=\"ez-toc-section\" id=\"%E9%A1%8C%E7%9B%AE\"><\/span>\u984c\u76ee<span class=\"ez-toc-section-end\"><\/span><\/h4><\/div>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u539f\u59cb\u6a94\u6848\uff1a<a href=\"https:\/\/yuanstore.tw\/e-learning\/wp-content\/uploads\/2026\/04\/\u73ed\u7d1a\u5b78\u751f\u6210\u7e3e\u8868.xlsx\" data-type=\"attachment\" data-id=\"1719\">\u4e0b\u8f09<\/a><\/li>\n\n\n\n<li>\u6821\u6392\u540d\u55ae<\/li>\n\n\n\n<li>\u73ed\u6392\u540d\u55ae\uff1a<a href=\"https:\/\/yuanstore.tw\/e-learning\/wp-content\/uploads\/2026\/04\/\u73ed\u7d1a\u5b78\u751f\u6210\u7e3e\u8868-\u53c3\u8003\u7b54\u6848.xlsx\" data-type=\"attachment\" data-id=\"1721\">\u4f7f\u7528index<\/a>\u3001<a href=\"https:\/\/yuanstore.tw\/e-learning\/wp-content\/uploads\/2026\/04\/\u73ed\u7d1a\u5b78\u751f\u6210\u7e3e\u8868-\u6392\u540d.xlsx\" data-type=\"attachment\" data-id=\"1722\">\u4f7f\u7528xlookup<\/a><\/li>\n<\/ul>\n<\/div>\n\n\n\n<div class=\"wp-block-uagb-container uagb-block-369c61c6\">\n<div class=\"wp-block-uagb-advanced-heading uagb-block-5c2adb78\"><h3 class=\"uagb-heading-text\"><span class=\"ez-toc-section\" id=\"INDEX%E3%80%81MATCH\"><\/span>INDEX\u3001MATCH<span class=\"ez-toc-section-end\"><\/span><\/h3><\/div>\n\n\n\n<div class=\"wp-block-uagb-advanced-heading uagb-block-b741739c\"><h4 class=\"uagb-heading-text\"><span class=\"ez-toc-section\" id=\"MATCH%EF%BC%88%E6%89%BE%E4%BD%8D%E7%BD%AE%EF%BC%89\"><\/span>MATCH\uff08\u627e\u4f4d\u7f6e\uff09<span class=\"ez-toc-section-end\"><\/span><\/h4><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">\u50b3\u56de\u8cc7\u6599\u5728\u7279\u5b9a<strong>\u7bc4\u570d<\/strong>\u4e2d\u7684\u4f4d\u7f6e\uff0c\u5728\u7b2c\u5e7e\u5217<strong>\u6216<\/strong>\u7b2c\u5e7e\u6b04<\/p>\n\n\n\n<div class=\"wp-block-uagb-image uagb-block-a57eb759 wp-block-uagb-image--layout-default wp-block-uagb-image--effect-static wp-block-uagb-image--align-none\"><figure class=\"wp-block-uagb-image__figure\"><img decoding=\"async\" src=\"https:\/\/yuanstore.tw\/e-learning\/wp-content\/uploads\/2026\/04\/match\u51fd\u6578-1024x683.png\" alt=\"match\u51fd\u6578\" class=\"uag-image-1538\" width=\"1024\" height=\"683\" title=\"match\u51fd\u6578\" loading=\"lazy\" role=\"img\" \/><\/figure><\/div>\n\n\n\n<div class=\"wp-block-uagb-advanced-heading uagb-block-274df1c6\"><h4 class=\"uagb-heading-text\"><span class=\"ez-toc-section\" id=\"%E8%AA%9E%E6%B3%95-3\"><\/span>\u8a9e\u6cd5<span class=\"ez-toc-section-end\"><\/span><\/h4><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">=MATCH(\u67e5\u627e\u503c, \u67e5\u627e\u7bc4\u570d, \u6bd4\u5c0d\u65b9\u5f0f)<\/p>\n\n\n\n<div class=\"wp-block-uagb-image uagb-block-bccbf81d wp-block-uagb-image--layout-default wp-block-uagb-image--effect-static wp-block-uagb-image--align-none\"><figure class=\"wp-block-uagb-image__figure\"><img decoding=\"async\" src=\"https:\/\/yuanstore.tw\/e-learning\/wp-content\/uploads\/2026\/04\/match\u51fd\u6578\u8aaa\u660e\u61c9\u7528-1024x559.png\" alt=\"match\u51fd\u6578\u8aaa\u660e\u61c9\u7528\" class=\"uag-image-1541\" width=\"1024\" height=\"683\" title=\"match\u51fd\u6578\u8aaa\u660e\u61c9\u7528\" loading=\"lazy\" role=\"img\" \/><\/figure><\/div>\n\n\n\n<div class=\"wp-block-uagb-image uagb-block-aeacbc8b wp-block-uagb-image--layout-default wp-block-uagb-image--effect-static wp-block-uagb-image--align-none\"><figure class=\"wp-block-uagb-image__figure\"><img decoding=\"async\" src=\"https:\/\/yuanstore.tw\/e-learning\/wp-content\/uploads\/2026\/04\/match_type-1024x559.png\" alt=\"match_type\" class=\"uag-image-1553\" width=\"1024\" height=\"683\" title=\"match_type\" loading=\"lazy\" role=\"img\" \/><\/figure><\/div>\n\n\n\n<div class=\"wp-block-uagb-separator uagb-block-066787d7\"><div class=\"wp-block-uagb-separator__inner\" style=\"--my-background-image:\"><\/div><\/div>\n\n\n\n<div class=\"wp-block-uagb-advanced-heading uagb-block-8a412efe\"><h4 class=\"uagb-heading-text\"><span class=\"ez-toc-section\" id=\"INDEX%EF%BC%88%E5%82%B3%E5%9B%9E%E8%B3%87%E6%96%99%EF%BC%89\"><\/span>INDEX\uff08\u50b3\u56de\u8cc7\u6599\uff09<span class=\"ez-toc-section-end\"><\/span><\/h4><\/div>\n\n\n\n<div class=\"wp-block-uagb-image uagb-block-0b2c8b88 wp-block-uagb-image--layout-default wp-block-uagb-image--effect-static wp-block-uagb-image--align-none\"><figure class=\"wp-block-uagb-image__figure\"><img decoding=\"async\" src=\"https:\/\/yuanstore.tw\/e-learning\/wp-content\/uploads\/2026\/04\/index\u51fd\u6578-1024x683.png\" alt=\"index\u51fd\u6578\" class=\"uag-image-1544\" width=\"1024\" height=\"683\" title=\"index\u51fd\u6578\" loading=\"lazy\" role=\"img\" \/><\/figure><\/div>\n\n\n\n<div class=\"wp-block-uagb-advanced-heading uagb-block-83961706\"><h4 class=\"uagb-heading-text\"><span class=\"ez-toc-section\" id=\"%E8%AA%9E%E6%B3%95-4\"><\/span>\u8a9e\u6cd5<span class=\"ez-toc-section-end\"><\/span><\/h4><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">=INDEX(\u7bc4\u570d, \u5217\u865f, [\u6b04\u865f])<\/p>\n\n\n\n<div class=\"wp-block-uagb-image uagb-block-be79a079 wp-block-uagb-image--layout-default wp-block-uagb-image--effect-static wp-block-uagb-image--align-none\"><figure class=\"wp-block-uagb-image__figure\"><img decoding=\"async\" src=\"https:\/\/yuanstore.tw\/e-learning\/wp-content\/uploads\/2026\/04\/index\u51fd\u6578\u61c9\u7528-1024x559.png\" alt=\"index\u51fd\u6578\u61c9\u7528\" class=\"uag-image-1545\" width=\"1024\" height=\"683\" title=\"index\u51fd\u6578\u61c9\u7528\" loading=\"lazy\" role=\"img\" \/><\/figure><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">\u7bc4\u4f8b\uff1a<a href=\"https:\/\/yuanstore.tw\/e-learning\/wp-content\/uploads\/2026\/04\/index\u7bc4\u4f8b.xlsx\" data-type=\"attachment\" data-id=\"1548\">\u4e0b\u8f09<\/a><\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-uagb-container uagb-block-432d829e\">\n<div class=\"wp-block-uagb-advanced-heading uagb-block-fdc4b3f0\"><h3 class=\"uagb-heading-text\"><span class=\"ez-toc-section\" id=\"UNIQUE\"><\/span>UNIQUE<span class=\"ez-toc-section-end\"><\/span><\/h3><\/div>\n\n\n\n<div class=\"wp-block-uagb-advanced-heading uagb-block-607a0636\"><h4 class=\"uagb-heading-text\"><span class=\"ez-toc-section\" id=\"%E8%AA%9E%E6%B3%95-5\"><\/span>\u8a9e\u6cd5<span class=\"ez-toc-section-end\"><\/span><\/h4><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">=UNIQUE(array, [by_col], [exactly_once])<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>\u53c3\u6578<\/th><th>\u8aaa\u660e<\/th><\/tr><\/thead><tbody><tr><td>array<\/td><td>\u8981\u8655\u7406\u7684\u7bc4\u570d<\/td><\/tr><tr><td>by_col<\/td><td>TRUE=\u6a6b\u5411\u6bd4\u5c0d\uff0cFALSE=\u76f4\u5411\uff08\u9810\u8a2d\uff09<\/td><\/tr><tr><td>exactly_once<\/td><td>TRUE=\u53ea\u51fa\u73fe\u4e00\u6b21\u7684\u503c<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<div class=\"wp-block-uagb-image uagb-block-05624121 wp-block-uagb-image--layout-default wp-block-uagb-image--effect-static wp-block-uagb-image--align-none\"><figure class=\"wp-block-uagb-image__figure\"><img decoding=\"async\" src=\"https:\/\/yuanstore.tw\/e-learning\/wp-content\/uploads\/2026\/04\/Unique\u51fd\u6578.png\" alt=\"Unique\u51fd\u6578\" class=\"uag-image-1564\" width=\"1408\" height=\"768\" title=\"Unique\u51fd\u6578\" loading=\"lazy\" role=\"img\" \/><\/figure><\/div>\n\n\n\n<div class=\"wp-block-uagb-image uagb-block-5ce22385 wp-block-uagb-image--layout-default wp-block-uagb-image--effect-static wp-block-uagb-image--align-none\"><figure class=\"wp-block-uagb-image__figure\"><img decoding=\"async\" src=\"https:\/\/yuanstore.tw\/e-learning\/wp-content\/uploads\/2026\/04\/Unique\u51fd\u6578\u61c9\u7528.png\" alt=\"Unique\u51fd\u6578\u61c9\u7528\" class=\"uag-image-1563\" width=\"1264\" height=\"842\" title=\"Unique\u51fd\u6578\u61c9\u7528\" loading=\"lazy\" role=\"img\" \/><\/figure><\/div>\n\n\n\n<div class=\"wp-block-uagb-image uagb-block-f56ff0fe wp-block-uagb-image--layout-default wp-block-uagb-image--effect-static wp-block-uagb-image--align-none\"><figure class=\"wp-block-uagb-image__figure\"><img decoding=\"async\" src=\"https:\/\/yuanstore.tw\/e-learning\/wp-content\/uploads\/2026\/04\/Unique\u4e0b\u62c9\u5f0f\u9078\u55ae.png\" alt=\"Unique\u4e0b\u62c9\u5f0f\u9078\u55ae\" class=\"uag-image-1581\" width=\"1264\" height=\"842\" title=\"Unique\u4e0b\u62c9\u5f0f\u9078\u55ae\" loading=\"lazy\" role=\"img\" \/><\/figure><\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-uagb-container uagb-block-d379dbb4\">\n<div class=\"wp-block-uagb-advanced-heading uagb-block-1cc1c4d1\"><h3 class=\"uagb-heading-text\"><span class=\"ez-toc-section\" id=\"FILTER\"><\/span>FILTER<span class=\"ez-toc-section-end\"><\/span><\/h3><\/div>\n\n\n\n<div class=\"wp-block-uagb-advanced-heading uagb-block-3e615562\"><h4 class=\"uagb-heading-text\"><span class=\"ez-toc-section\" id=\"%E8%AA%9E%E6%B3%95-6\"><\/span>\u8a9e\u6cd5<span class=\"ez-toc-section-end\"><\/span><\/h4><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">=FILTER(\u8cc7\u6599\u7bc4\u570d, \u689d\u4ef6, [\u627e\u4e0d\u5230\u6642\u986f\u793a])<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>FILTER \u56de\u50b3\u7684\u662f\u300c\u52d5\u614b\u9663\u5217\uff08Dynamic Array\uff09\u300d<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u7bc4\u4f8b\uff1a<a href=\"https:\/\/yuanstore.tw\/e-learning\/wp-content\/uploads\/2026\/04\/filter\u51fd\u6578\u7bc4\u4f8b.xlsx\" data-type=\"attachment\" data-id=\"1568\">\u4e0b\u8f09<\/a><\/p>\n\n\n\n<div class=\"wp-block-uagb-image uagb-block-8790ad1a wp-block-uagb-image--layout-default wp-block-uagb-image--effect-static wp-block-uagb-image--align-none\"><figure class=\"wp-block-uagb-image__figure\"><img decoding=\"async\" src=\"https:\/\/yuanstore.tw\/e-learning\/wp-content\/uploads\/2026\/04\/filter\u51fd\u6578\u61c9\u7528.png\" alt=\"filter\u51fd\u6578\u61c9\u7528\" class=\"uag-image-1574\" width=\"1264\" height=\"842\" title=\"filter\u51fd\u6578\u61c9\u7528\" loading=\"lazy\" role=\"img\" \/><\/figure><\/div>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u67e5\u8a62\u300c\u53f0\u5317\u8a02\u55ae\u300d=FILTER(A2:K13, E2:E13=&#8221;\u53f0\u5317&#8221;)<\/li>\n\n\n\n<li>\u67e5\u8a62\u300c\u672a\u51fa\u8ca8\u300d=FILTER(A2:K13, K2:K13=&#8221;\u672a\u51fa\u8ca8&#8221;)<\/li>\n\n\n\n<li>\u91d1\u984d\u8a02\u55ae\uff08> 20000\uff09=FILTER(A2:K13, J2:J13>20000)<\/li>\n\n\n\n<li>\u53f0\u5317 + \u672a\u51fa\u8ca8=FILTER(A2:K13, (E2:E13=&#8221;\u53f0\u5317&#8221;)*(K2:K13=&#8221;\u672a\u51fa\u8ca8&#8221;))<\/li>\n\n\n\n<li>\u591a\u689d\u4ef6\u67e5\u8a62\uff08\u696d\u52d9 + \u5730\u5340\uff09=FILTER(A2:K13, (E2:E13=H1)*(D2:D13=H2))<\/li>\n\n\n\n<li>\u696d\u52d9\u500b\u4eba\u696d\u7e3e=FILTER(A2:K13, D2:D13=&#8221;\u738b\u5c0f\u660e&#8221;)<\/li>\n<\/ul>\n<\/div>\n\n\n\n<div class=\"wp-block-uagb-container uagb-block-93fad2d5\">\n<div class=\"wp-block-uagb-advanced-heading uagb-block-704e0bac\"><h3 class=\"uagb-heading-text\"><span class=\"ez-toc-section\" id=\"SORT%E3%80%81SORTBY\"><\/span>SORT\u3001SORTBY<span class=\"ez-toc-section-end\"><\/span><\/h3><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">\u8cc7\u6599\u6392\u5e8f<\/p>\n\n\n\n<div class=\"wp-block-uagb-image uagb-block-a89ea0ac wp-block-uagb-image--layout-default wp-block-uagb-image--effect-static wp-block-uagb-image--align-none\"><figure class=\"wp-block-uagb-image__figure\"><img decoding=\"async\" src=\"https:\/\/yuanstore.tw\/e-learning\/wp-content\/uploads\/2026\/04\/sort\u51fd\u6578\u61c9\u7528.png\" alt=\"sort\u51fd\u6578\u61c9\u7528\" class=\"uag-image-1586\" width=\"1264\" height=\"842\" title=\"sort\u51fd\u6578\u61c9\u7528\" loading=\"lazy\" role=\"img\" \/><\/figure><\/div>\n<\/div>\n<\/div>\n\n\n\n<div class=\"uagb-position__sticky wp-block-uagb-container uagb-block-3c64f7ed\">\n<\/div>\n<\/div><\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u8cc7\u6599\u641c\u5c0b\u3001\u5efa\u7acb\u8cc7\u6599\u5eab\u6982\u5ff5&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_uag_custom_page_level_css":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[7],"tags":[],"class_list":["post-1496","post","type-post","status-publish","format-standard","hentry","category-excel"],"uagb_featured_image_src":{"full":false,"thumbnail":false,"medium":false,"medium_large":false,"large":false,"1536x1536":false,"2048x2048":false},"uagb_author_info":{"display_name":"kungba","author_link":"https:\/\/yuanstore.tw\/e-learning\/author\/kungba\/"},"uagb_comment_info":0,"uagb_excerpt":"\u8cc7\u6599\u641c\u5c0b\u3001\u5efa\u7acb\u8cc7\u6599\u5eab\u6982\u5ff5...","_links":{"self":[{"href":"https:\/\/yuanstore.tw\/e-learning\/wp-json\/wp\/v2\/posts\/1496","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/yuanstore.tw\/e-learning\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/yuanstore.tw\/e-learning\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/yuanstore.tw\/e-learning\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/yuanstore.tw\/e-learning\/wp-json\/wp\/v2\/comments?post=1496"}],"version-history":[{"count":42,"href":"https:\/\/yuanstore.tw\/e-learning\/wp-json\/wp\/v2\/posts\/1496\/revisions"}],"predecessor-version":[{"id":1724,"href":"https:\/\/yuanstore.tw\/e-learning\/wp-json\/wp\/v2\/posts\/1496\/revisions\/1724"}],"wp:attachment":[{"href":"https:\/\/yuanstore.tw\/e-learning\/wp-json\/wp\/v2\/media?parent=1496"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yuanstore.tw\/e-learning\/wp-json\/wp\/v2\/categories?post=1496"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yuanstore.tw\/e-learning\/wp-json\/wp\/v2\/tags?post=1496"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}