{ "version": "https://jsonfeed.org/version/1.1", "user_comment": "This feed allows you to read the posts from this site in any feed reader that supports the JSON Feed format. To add this feed to your reader, copy the following URL -- https://www.6erp.cn/tag/excel%e8%a1%a8%e6%a0%bc%e8%be%b9%e6%a1%86%e9%a2%9c%e8%89%b2%e6%80%8e%e4%b9%88%e6%94%b9/feed/json -- and add it your reader.", "next_url": "https://www.6erp.cn/tag/excel%e8%a1%a8%e6%a0%bc%e8%be%b9%e6%a1%86%e9%a2%9c%e8%89%b2%e6%80%8e%e4%b9%88%e6%94%b9/feed/json?paged=2", "home_page_url": "https://www.6erp.cn/tag/excel%e8%a1%a8%e6%a0%bc%e8%be%b9%e6%a1%86%e9%a2%9c%e8%89%b2%e6%80%8e%e4%b9%88%e6%94%b9", "feed_url": "https://www.6erp.cn/tag/excel%e8%a1%a8%e6%a0%bc%e8%be%b9%e6%a1%86%e9%a2%9c%e8%89%b2%e6%80%8e%e4%b9%88%e6%94%b9/feed/json", "language": "zh-Hans", "title": "excel\u8868\u683c\u8fb9\u6846\u989c\u8272\u600e\u4e48\u6539 – \u901a\u5546\u8f6f\u4ef6", "description": "ERP,MES,\u8fdb\u9500\u5b58,\u529e\u516c\u534f\u4f5c,MoreExcel\u63d2\u4ef6", "icon": "https://www.6erp.cn/wp-content/uploads/2015/02/2014-06-16_1114_afms1.png", "items": [ { "id": "https://www.6erp.cn/?p=78851", "url": "https://www.6erp.cn/article_78851.html", "title": "lookup\u51fd\u6570\u7684\u4f7f\u7528\u65b9\u6cd5\uff1a\u5982\u4f55\u67e5\u627e\u6700\u540e\u4e00\u4e2a\u5339\u914d\u503c\uff1f", "content_html": "\u5982\u4f55\u4f7f\u7528Lookup\u51fd\u6570\u67e5\u627e\u6700\u540e\u4e00\u4e2a\u5339\u914d\u503c\uff1a\u5168\u9762\u7684\u4f7f\u7528\u6307\u5357 \u5728\u6570\u636e\u5904\u7406\u548c\u5206\u6790\u7684\u8fc7\u7a0b\u4e2d\uff0c\u5982\u4f55\u9ad8\u6548\u5730\u67e5\u627e\u6570\u636e\u662f\u4e00\u4e2a […]", "content_text": "\u5982\u4f55\u4f7f\u7528Lookup\u51fd\u6570\u67e5\u627e\u6700\u540e\u4e00\u4e2a\u5339\u914d\u503c\uff1a\u5168\u9762\u7684\u4f7f\u7528\u6307\u5357 \u5728\u6570\u636e\u5904\u7406\u548c\u5206\u6790\u7684\u8fc7\u7a0b\u4e2d\uff0c\u5982\u4f55\u9ad8\u6548\u5730\u67e5\u627e\u6570\u636e\u662f\u4e00\u4e2a […]", "date_published": "2025-07-03T11:43:42+08:00", "date_modified": "2025-07-03T11:43:42+08:00", "authors": [ { "name": "tongshang2023", "url": "https://www.6erp.cn/article_author/tongshang2023", "avatar": "https://gravatar.loli.net/avatar/c21223269de33a21f9fe247e64e9d4fb" } ], "author": { "name": "tongshang2023", "url": "https://www.6erp.cn/article_author/tongshang2023", "avatar": "https://gravatar.loli.net/avatar/c21223269de33a21f9fe247e64e9d4fb" }, "tags": [ "excel\u7ad6\u5217\u600e\u4e48\u6c42\u548c\u4e0d\u4e86", "Excel\u8868\u683c\u5b9a\u4f4d\u5341\u5b57\u5149\u6807", "Excel\u8868\u683c\u653e\u5230word\u4e2d", "Excel\u8868\u683c\u6839\u636e\u6587\u5b57\u81ea\u52a8\u8c03\u6574\u884c\u9ad8", "Excel\u8868\u683c\u7535\u8bdd\u53f7\u7801\u4e2d\u95f4\u9690\u85cf", "Excel\u8868\u683c\u8868\u5934\u6253\u5370\u600e\u4e48\u6bcf\u9875\u90fd\u6709", "excel\u8868\u683c\u8fb9\u6846\u989c\u8272\u600e\u4e48\u6539", "Excel\u8868\u683c\u91cc\u6253\u94a9\u600e\u4e48\u5f04", "Excel\u8868\u683c\u9519\u4f4d\u4e0d\u5bf9\u9f50", "Excel\u8868\u683c\u9996\u884c\u56fa\u5b9a", "Excel\u6a21\u677f" ] }, { "id": "https://www.6erp.cn/?p=78741", "url": "https://www.6erp.cn/article_78741.html", "title": "lookup\u51fd\u6570\u7684\u4f7f\u7528\u65b9\u6cd5\u4e0esumproduct\u505a\u52a0\u6743\u7edf\u8ba1", "content_html": "Excel\u4e2d\u7684Lookup\u51fd\u6570\u4e0eSumproduct\u52a0\u6743\u7edf\u8ba1\u5e94\u7528 \u5728\u6570\u636e\u5206\u6790\u4e0e\u5904\u7406\u9886\u57df\uff0cExcel\u4f5c\u4e3a\u4e00\u79cd\u5f3a\u5927 […]", "content_text": "Excel\u4e2d\u7684Lookup\u51fd\u6570\u4e0eSumproduct\u52a0\u6743\u7edf\u8ba1\u5e94\u7528 \u5728\u6570\u636e\u5206\u6790\u4e0e\u5904\u7406\u9886\u57df\uff0cExcel\u4f5c\u4e3a\u4e00\u79cd\u5f3a\u5927 […]", "date_published": "2025-07-02T09:43:13+08:00", "date_modified": "2025-07-02T09:43:13+08:00", "authors": [ { "name": "tongshang2023", "url": "https://www.6erp.cn/article_author/tongshang2023", "avatar": "https://gravatar.loli.net/avatar/c21223269de33a21f9fe247e64e9d4fb" } ], "author": { "name": "tongshang2023", "url": "https://www.6erp.cn/article_author/tongshang2023", "avatar": "https://gravatar.loli.net/avatar/c21223269de33a21f9fe247e64e9d4fb" }, "tags": [ "Excel\u8868\u683c\u5236\u4f5c\u81ea\u52a8\u8ba1\u7b97\u516c\u5f0f", "Excel\u8868\u683c\u5355\u4f4d\u6362\u7b97\u600e\u4e48\u8bbe\u7f6e", "Excel\u8868\u683c\u5408\u5e76\u5feb\u6377\u952e", "Excel\u8868\u683c\u653e\u5230word\u4e2d", "excel\u8868\u683c\u6bd4\u4f8b\u600e\u4e48\u7b97", "Excel\u8868\u683c\u8ba1\u7b97\u5de5\u9f84", "excel\u8868\u683c\u8fb9\u6846\u989c\u8272\u600e\u4e48\u6539", "\u6253\u5370\u8868\u683c\u4e3a\u4ec0\u4e48\u6ca1\u6709\u8868\u683c\u7ebf", "Excel\u6848\u4f8b" ] }, { "id": "https://www.6erp.cn/?p=78709", "url": "https://www.6erp.cn/article_78709.html", "title": "vlookup\u51fd\u6570\u7684\u4f7f\u7528\u65b9\u6cd5\u5728\u5e74\u5ea6\u6c47\u603b\u8868\u4e2d\u7684\u81ea\u52a8\u586b\u5145\u6280\u5de7", "content_html": "\u5728\u65e5\u5e38\u7684\u5de5\u4f5c\u4e2d\uff0c\u5c24\u5176\u662f\u5728\u8d22\u52a1\u3001\u9500\u552e\u7b49\u6570\u636e\u7ba1\u7406\u9886\u57df\uff0c\u6211\u4eec\u7ecf\u5e38\u9700\u8981\u8fdb\u884c\u6570\u636e\u6c47\u603b\u548c\u5206\u6790\u3002\u4e3a\u4e86\u63d0\u9ad8\u6548\u7387\uff0c\u51cf\u5c11\u4eba\u5de5\u9519\u8bef\uff0c […]", "content_text": "\u5728\u65e5\u5e38\u7684\u5de5\u4f5c\u4e2d\uff0c\u5c24\u5176\u662f\u5728\u8d22\u52a1\u3001\u9500\u552e\u7b49\u6570\u636e\u7ba1\u7406\u9886\u57df\uff0c\u6211\u4eec\u7ecf\u5e38\u9700\u8981\u8fdb\u884c\u6570\u636e\u6c47\u603b\u548c\u5206\u6790\u3002\u4e3a\u4e86\u63d0\u9ad8\u6548\u7387\uff0c\u51cf\u5c11\u4eba\u5de5\u9519\u8bef\uff0c […]", "date_published": "2025-07-01T09:34:47+08:00", "date_modified": "2025-07-01T09:34:47+08:00", "authors": [ { "name": "tongshang2023", "url": "https://www.6erp.cn/article_author/tongshang2023", "avatar": "https://gravatar.loli.net/avatar/c21223269de33a21f9fe247e64e9d4fb" } ], "author": { "name": "tongshang2023", "url": "https://www.6erp.cn/article_author/tongshang2023", "avatar": "https://gravatar.loli.net/avatar/c21223269de33a21f9fe247e64e9d4fb" }, "tags": [ "Excel\u8868\u683ccount\u51fd\u6570", "Excel\u8868\u683c\u52a0\u6846\u7ebf", "Excel\u8868\u683c\u5355\u5143\u683c\u5185\u5bb9\u5408\u5e76", "Excel\u8868\u683c\u6761\u4ef6\u7b5b\u9009", "Excel\u8868\u683c\u6bd4\u5927\u5c0f\u53d6\u503c\u516c\u5f0f", "excel\u8868\u683c\u8fb9\u6846\u989c\u8272\u600e\u4e48\u6539", "Excel\u8868\u683c\u900f\u89c6\u8868\u600e\u4e48\u64cd\u4f5c", "Excel\u8868\u683c\u997c\u56fe\u600e\u4e48\u663e\u793a\u767e\u5206\u6bd4", "Excel\u6a21\u677f" ] }, { "id": "https://www.6erp.cn/?p=78609", "url": "https://www.6erp.cn/article_78609.html", "title": "\u4e0b\u8f7dword\u7535\u8111\u7248\u514d\u8d39\u540e\u5982\u4f55\u8fc1\u79fb\u8d26\u53f7\u4e0e\u6388\u6743\uff1f", "content_html": "\u5982\u4f55\u4e0b\u8f7dWord\u7535\u8111\u7248\u5e76\u8fdb\u884c\u8d26\u53f7\u4e0e\u6388\u6743\u8fc1\u79fb Microsoft Word\u662f\u4e00\u6b3e\u5e7f\u53d7\u6b22\u8fce\u7684\u6587\u5b57\u5904\u7406\u8f6f\u4ef6\uff0c\u5b83\u7684\u7535\u8111 […]", "content_text": "\u5982\u4f55\u4e0b\u8f7dWord\u7535\u8111\u7248\u5e76\u8fdb\u884c\u8d26\u53f7\u4e0e\u6388\u6743\u8fc1\u79fb Microsoft Word\u662f\u4e00\u6b3e\u5e7f\u53d7\u6b22\u8fce\u7684\u6587\u5b57\u5904\u7406\u8f6f\u4ef6\uff0c\u5b83\u7684\u7535\u8111 […]", "date_published": "2025-07-01T09:08:32+08:00", "date_modified": "2025-07-01T09:08:32+08:00", "authors": [ { "name": "tongshang2023", "url": "https://www.6erp.cn/article_author/tongshang2023", "avatar": "https://gravatar.loli.net/avatar/c21223269de33a21f9fe247e64e9d4fb" } ], "author": { "name": "tongshang2023", "url": "https://www.6erp.cn/article_author/tongshang2023", "avatar": "https://gravatar.loli.net/avatar/c21223269de33a21f9fe247e64e9d4fb" }, "tags": [ "excel\u8868\u683c\u5149\u6807\u4e0d\u80fd\u79fb\u52a8", "Excel\u8868\u683c\u5355\u5143\u683c\u5185\u5bb9\u5408\u5e76", "Excel\u8868\u683c\u600e\u4e48\u52a0\u659c\u6760", "Excel\u8868\u683c\u600e\u4e48\u6392\u7248\u6210a4\u7eb8\u5927\u5c0f", "Excel\u8868\u683c\u600e\u4e48\u63d0\u53d6\u6570\u5b57", "excel\u8868\u683c\u6362\u884c\u600e\u4e48\u64cd\u4f5c", "Excel\u8868\u683c\u8ba1\u7b97\u56fa\u5b9a\u5355\u5143\u683c", "excel\u8868\u683c\u8fb9\u6846\u989c\u8272\u600e\u4e48\u6539", "Excel\u6848\u4f8b" ] }, { "id": "https://www.6erp.cn/?p=78499", "url": "https://www.6erp.cn/article_78499.html", "title": "Excel\u51fd\u6570\u56fe\u50cf\u5728\u52a8\u6001\u5806\u79ef\u9762\u79ef\u56fe\u4e2d\u7684\u6848\u4f8b", "content_html": "\u5728\u73b0\u4ee3\u6570\u636e\u5206\u6790\u548c\u53ef\u89c6\u5316\u4e2d\uff0cExcel\u51fd\u6570\u56fe\u50cf\u5728\u52a8\u6001\u5806\u79ef\u9762\u79ef\u56fe\u4e2d\u7684\u5e94\u7528\u6210\u4e3a\u4e86\u4e00\u9879\u91cd\u8981\u5de5\u5177\u3002\u901a\u8fc7\u5229\u7528Excel\u5f3a\u5927 […]", "content_text": "\u5728\u73b0\u4ee3\u6570\u636e\u5206\u6790\u548c\u53ef\u89c6\u5316\u4e2d\uff0cExcel\u51fd\u6570\u56fe\u50cf\u5728\u52a8\u6001\u5806\u79ef\u9762\u79ef\u56fe\u4e2d\u7684\u5e94\u7528\u6210\u4e3a\u4e86\u4e00\u9879\u91cd\u8981\u5de5\u5177\u3002\u901a\u8fc7\u5229\u7528Excel\u5f3a\u5927 […]", "date_published": "2025-06-30T10:28:15+08:00", "date_modified": "2025-06-30T10:28:15+08:00", "authors": [ { "name": "tongshang2023", "url": "https://www.6erp.cn/article_author/tongshang2023", "avatar": "https://gravatar.loli.net/avatar/c21223269de33a21f9fe247e64e9d4fb" } ], "author": { "name": "tongshang2023", "url": "https://www.6erp.cn/article_author/tongshang2023", "avatar": "https://gravatar.loli.net/avatar/c21223269de33a21f9fe247e64e9d4fb" }, "tags": [ "Excel\u8868\u683c\u4e2d\u7684\u6587\u5b57\u600e\u4e48\u6362\u884c", "Excel\u8868\u683c\u4e58\u79ef\u51fd\u6570", "Excel\u8868\u683c\u5408\u5e76\u5355\u5143\u683c\u5feb\u6377\u952e", "Excel\u8868\u683c\u5408\u5e76\u5feb\u6377\u952e", "Excel\u8868\u683c\u5408\u5e76\u7684\u5355\u5143\u683c\u600e\u4e48\u62c6\u5206", "excel\u8868\u683c\u5e95\u7eb9\u5728\u54ea\u91cc\u8bbe\u7f6e", "excel\u8868\u683c\u6253\u4e0d\u5f00\u7684\u89e3\u51b3\u65b9\u6cd5", "excel\u8868\u683c\u8fb9\u6846\u989c\u8272\u600e\u4e48\u6539", "Excel\u8868\u683c\u9009\u62e9\u9879\u600e\u4e48\u505a", "Excel\u6a21\u677f" ] }, { "id": "https://www.6erp.cn/?p=78470", "url": "https://www.6erp.cn/article_78470.html", "title": "\u4e3a\u4ec0\u4e48Excel\u7684COUNTIF\u4e0d\u80fd\u7b5b\u9009\u67d0\u4e9b\u91cd\u590d\u5185\u5bb9\uff1f", "content_html": "\u4e3a\u4ec0\u4e48Excel\u7684COUNTIF\u4e0d\u80fd\u7b5b\u9009\u67d0\u4e9b\u91cd\u590d\u5185\u5bb9\uff1f \u5728\u65e5\u5e38\u5de5\u4f5c\u4e2d\uff0cExcel\u4f5c\u4e3a\u6700\u5e38\u7528\u7684\u6570\u636e\u5904\u7406\u5de5\u5177\u4e4b\u4e00\uff0c […]", "content_text": "\u4e3a\u4ec0\u4e48Excel\u7684COUNTIF\u4e0d\u80fd\u7b5b\u9009\u67d0\u4e9b\u91cd\u590d\u5185\u5bb9\uff1f \u5728\u65e5\u5e38\u5de5\u4f5c\u4e2d\uff0cExcel\u4f5c\u4e3a\u6700\u5e38\u7528\u7684\u6570\u636e\u5904\u7406\u5de5\u5177\u4e4b\u4e00\uff0c […]", "date_published": "2025-06-27T11:08:00+08:00", "date_modified": "2025-06-27T11:08:00+08:00", "authors": [ { "name": "tongshang2023", "url": "https://www.6erp.cn/article_author/tongshang2023", "avatar": "https://gravatar.loli.net/avatar/c21223269de33a21f9fe247e64e9d4fb" } ], "author": { "name": "tongshang2023", "url": "https://www.6erp.cn/article_author/tongshang2023", "avatar": "https://gravatar.loli.net/avatar/c21223269de33a21f9fe247e64e9d4fb" }, "tags": [ "Excel\u8868\u683c\u53ca\u683c\u7387\u516c\u5f0f", "Excel\u8868\u683c\u53d8\u5927\u53d8\u5c0f\u600e\u4e48\u8c03\u6574", "excel\u8868\u683c\u5982\u4f55\u663e\u793a\u516c\u5f0f", "Excel\u8868\u683c\u600e\u4e48\u63d2\u4e00\u884c\u8fdb\u53bb", "Excel\u8868\u683c\u6a2a\u5750\u6807\u600e\u4e48\u81ea\u5b9a\u4e49", "excel\u8868\u683c\u7c07\u72b6\u67f1\u5f62\u56fe\u600e\u4e48\u505a", "Excel\u8868\u683c\u88ab\u4fdd\u62a4", "Excel\u8868\u683c\u8fb9\u6846\u600e\u4e48\u52a0\u9ed1", "excel\u8868\u683c\u8fb9\u6846\u989c\u8272\u600e\u4e48\u6539", "Excel\u8868\u683c\u95f4\u8ddd\u600e\u4e48\u8c03\u6574\u4e00\u81f4\u5feb\u6377\u952e", "\u600e\u6837\u89e3\u9664\u4fdd\u62a4", "Excel\u6848\u4f8b" ] }, { "id": "https://www.6erp.cn/?p=78370", "url": "https://www.6erp.cn/article_78370.html", "title": "\u65b0\u624b\u5165\u95e8\uff1avlookup\u51fd\u6570\u7684\u57fa\u672c\u7528\u6cd5\u8be6\u89e3", "content_html": "VLOOKUP\u51fd\u6570\u7684\u57fa\u672c\u7528\u6cd5\u8be6\u89e3 \u5728\u65e5\u5e38\u5de5\u4f5c\u4e2d\uff0c\u5c24\u5176\u662f\u5728\u6570\u636e\u5206\u6790\u3001\u62a5\u8868\u751f\u6210\u4ee5\u53ca\u5404\u7c7b\u4e1a\u52a1\u6570\u636e\u7ba1\u7406\u8fc7\u7a0b\u4e2d\uff0cExce […]", "content_text": "VLOOKUP\u51fd\u6570\u7684\u57fa\u672c\u7528\u6cd5\u8be6\u89e3 \u5728\u65e5\u5e38\u5de5\u4f5c\u4e2d\uff0c\u5c24\u5176\u662f\u5728\u6570\u636e\u5206\u6790\u3001\u62a5\u8868\u751f\u6210\u4ee5\u53ca\u5404\u7c7b\u4e1a\u52a1\u6570\u636e\u7ba1\u7406\u8fc7\u7a0b\u4e2d\uff0cExce […]", "date_published": "2025-06-27T10:37:54+08:00", "date_modified": "2025-06-27T10:37:54+08:00", "authors": [ { "name": "tongshang2023", "url": "https://www.6erp.cn/article_author/tongshang2023", "avatar": "https://gravatar.loli.net/avatar/c21223269de33a21f9fe247e64e9d4fb" } ], "author": { "name": "tongshang2023", "url": "https://www.6erp.cn/article_author/tongshang2023", "avatar": "https://gravatar.loli.net/avatar/c21223269de33a21f9fe247e64e9d4fb" }, "tags": [ "Excel\u8868\u683c\u4e00\u952e\u7f8e\u5316", "Excel\u8868\u683c\u4e58\u79ef\u516c\u5f0f", "Excel\u8868\u683c\u51fa\u73b0\u6c49\u5b57\u4e71\u7801", "Excel\u8868\u683c\u5206\u9875\u9884\u89c8\u600e\u4e48\u53d6\u6d88", "Excel\u8868\u683c\u540e\u9762\u7684\u7a7a\u767d\u9875\u600e\u4e48\u5220\u9664\u4e0d\u4e86", "Excel\u8868\u683c\u600e\u4e48\u81ea\u52a8\u751f\u6210\u65e5\u671f", "Excel\u8868\u683c\u600e\u4e48\u8c03\u6574\u8868\u683c\u5927\u5c0f", "excel\u8868\u683c\u6362\u884c\u600e\u4e48\u64cd\u4f5c", "Excel\u8868\u683c\u65e5\u671f\u52a0\u51cf\u81ea\u52a8\u8ba1\u7b97", "excel\u8868\u683c\u8fb9\u6846\u989c\u8272\u600e\u4e48\u6539", "Excel\u6848\u4f8b" ] }, { "id": "https://www.6erp.cn/?p=78320", "url": "https://www.6erp.cn/article_78320.html", "title": "\u201c\u8868\u683c\u5236\u4f5cExcel\u201d\u5982\u4f55\u7528\u5b8f\u6279\u91cf\u6253\u5370\u8868\u683c\uff1f", "content_html": "\u5982\u4f55\u7528\u5b8f\u6279\u91cf\u6253\u5370Excel\u8868\u683c \u5728\u5de5\u4f5c\u4e2d\uff0c\u6211\u4eec\u7ecf\u5e38\u9700\u8981\u5904\u7406\u5927\u91cf\u7684\u8868\u683c\u6570\u636e\uff0c\u5c24\u5176\u662f\u5728\u5236\u4f5c\u62a5\u8868\u6216\u5904\u7406\u4fe1\u606f\u65f6\uff0c\u6709\u65f6\u9700 […]", "content_text": "\u5982\u4f55\u7528\u5b8f\u6279\u91cf\u6253\u5370Excel\u8868\u683c \u5728\u5de5\u4f5c\u4e2d\uff0c\u6211\u4eec\u7ecf\u5e38\u9700\u8981\u5904\u7406\u5927\u91cf\u7684\u8868\u683c\u6570\u636e\uff0c\u5c24\u5176\u662f\u5728\u5236\u4f5c\u62a5\u8868\u6216\u5904\u7406\u4fe1\u606f\u65f6\uff0c\u6709\u65f6\u9700 […]", "date_published": "2025-06-26T10:54:25+08:00", "date_modified": "2025-06-26T10:54:25+08:00", "authors": [ { "name": "tongshang2023", "url": "https://www.6erp.cn/article_author/tongshang2023", "avatar": "https://gravatar.loli.net/avatar/c21223269de33a21f9fe247e64e9d4fb" } ], "author": { "name": "tongshang2023", "url": "https://www.6erp.cn/article_author/tongshang2023", "avatar": "https://gravatar.loli.net/avatar/c21223269de33a21f9fe247e64e9d4fb" }, "tags": [ "Excel\u8868\u683ccountif\u51fd\u6570\u5e94\u7528", "Excel\u8868\u683crank\u51fd\u6570", "excel\u8868\u683c\u4f4e\u4e8e\u6570\u503c\u81ea\u52a8\u53d8\u7ea2", "Excel\u8868\u683c\u5927\u5c0f\u600e\u4e48\u8c03\u6574", "Excel\u8868\u683c\u5bf9\u53f7\u600e\u4e48\u8f93\u5165", "Excel\u8868\u683c\u5e38\u7528\u6280\u5de7\u5927\u5168", "excel\u8868\u683c\u8fb9\u6846\u989c\u8272\u600e\u4e48\u6539", "Excel\u8868\u683c\u9694\u884c\u63d2\u4e00\u884c", "Excel\u6a21\u677f" ] }, { "id": "https://www.6erp.cn/?p=78206", "url": "https://www.6erp.cn/article_78206.html", "title": "\u7528 SUBTOTAL \u5b9e\u73b0 Excel\u6c42\u548c \u7684\u9694\u884c\u8fc7\u6ee4", "content_html": "\u4ec0\u4e48\u662fSUBTOTAL\u51fd\u6570\u53ca\u5176\u5728Excel\u6c42\u548c\u4e2d\u7684\u5e94\u7528 \u5728Excel\u6570\u636e\u5904\u7406\u4e2d\uff0c\u6c42\u548c\u662f\u6700\u5e38\u89c1\u7684\u64cd\u4f5c\u4e4b\u4e00\uff0c\u800cSU […]", "content_text": "\u4ec0\u4e48\u662fSUBTOTAL\u51fd\u6570\u53ca\u5176\u5728Excel\u6c42\u548c\u4e2d\u7684\u5e94\u7528 \u5728Excel\u6570\u636e\u5904\u7406\u4e2d\uff0c\u6c42\u548c\u662f\u6700\u5e38\u89c1\u7684\u64cd\u4f5c\u4e4b\u4e00\uff0c\u800cSU […]", "date_published": "2025-06-25T08:24:22+08:00", "date_modified": "2025-06-25T08:24:22+08:00", "authors": [ { "name": "tongshang2023", "url": "https://www.6erp.cn/article_author/tongshang2023", "avatar": "https://gravatar.loli.net/avatar/c21223269de33a21f9fe247e64e9d4fb" } ], "author": { "name": "tongshang2023", "url": "https://www.6erp.cn/article_author/tongshang2023", "avatar": "https://gravatar.loli.net/avatar/c21223269de33a21f9fe247e64e9d4fb" }, "tags": [ "cad\u7684\u8868\u683c\u5982\u4f55\u5bfc\u51faexcel", "Excel\u8868\u683c\u4e2d\u4e24\u5217\u5185\u5bb9\u5408\u5e76\u5230\u4e00\u8d77", "Excel\u8868\u683c\u5206\u5272\u7ebf\u4e00\u5206\u4e3a\u4e8c", "Excel\u8868\u683c\u5927\u5c0f\u5199\u600e\u4e48\u8f6c\u6362", "Excel\u8868\u683c\u600e\u4e48\u52a0\u5bc6", "excel\u8868\u683c\u6570\u636e\u600e\u4e48\u751f\u6210\u6298\u7ebf\u56fe", "Excel\u8868\u683c\u767e\u5206\u6bd4\u8fdb\u5ea6\u6761", "Excel\u8868\u683c\u7b97\u4e58\u6cd5", "excel\u8868\u683c\u8fb9\u6846\u989c\u8272\u600e\u4e48\u6539", "Excel\u8868\u683c\u9694\u884c\u63d2\u4e00\u884c", "Excel\u6848\u4f8b" ] }, { "id": "https://www.6erp.cn/?p=78120", "url": "https://www.6erp.cn/article_78120.html", "title": "xlookup\u51fd\u6570\u7684\u4f7f\u7528\u65b9\u6cd5\u5728\u5e93\u5b58\u7ba1\u7406\u8868\u4e2d\u7684\u5b9e\u6218\u6f14\u7ec3", "content_html": "\u6807\u9898\uff1a\u5229\u7528XLOOKUP\u51fd\u6570\u63d0\u5347\u5e93\u5b58\u7ba1\u7406\u6548\u7387\uff1a\u4ece\u57fa\u7840\u5230\u5b9e\u6218\u5e94\u7528 \u5e93\u5b58\u7ba1\u7406\u662f\u4f01\u4e1a\u8fd0\u8425\u4e2d\u81f3\u5173\u91cd\u8981\u7684\u4e00\u73af\uff0c\u800c\u501f\u52a9Ex […]", "content_text": "\u6807\u9898\uff1a\u5229\u7528XLOOKUP\u51fd\u6570\u63d0\u5347\u5e93\u5b58\u7ba1\u7406\u6548\u7387\uff1a\u4ece\u57fa\u7840\u5230\u5b9e\u6218\u5e94\u7528 \u5e93\u5b58\u7ba1\u7406\u662f\u4f01\u4e1a\u8fd0\u8425\u4e2d\u81f3\u5173\u91cd\u8981\u7684\u4e00\u73af\uff0c\u800c\u501f\u52a9Ex […]", "date_published": "2025-06-24T09:01:34+08:00", "date_modified": "2025-06-24T09:01:34+08:00", "authors": [ { "name": "tongshang2023", "url": "https://www.6erp.cn/article_author/tongshang2023", "avatar": "https://gravatar.loli.net/avatar/c21223269de33a21f9fe247e64e9d4fb" } ], "author": { "name": "tongshang2023", "url": "https://www.6erp.cn/article_author/tongshang2023", "avatar": "https://gravatar.loli.net/avatar/c21223269de33a21f9fe247e64e9d4fb" }, "tags": [ "Excel\u8868\u683c\u51fd\u6570\u600e\u4e48\u53d8\u6210\u6570\u5b57", "Excel\u8868\u683c\u53d8\u5927\u53d8\u5c0f\u600e\u4e48\u8c03\u6574", "Excel\u8868\u683c\u600e\u4e48\u52a0\u4e00\u884c", "excel\u8868\u683c\u65e5\u671f\u81ea\u52a8\u987a\u5e8f\u6392\u5217", "Excel\u8868\u683c\u7684\u5236\u4f5c\u6559\u7a0b", "Excel\u8868\u683c\u8001\u662f\u4e0d\u505c\u7684\u5f80\u53f3\u79fb", "excel\u8868\u683c\u8fb9\u6846\u989c\u8272\u600e\u4e48\u6539", "Excel\u8868\u683c\u9664\u53f7\u600e\u4e48\u8f93\u5165", "Excel\u6a21\u677f" ] }, { "id": "https://www.6erp.cn/?p=78052", "url": "https://www.6erp.cn/article_78052.html", "title": "\u5982\u4f55\u5b89\u88c5Excel \u7535\u8111\u7248\u5e76\u8fdb\u884c\u6fc0\u6d3b\uff1f", "content_html": "\u5982\u4f55\u5b89\u88c5Excel \u7535\u8111\u7248\u5e76\u8fdb\u884c\u6fc0\u6d3b\uff1f \u5fae\u8f6fExcel\u662f\u4e00\u6b3e\u5e7f\u6cdb\u5e94\u7528\u4e8e\u6570\u636e\u5206\u6790\u3001\u8868\u683c\u5904\u7406\u548c\u8d22\u52a1\u7ba1\u7406\u7684\u529e\u516c\u8f6f\u4ef6\u3002 […]", "content_text": "\u5982\u4f55\u5b89\u88c5Excel \u7535\u8111\u7248\u5e76\u8fdb\u884c\u6fc0\u6d3b\uff1f \u5fae\u8f6fExcel\u662f\u4e00\u6b3e\u5e7f\u6cdb\u5e94\u7528\u4e8e\u6570\u636e\u5206\u6790\u3001\u8868\u683c\u5904\u7406\u548c\u8d22\u52a1\u7ba1\u7406\u7684\u529e\u516c\u8f6f\u4ef6\u3002 […]", "date_published": "2025-06-24T08:42:22+08:00", "date_modified": "2025-06-24T08:42:22+08:00", "authors": [ { "name": "tongshang2023", "url": "https://www.6erp.cn/article_author/tongshang2023", "avatar": "https://gravatar.loli.net/avatar/c21223269de33a21f9fe247e64e9d4fb" } ], "author": { "name": "tongshang2023", "url": "https://www.6erp.cn/article_author/tongshang2023", "avatar": "https://gravatar.loli.net/avatar/c21223269de33a21f9fe247e64e9d4fb" }, "tags": [ "Excel\u8868\u683c\u4e2d\u4e24\u5217\u5185\u5bb9\u5408\u5e76\u5230\u4e00\u8d77", "Excel\u8868\u683c\u5bf9\u6570\u51fd\u6570", "Excel\u8868\u683c\u600e\u4e48\u63d0\u53d6\u6570\u5b57", "Excel\u8868\u683c\u6846\u7ebf\u7c97\u7ec6\u600e\u4e48\u8bbe\u7f6e", "Excel\u8868\u683c\u767e\u5206\u6bd4\u8fdb\u5ea6\u6761", "Excel\u8868\u683c\u884c\u95f4\u8ddd", "Excel\u8868\u683c\u884c\u95f4\u8ddd\u600e\u4e48\u8c03", "Excel\u8868\u683c\u8c03\u6574\u8868\u683c\u5927\u5c0f", "excel\u8868\u683c\u8fb9\u6846\u989c\u8272\u600e\u4e48\u6539", "Excel\u8868\u683c\u91cc\u6253\u94a9\u600e\u4e48\u5f04", "Excel\u6a21\u677f" ] }, { "id": "https://www.6erp.cn/?p=77990", "url": "https://www.6erp.cn/article_77990.html", "title": "\u5982\u4f55\u7ed3\u5408IFERROR\u4f18\u5316xlookup\u51fd\u6570\u7684\u4f7f\u7528\u65b9\u6cd5\uff1f", "content_html": "\u5982\u4f55\u7ed3\u5408IFERROR\u4f18\u5316XLOOKUP\u51fd\u6570\u7684\u4f7f\u7528\u65b9\u6cd5 XLOOKUP\u51fd\u6570\u662fExcel\u4e2d\u4e00\u9879\u975e\u5e38\u5f3a\u5927\u7684\u67e5\u627e\u5de5\u5177 […]", "content_text": "\u5982\u4f55\u7ed3\u5408IFERROR\u4f18\u5316XLOOKUP\u51fd\u6570\u7684\u4f7f\u7528\u65b9\u6cd5 XLOOKUP\u51fd\u6570\u662fExcel\u4e2d\u4e00\u9879\u975e\u5e38\u5f3a\u5927\u7684\u67e5\u627e\u5de5\u5177 […]", "date_published": "2025-06-23T09:22:13+08:00", "date_modified": "2025-06-23T09:22:13+08:00", "authors": [ { "name": "tongshang2023", "url": "https://www.6erp.cn/article_author/tongshang2023", "avatar": "https://gravatar.loli.net/avatar/c21223269de33a21f9fe247e64e9d4fb" } ], "author": { "name": "tongshang2023", "url": "https://www.6erp.cn/article_author/tongshang2023", "avatar": "https://gravatar.loli.net/avatar/c21223269de33a21f9fe247e64e9d4fb" }, "tags": [ "1\u4e002\u4e00201\u5728\u8868\u683c\u600e\u4e48\u8f93\u5165", "ecxel\u8868\u683c\u600e\u4e48\u5408\u5e76", "Excel\u8868\u683c\u5355\u5143\u683c\u9501\u5b9a\u600e\u4e48\u89e3\u9501", "Excel\u8868\u683c\u5355\u5217\u5168\u9009\u5feb\u6377\u952e", "Excel\u8868\u683c\u5e95\u90e8\u7684\u6a2a\u7ebf\u600e\u4e48\u6253", "Excel\u8868\u683c\u600e\u4e48\u8bbe\u7f6e\u884c\u95f4\u8ddd", "Excel\u8868\u683c\u67e5\u91cd\u5e76\u7b5b\u9009\u51fa\u6765", "Excel\u8868\u683c\u88ab\u4fdd\u62a4", "excel\u8868\u683c\u8fb9\u6846\u989c\u8272\u600e\u4e48\u6539", "Excel\u8868\u683c\u91cc\u9762\u7684\u6570\u5b57\u5982\u4f55\u663e\u793a\u5168\u90e8", "\u600e\u6837\u89e3\u9664\u4fdd\u62a4", "Excel\u6848\u4f8b" ] } ] }