{"id":3203,"date":"2024-10-30T16:27:44","date_gmt":"2024-10-30T08:27:44","guid":{"rendered":"https:\/\/www.fyndpro.com\/?p=3203"},"modified":"2024-11-20T15:26:36","modified_gmt":"2024-11-20T07:26:36","slug":"32-new-excel-functions-and-examples","status":"publish","type":"post","link":"https:\/\/www.fyndpro.com\/cn\/32-new-excel-functions-and-examples\/","title":{"rendered":"32\u500b\u65b0Excel\u51fd\u6578\u7528\u6cd5\u53ca\u793a\u4f8b\uff08\u6309\u5be6\u7528\u6027\u6392\u5e8f\uff09"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">\u5728\u6578\u64da\u9a45\u52d5\u7684\u6642\u4ee3\uff0cExcel \u5df2\u6210\u70ba\u6578\u64da\u5206\u6790\u548c\u7ba1\u7406\u7684\u91cd\u8981\u5de5\u5177\u3002\u672c\u6587\u5c07\u6df1\u5165\u4ecb\u7d39 32 \u500b\u5168\u65b0\u7684 Excel \u51fd\u6578\u53ca\u5176\u5be6\u7528\u793a\u4f8b\uff0c\u9019\u4e9b\u65b0Excel\u51fd\u6578\u6db5\u84cb\u6578\u64da\u91cd\u7d44\u3001\u904e\u6ffe\u3001\u6587\u672c\u8655\u7406\u548c\u81ea\u5b9a\u7fa9\u8a08\u7b97\u7b49\u591a\u500b\u65b9\u9762\uff0c\u5e6b\u52a9\u7528\u6236\u63d0\u9ad8\u5de5\u4f5c\u6548\u7387\u548c\u6578\u64da\u8655\u7406\u7684\u6e96\u78ba\u6027\u3002\u7121\u8ad6\u4f60\u662f\u5c08\u696d\u5206\u6790\u5e2b\u9084\u662f\u65e5\u5e38\u7528\u6236\uff0c\u9019\u4e9b\u65b0Excel\u51fd\u6578\u90fd\u5c07\u52a9\u4f60\u66f4\u9748\u6d3b\u5730\u64cd\u4f5c\u6578\u64da\uff0c\u5145\u5206\u767c\u63ee Excel \u7684\u6f5b\u529b\uff0c\u8b93\u6578\u64da\u5206\u6790\u8b8a\u5f97\u66f4\u7c21\u55ae\u3001\u66f4\u9ad8\u6548\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u7b2c1\u540d\uff1aPivotby\u51fd\u6578<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u529f\u80fd<\/strong>\uff1a\u7528\u516c\u5f0f\u5be6\u73fe\u6578\u64da\u900f\u8996\uff0c\u652f\u6301\u591a\u5217\u591a\u8868\u6839\u64da\u57ce\u5e02\uff08A\u5217\uff09\u548c\u7522\u54c1\uff08B\u5217\uff09\u900f\u8996\u92b7\u91cf\uff08C\u5217\uff09<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u793a\u4f8b<\/strong>\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code><code>=pivotby(A1:A10,B1:B10,C1:C10,Sum,3)<\/code><\/code><\/pre>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><th>A\u5217<\/th><th>B\u5217<\/th><th>C\u5217<\/th><\/tr><tr><td>\u57ce\u5e02<\/td><td>\u7522\u54c1<\/td><td>\u92b7\u91cf<\/td><\/tr><tr><td>\u5317\u4eac<\/td><td>A<\/td><td>100<\/td><\/tr><tr><td>\u5317\u4eac<\/td><td>B<\/td><td>150<\/td><\/tr><tr><td>\u4e0a\u6d77<\/td><td>A<\/td><td>200<\/td><\/tr><tr><td>\u4e0a\u6d77<\/td><td>B<\/td><td>250<\/td><\/tr><tr><td>\u5317\u4eac<\/td><td>A<\/td><td>300<\/td><\/tr><tr><td>\u4e0a\u6d77<\/td><td>B<\/td><td>400<\/td><\/tr><tr><td>\u4e0a\u6d77<\/td><td>A<\/td><td>50<\/td><\/tr><tr><td>\u5317\u4eac<\/td><td>B<\/td><td>80<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u7d50\u679c<\/strong>\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><th>\u57ce\u5e02<\/th><th>\u7522\u54c1<\/th><th>\u92b7\u91cf<\/th><\/tr><tr><td>\u5317\u4eac<\/td><td>A<\/td><td>400<\/td><\/tr><tr><td>\u5317\u4eac<\/td><td>B<\/td><td>230<\/td><\/tr><tr><td>\u4e0a\u6d77<\/td><td>A<\/td><td>250<\/td><\/tr><tr><td>\u4e0a\u6d77<\/td><td>B<\/td><td>650<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u7b2c2\u540d\uff1aGroupby\u51fd\u6578<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u529f\u80fd<\/strong>\uff1a\u7528\u516c\u5f0f\u5206\u985e\u532f\u7e3d\uff0c\u652f\u6301\u591a\u5217\u591a\u8868\u6839\u64da\u57ce\u5e02\uff08A\u5217\uff09\u548c\u7522\u54c1\uff08B\u5217\uff09\u532f\u7e3d\u92b7\u91cf\uff08C\u5217\uff09<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u793a\u4f8b<\/strong>\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code><code>=Groupby(A1:B10,C1:C10,Sum,3)<\/code><\/code><\/pre>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><th>A\u5217<\/th><th>B\u5217<\/th><th>C\u5217<\/th><\/tr><tr><td>\u57ce\u5e02<\/td><td>\u7522\u54c1<\/td><td>\u92b7\u91cf<\/td><\/tr><tr><td>\u5317\u4eac<\/td><td>A<\/td><td>100<\/td><\/tr><tr><td>\u5317\u4eac<\/td><td>B<\/td><td>150<\/td><\/tr><tr><td>\u4e0a\u6d77<\/td><td>A<\/td><td>200<\/td><\/tr><tr><td>\u4e0a\u6d77<\/td><td>B<\/td><td>250<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u7d50\u679c<\/strong>\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><th>\u57ce\u5e02<\/th><th>\u7522\u54c1<\/th><th>\u92b7\u91cf<\/th><\/tr><tr><td>\u5317\u4eac<\/td><td>A<\/td><td>400<\/td><\/tr><tr><td>\u5317\u4eac<\/td><td>B<\/td><td>230<\/td><\/tr><tr><td>\u4e0a\u6d77<\/td><td>A<\/td><td>250<\/td><\/tr><tr><td>\u4e0a\u6d77<\/td><td>B<\/td><td>650<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u7b2c3\u540d\uff1aRegexextract\u51fd\u6578<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u529f\u80fd<\/strong>\uff1a\u7528\u6b63\u5247\u8868\u9054\u5f0f\u63d0\u53d6\u5b57\u7b26\u4e2d\u7684\u6240\u6709\u6574\u6578<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u793a\u4f8b<\/strong>\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code><code>=Regexextract(A1,\"\\d+\")<\/code><\/code><\/pre>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><th>A\u5217<\/th><\/tr><tr><td>\u5167\u5bb9<\/td><\/tr><tr><td>\u6211\u7684\u96fb\u8a71\u662f1234567890<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u7d50\u679c<\/strong>\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><th>\u63d0\u53d6\u7684\u6574\u6578<\/th><\/tr><tr><td>1234567890<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u7b2c4\u540d\uff1aFilter\u51fd\u6578<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u529f\u80fd<\/strong>\uff1a\u4e00\u5c0d\u591a\u7be9\u9078\uff0c\u7be9\u9078\u8ca1\u52d9\u90e8\uff08A\u5217\uff09\u6240\u6709\u884c<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u793a\u4f8b<\/strong>\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code><code>=Filter(A1:F100,A1:A100=\"\u8ca1\u52d9\")<\/code><\/code><\/pre>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><th>A\u5217<\/th><th>B\u5217<\/th><th>C\u5217<\/th><th>D\u5217<\/th><th>E\u5217<\/th><th>F\u5217<\/th><\/tr><tr><td>\u90e8\u9580<\/td><td>\u59d3\u540d<\/td><td>\u8077\u4f4d<\/td><td>\u85aa\u6c34<\/td><td>\u5e74\u9f61<\/td><td>\u5730\u5340<\/td><\/tr><tr><td>\u8ca1\u52d9<\/td><td>\u5f35\u4e09<\/td><td>\u7d93\u7406<\/td><td>8000<\/td><td>35<\/td><td>\u5317\u4eac<\/td><\/tr><tr><td>\u4eba\u4e8b<\/td><td>\u674e\u56db<\/td><td>\u5c08\u54e1<\/td><td>5000<\/td><td>28<\/td><td>\u4e0a\u6d77<\/td><\/tr><tr><td>\u8ca1\u52d9<\/td><td>\u738b\u4e94<\/td><td>\u52a9\u7406<\/td><td>6000<\/td><td>30<\/td><td>\u5ee3\u5dde<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u7d50\u679c<\/strong>\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><th>\u90e8\u9580<\/th><th>\u59d3\u540d<\/th><th>\u8077\u4f4d<\/th><th>\u85aa\u6c34<\/th><th>\u5e74\u9f61<\/th><th>\u5730\u5340<\/th><\/tr><tr><td>\u8ca1\u52d9<\/td><td>\u5f35\u4e09<\/td><td>\u7d93\u7406<\/td><td>8000<\/td><td>35<\/td><td>\u5317\u4eac<\/td><\/tr><tr><td>\u8ca1\u52d9<\/td><td>\u738b\u4e94<\/td><td>\u52a9\u7406<\/td><td>6000<\/td><td>30<\/td><td>\u5ee3\u5dde<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u7b2c5\u540d\uff1aVstack\u51fd\u6578<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u529f\u80fd<\/strong>\uff1a\u5408\u4f75\u591a\u500b\u8868\u683c\uff0c\u5408\u4f751~12\u6708\u8868\u683c<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u793a\u4f8b<\/strong>\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code><code>=Vstack('1\u6708:12\u6708'!A1:B100)<\/code><\/code><\/pre>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><th>A\u5217<\/th><th>B\u5217<\/th><\/tr><tr><td>\u6708\u4efd<\/td><td>\u92b7\u91cf<\/td><\/tr><tr><td>1\u6708<\/td><td>1000<\/td><\/tr><tr><td>2\u6708<\/td><td>1500<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u7d50\u679c<\/strong>\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><th>\u6708\u4efd<\/th><th>\u92b7\u91cf<\/th><\/tr><tr><td>1\u6708<\/td><td>1000<\/td><\/tr><tr><td>2\u6708<\/td><td>1500<\/td><\/tr><tr><td>3\u6708<\/td><td>1800<\/td><\/tr><tr><td>4\u6708<\/td><td>2000<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u7b2c6\u540d\uff1aXlookup\u51fd\u6578<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u529f\u80fd<\/strong>\uff1a\u591a\u689d\u4ef6\u67e5\u627e\u3001\u5f9e\u5f8c\u5411\u524d\u67e5\u627e\uff0c\u6839\u64da\u90e8\u9580\uff08A\u5217\uff09\u548c\u59d3\u540d\uff08B\u5217\uff09\u67e5\u8a62\u5b78\u6b77\uff08D\u5217\uff09<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u793a\u4f8b<\/strong>\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code><code>=Xlookup(\"\u8ca1\u52d9\u90e8\"&amp;\"\u5f35\u4e09\",A1:A10&amp;B1:B10,D1:D10)<\/code><\/code><\/pre>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><th>A\u5217<\/th><th>B\u5217<\/th><th>D\u5217<\/th><\/tr><tr><td>\u90e8\u9580<\/td><td>\u59d3\u540d<\/td><td>\u5b78\u6b77<\/td><\/tr><tr><td>\u8ca1\u52d9\u90e8<\/td><td>\u5f35\u4e09<\/td><td>\u78a9\u58eb<\/td><\/tr><tr><td>\u4eba\u4e8b\u90e8<\/td><td>\u674e\u56db<\/td><td>\u5b78\u58eb<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u7d50\u679c<\/strong>\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><th>\u5b78\u6b77<\/th><\/tr><tr><td>\u78a9\u58eb<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u7b2c7\u540d\uff1aTextjoin\u51fd\u6578<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u529f\u80fd<\/strong>\uff1a\u7528\u5206\u9694\u7b26\u9023\u63a5\u591a\u500b\u503c\uff0c\u628aA1:A10\u7684\u503c\u7528-\u9023\u63a5\u5728\u4e00\u8d77<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u793a\u4f8b<\/strong>\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code><code>=Textjoin(\"-\",,A1:A10)<\/code><\/code><\/pre>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><th>A\u5217<\/th><\/tr><tr><td>\u503c<\/td><\/tr><tr><td>\u4e00<\/td><\/tr><tr><td>\u4e8c<\/td><\/tr><tr><td>\u4e09<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u7d50\u679c<\/strong>\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><th>\u9023\u63a5\u7d50\u679c<\/th><\/tr><tr><td>\u4e00-\u4e8c-\u4e09<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u7b2c8\u540d\uff1aTextsplit\u51fd\u6578<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u529f\u80fd<\/strong>\uff1a\u6839\u64da\u5206\u9694\u7b26\u628a\u4e00\u500b\u5b57\u7b26\u4e32\u62c6\u5206\u6210\u591a\u500b\u503c\uff0c\u628aA1\u55ae\u5143\u683c\u4e2d\u201c\u5f35\u4e09-\u7537-20\u201d\u62c6\u5206\u52303\u500b\u55ae\u5143\u683c\u4e2d<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u793a\u4f8b<\/strong>\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code><code>=Textsplit(A1,\"-\")<\/code><\/code><\/pre>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><th>A\u5217<\/th><\/tr><tr><td>\u5167\u5bb9<\/td><\/tr><tr><td>\u5f35\u4e09-\u7537-20<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u7d50\u679c<\/strong>\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><th>\u59d3\u540d<\/th><th>\u6027\u5225<\/th><th>\u5e74\u9f61<\/th><\/tr><tr><td>\u5f35\u4e09<\/td><td>\u7537<\/td><td>20<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u7b2c9\u540d\uff1aTextbefore\u51fd\u6578<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u529f\u80fd<\/strong>\uff1a\u63d0\u53d6\u67d0\u500b\u5b57\u7b26\u524d\u7684\u5167\u5bb9\uff0c\u63d0\u53d6\u7701\u4e4b\u524d\u7684\u7701\u4efd\u540d\u7a31<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u793a\u4f8b<\/strong>\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code><code>=Textbefore(A1,\"\u7701\")<\/code><\/code><\/pre>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><th>A\u5217<\/th><\/tr><tr><td>\u5167\u5bb9<\/td><\/tr><tr><td>\u5ee3\u6771\u7701<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u7d50\u679c<\/strong>\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><th>\u7701\u4efd<\/th><\/tr><tr><td>\u5ee3\u6771<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u7b2c10\u540d\uff1aTextafter\u51fd\u6578<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u529f\u80fd<\/strong>\uff1a\u63d0\u53d6\u67d0\u500b\u5b57\u7b26\u5f8c\u7684\u5167\u5bb9\uff0c\u63d0\u53d6\u5e02\u7684\u8a73\u7d30\u5730\u5740<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u793a\u4f8b<\/strong>\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code><code>=Textafter(A1,\"\u5e02\")<\/code><\/code><\/pre>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><th>A\u5217<\/th><\/tr><tr><td>\u5167\u5bb9<\/td><\/tr><tr><td>\u5ee3\u5dde\u5e02\u5929\u6cb3\u5340<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u7d50\u679c<\/strong>\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><th>\u8a73\u7d30\u5730\u5740<\/th><\/tr><tr><td>\u5929\u6cb3\u5340<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u7b2c11\u540d\uff1aUnique\u51fd\u6578<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u529f\u80fd<\/strong>\uff1a\u63d0\u53d6\u4e0d\u91cd\u8907\u5217\u8868\uff0c\u63d0\u53d6A\u5217\u4e0d\u91cd\u8907\u516c\u53f8\u540d\u7a31<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u793a\u4f8b<\/strong>\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code><code>=Unique(A:A)<\/code><\/code><\/pre>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><th>A\u5217<\/th><\/tr><tr><td>\u516c\u53f8\u540d\u7a31<\/td><\/tr><tr><td>\u516c\u53f8A<\/td><\/tr><tr><td>\u516c\u53f8B<\/td><\/tr><tr><td>\u516c\u53f8A<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u7d50\u679c<\/strong>\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><th>\u4e0d\u91cd\u8907\u516c\u53f8\u540d\u7a31<\/th><\/tr><tr><td>\u516c\u53f8A<\/td><\/tr><tr><td>\u516c\u53f8B<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u7b2c12\u540d\uff1aSort\u51fd\u6578<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u529f\u80fd<\/strong>\uff1a\u5c0d\u8868\u683c\u9032\u884c\u6392\u5e8f\uff0c\u6309\u8868\u683c\u7684\u7b2c3\u5217\u964d\u5e8f\u6392\u5217<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u793a\u4f8b<\/strong>\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code><code>=SORT(A1:D10,3,-1)<\/code><\/code><\/pre>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><th>A\u5217<\/th><th>B\u5217<\/th><th>C\u5217<\/th><th>D\u5217<\/th><\/tr><tr><td>\u540d\u7a31<\/td><td>\u985e\u578b<\/td><td>\u6578\u91cf<\/td><td>\u50f9\u683c<\/td><\/tr><tr><td>\u5546\u54c11<\/td><td>\u985e\u5225A<\/td><td>10<\/td><td>20<\/td><\/tr><tr><td>\u5546\u54c12<\/td><td>\u985e\u5225B<\/td><td>5<\/td><td>50<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u7d50\u679c<\/strong>\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><th>A\u5217<\/th><th>B\u5217<\/th><th>C\u5217<\/th><th>D\u5217<\/th><\/tr><tr><td>\u5546\u54c11<\/td><td>\u985e\u5225A<\/td><td>10<\/td><td>20<\/td><\/tr><tr><td>\u5546\u54c12<\/td><td>\u985e\u5225B<\/td><td>5<\/td><td>50<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u7b2c13\u540d\uff1aSortBy\u51fd\u6578<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u529f\u80fd<\/strong>\uff1a\u591a\u5217\u6392\u5e8f\uff0c\u6309\u8868\u683c\u7684C\u5217\u3001D\u5217\u5347\u5e8f\u6392\u5217<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u793a\u4f8b<\/strong>\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code><code>=SORTBY(A2:D11,C2:C11,1,D2:D11,1)<\/code><\/code><\/pre>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><th>A\u5217<\/th><th>B\u5217<\/th><th>C\u5217<\/th><th>D\u5217<\/th><\/tr><tr><td>\u540d\u7a31<\/td><td>\u985e\u578b<\/td><td>\u6578\u91cf<\/td><td>\u50f9\u683c<\/td><\/tr><tr><td>\u5546\u54c11<\/td><td>\u985e\u5225A<\/td><td>10<\/td><td>20<\/td><\/tr><tr><td>\u5546\u54c12<\/td><td>\u985e\u5225B<\/td><td>5<\/td><td>50<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u7d50\u679c<\/strong>\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><th>A\u5217<\/th><th>B\u5217<\/th><th>C\u5217<\/th><th>D\u5217<\/th><\/tr><tr><td>\u5546\u54c12<\/td><td>\u985e\u5225B<\/td><td>5<\/td><td>50<\/td><\/tr><tr><td>\u5546\u54c11<\/td><td>\u985e\u5225A<\/td><td>10<\/td><td>20<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u7b2c14\u540d\uff1aTocol\u51fd\u6578<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u529f\u80fd<\/strong>\uff1a\u628a\u591a\u5217\u503c\u8f49\u63db\u6210\u4e00\u5217\uff0c\u628aA1:F10\u5340\u57df\u8f49\u63db\u6210\u4e00\u5217<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u793a\u4f8b<\/strong>\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code><code>=Tocol(A1:F10)<\/code><\/code><\/pre>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><th>A\u5217<\/th><th>B\u5217<\/th><th>C\u5217<\/th><th>D\u5217<\/th><th>E\u5217<\/th><th>F\u5217<\/th><\/tr><tr><td>1<\/td><td>2<\/td><td>3<\/td><td>4<\/td><td>5<\/td><td>6<\/td><\/tr><tr><td>7<\/td><td>8<\/td><td>9<\/td><td>10<\/td><td>11<\/td><td>12<\/td><\/tr><tr><td>13<\/td><td>14<\/td><td>15<\/td><td>16<\/td><td>17<\/td><td>18<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u7d50\u679c<\/strong>\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><th>\u7d50\u679c<\/th><\/tr><tr><td>1<\/td><\/tr><tr><td>2<\/td><\/tr><tr><td>3<\/td><\/tr><tr><td>4<\/td><\/tr><tr><td>5<\/td><\/tr><tr><td>6<\/td><\/tr><tr><td>7<\/td><\/tr><tr><td>8<\/td><\/tr><tr><td>9<\/td><\/tr><tr><td>10<\/td><\/tr><tr><td>11<\/td><\/tr><tr><td>12<\/td><\/tr><tr><td>13<\/td><\/tr><tr><td>14<\/td><\/tr><tr><td>15<\/td><\/tr><tr><td>16<\/td><\/tr><tr><td>17<\/td><\/tr><tr><td>18<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u7b2c15\u540d\uff1aToRow\u51fd\u6578<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u529f\u80fd<\/strong>\uff1a\u628a\u591a\u5217\u503c\u8f49\u63db\u6210\u4e00\u884c\uff0c\u628aA1:F10\u5340\u57df\u8f49\u63db\u6210\u4e00\u884c<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u793a\u4f8b<\/strong>\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code><code>=ToRow(A1:F10)<\/code><\/code><\/pre>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><th>A\u5217<\/th><th>B\u5217<\/th><th>C\u5217<\/th><th>D\u5217<\/th><th>E\u5217<\/th><th>F\u5217<\/th><\/tr><tr><td>1<\/td><td>2<\/td><td>3<\/td><td>4<\/td><td>5<\/td><td>6<\/td><\/tr><tr><td>7<\/td><td>8<\/td><td>9<\/td><td>10<\/td><td>11<\/td><td>12<\/td><\/tr><tr><td>13<\/td><td>14<\/td><td>15<\/td><td>16<\/td><td>17<\/td><td>18<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u7d50\u679c<\/strong>\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><th>\u7d50\u679c<\/th><\/tr><tr><td>1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u7b2c16\u540d\uff1aHstack\u51fd\u6578<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u529f\u80fd<\/strong>\uff1a\u6a6b\u5411\u5408\u4f75\u591a\u500b\u8868\u683c\uff0c\u628aA\u5217\u3001C\u5217\u3001F\u5217\u5408\u4f75\u6210\u4e00\u500b\u65b0\u8868\u683c<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u793a\u4f8b<\/strong>\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code><code>=Hstack(A1:A10,C1:C10,F1:F10)<\/code><\/code><\/pre>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><th>A\u5217<\/th><th>C\u5217<\/th><th>F\u5217<\/th><\/tr><tr><td>1<\/td><td>3<\/td><td>6<\/td><\/tr><tr><td>2<\/td><td>4<\/td><td>7<\/td><\/tr><tr><td>5<\/td><td>8<\/td><td>9<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u7d50\u679c<\/strong>\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><th>\u7d50\u679c<\/th><\/tr><tr><td>1<\/td><td>3<\/td><td>6<\/td><\/tr><tr><td>2<\/td><td>4<\/td><td>7<\/td><\/tr><tr><td>5<\/td><td>8<\/td><td>9<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u7b2c17\u540d\uff1aChooseCols\u51fd\u6578<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u529f\u80fd<\/strong>\uff1a\u5f9e\u8868\u683c\u4e2d\u63d0\u53d6\u90e8\u5206\u5217\uff0c\u63d0\u53d6\u8868\u683c\u76841\uff0c2\uff0c5\u5217<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u793a\u4f8b<\/strong>\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code><code>=ChooseCols(A1:G10,1,2,5)<\/code><\/code><\/pre>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><th>A\u5217<\/th><th>B\u5217<\/th><th>C\u5217<\/th><th>D\u5217<\/th><th>E\u5217<\/th><th>F\u5217<\/th><th>G\u5217<\/th><\/tr><tr><td>1<\/td><td>2<\/td><td>3<\/td><td>4<\/td><td>5<\/td><td>6<\/td><td>7<\/td><\/tr><tr><td>8<\/td><td>9<\/td><td>10<\/td><td>11<\/td><td>12<\/td><td>13<\/td><td>14<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u7d50\u679c<\/strong>\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><th>\u7d50\u679c<\/th><th>\u52171<\/th><th>\u52172<\/th><th>\u52175<\/th><\/tr><tr><td>1<\/td><td>2<\/td><td>5<\/td><\/tr><tr><td>8<\/td><td>9<\/td><td>12<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u7b2c18\u540d\uff1aChooseRows\u51fd\u6578<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u529f\u80fd<\/strong>\uff1a\u5f9e\u8868\u683c\u4e2d\u63d0\u53d6\u90e8\u5206\u884c\uff0c\u63d0\u53d6\u8868\u683c\u76841\uff0c2\uff0c5\u884c<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u793a\u4f8b<\/strong>\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code><code>=ChooseRows(A1:G10,1,2,5)<\/code><\/code><\/pre>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><th>A\u5217<\/th><th>B\u5217<\/th><th>C\u5217<\/th><th>D\u5217<\/th><th>E\u5217<\/th><th>F\u5217<\/th><th>G\u5217<\/th><\/tr><tr><td>1<\/td><td>2<\/td><td>3<\/td><td>4<\/td><td>5<\/td><td>6<\/td><td>7<\/td><\/tr><tr><td>8<\/td><td>9<\/td><td>10<\/td><td>11<\/td><td>12<\/td><td>13<\/td><td>14<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u7d50\u679c<\/strong>\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><th>\u7d50\u679c<\/th><th>\u884c1<\/th><th>\u884c2<\/th><th>\u884c5<\/th><\/tr><tr><td>1<\/td><td>2<\/td><td>3<\/td><td>4<\/td><\/tr><tr><td>8<\/td><td>9<\/td><td>10<\/td><td>11<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u7b2c19\u540d\uff1aDrop\u51fd\u6578<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u529f\u80fd<\/strong>\uff1a\u522a\u9664\u8868\u683c\u7684\u884c\u6216\u5217\uff0c\u522a\u9664\u8868\u683c\u7684\u7b2c1\u884c<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u793a\u4f8b<\/strong>\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code><code>=Drop(A1:A100,1)<\/code><\/code><\/pre>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><th>A\u5217<\/th><\/tr><tr><td>1<\/td><\/tr><tr><td>2<\/td><\/tr><tr><td>3<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u7d50\u679c<\/strong>\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><th>\u7d50\u679c<\/th><\/tr><tr><td>2<\/td><\/tr><tr><td>3<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u7b2c20\u540d\uff1aTake\u51fd\u6578<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u529f\u80fd<\/strong>\uff1a\u63d0\u53d6\u8868\u683c\u7684\u524dN\u884c\u6216N\u5217\uff0c\u63d0\u53d6\u8868\u683c\u7684\u524d10\u884c<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u793a\u4f8b<\/strong>\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code><code>=Take(A1:F100,10)<\/code><\/code><\/pre>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><th>A\u5217<\/th><th>B\u5217<\/th><th>C\u5217<\/th><th>D\u5217<\/th><th>E\u5217<\/th><th>F\u5217<\/th><\/tr><tr><td>1<\/td><td>2<\/td><td>3<\/td><td>4<\/td><td>5<\/td><td>6<\/td><\/tr><tr><td>7<\/td><td>8<\/td><td>9<\/td><td>10<\/td><td>11<\/td><td>12<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u7d50\u679c<\/strong>\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><th>\u7d50\u679c<\/th><th>\u52171<\/th><th>\u52172<\/th><th>\u52173<\/th><th>\u52174<\/th><th>\u52175<\/th><th>\u52176<\/th><\/tr><tr><td>1<\/td><td>2<\/td><td>3<\/td><td>4<\/td><td>5<\/td><td>6<\/td><\/tr><tr><td>7<\/td><td>8<\/td><td>9<\/td><td>10<\/td><td>11<\/td><td>12<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u7b2c21\u540d\uff1aArraytotext\u51fd\u6578<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u529f\u80fd<\/strong>\uff1a\u7528\u9017\u865f\u9023\u63a5\u5b57\u5143\u6216\u6578\u4f4d\uff0c\u628aA1:A10\u7684\u503c\u7528\u9017\u865f\u9023\u63a5\u8d77\u4f86<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u793a\u4f8b<\/strong>\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code><code>=Arraytotext(A1:A10)<\/code><\/code><\/pre>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><th>A\u5217<\/th><\/tr><tr><td>1<\/td><\/tr><tr><td>2<\/td><\/tr><tr><td>3<\/td><\/tr><tr><td>4<\/td><\/tr><tr><td>5<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u7d50\u679c<\/strong>\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><th>\u7d50\u679c<\/th><\/tr><tr><td>1, 2, 3, 4, 5<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u7b2c22\u540d\uff1aConcat\u51fd\u6578<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u529f\u80fd<\/strong>\uff1a\u9023\u63a5\u5b57\u5143\u6216\u6578\u4f4d\uff0c\u628aA1:A10\u7684\u503c\u7528\u9023\u63a5\u8d77\u4f86<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u793a\u4f8b<\/strong>\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code><code>=Concat(A1:A10)<\/code><\/code><\/pre>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><th>A\u5217<\/th><\/tr><tr><td>1<\/td><\/tr><tr><td>2<\/td><\/tr><tr><td>3<\/td><\/tr><tr><td>4<\/td><\/tr><tr><td>5<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u7d50\u679c<\/strong>\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><th>\u7d50\u679c<\/th><\/tr><tr><td>1 2 3 4 5<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u7b2c23\u540d\uff1aSequence\u51fd\u6578<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u529f\u80fd<\/strong>\uff1a\u751f\u6210\u5e8f\u5217\uff0c\u751f\u62101~10\u4e4b\u9593\u7684\u5076\u6578<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u793a\u4f8b<\/strong>\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code><code>=Sequence(5,,2,2)<\/code><\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u7d50\u679c<\/strong>\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><th>\u7d50\u679c<\/th><\/tr><tr><td>2<\/td><\/tr><tr><td>4<\/td><\/tr><tr><td>6<\/td><\/tr><tr><td>8<\/td><\/tr><tr><td>10<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u7b2c24\u540d\uff1aRegexreplace\u51fd\u6578<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u529f\u80fd<\/strong>\uff1a\u7528\u898f\u5247\u904b\u7b97\u5f0f\u66ff\u63db\u5b57\u5143\uff0c\u628aA1\u4e2d\u7684\u6578\u5b57\u66ff\u63db\u6210100<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u793a\u4f8b<\/strong>\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code><code>=Regexreplace(A1,\"\\d+\",100)<\/code><\/code><\/pre>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><th>A\u5217<\/th><\/tr><tr><td>123<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u7d50\u679c<\/strong>\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><th>\u7d50\u679c<\/th><\/tr><tr><td>100<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u7b2c25\u540d\uff1aRegextest\u51fd\u6578<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u529f\u80fd<\/strong>\uff1a\u7528\u898f\u5247\u904b\u7b97\u5f0f\u5224\u65b7\u662f\u5426\u5305\u542b\uff0c\u5224\u65b7A1\u4e2d\u662f\u5426\u5305\u542b\u6578\u4f4d<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u793a\u4f8b<\/strong>\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code><code>=Regexextract(A1,\"\\\\d+\")<\/code><\/code><\/pre>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><th>A\u5217<\/th><\/tr><tr><td>abc123<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u7d50\u679c<\/strong>\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><th>\u7d50\u679c<\/th><\/tr><tr><td>123<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u7b2c26\u540d\uff1aLambda\u51fd\u6578<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u529f\u80fd<\/strong>\uff1a\u81ea\u8a02\u51fd\u6578\uff0c\u5b9a\u7fa9\u4e00\u500b\u5169\u500b\u6578\u76f8\u52a0\u7684\u51fd\u6578<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u793a\u4f8b<\/strong>\uff1a<code>=Lambda(x,y,x+y)<\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u7d50\u679c<\/strong>\uff1a<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">&nbsp;<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><th>\u7d50\u679c<\/th><\/tr><tr><td>3<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u7b2c27\u540d\uff1aReduce\u51fd\u6578<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u529f\u80fd<\/strong>\uff1a\u904d\u6b77\u9663\u5217\u5167\u6bcf\u500b\u503c\uff0c\u7d2f\u8a08\u51fa\u904b\u7b97\u7d50\u679c\uff0c\u628aA1:A10\u4e2d\u7684\u6b63\u6578\u7d2f\u52a0<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u793a\u4f8b<\/strong>\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code><code>=Reduce(0,A1:A10,Lambda(x,y,IF(y>0,x+y,x)))<\/code><\/code><\/pre>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><th>A\u5217<\/th><\/tr><tr><td>1<\/td><\/tr><tr><td>-1<\/td><\/tr><tr><td>2<\/td><\/tr><tr><td>3<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u7d50\u679c<\/strong>\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><th>\u7d50\u679c<\/th><\/tr><tr><td>6<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u7b2c28\u540d\uff1aScan\u51fd\u6578<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u529f\u80fd<\/strong>\uff1a\u548cReduce\u540c\u6a23\u7684\u904b\u7b97\u6a21\u5f0f\uff0c\u5340\u5225\u662f\u4fdd\u5b58\u6bcf\u4e00\u6b21\u904b\u7b97\u7d50\u679c\uff0c\u628aA1:A10\u4e2d\u7684\u6b63\u6578\u7d2f\u52a0\u4e26\u8fd4\u56de\u6bcf\u6b21\u7d2f\u8a08\u7d50\u679c<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u793a\u4f8b<\/strong>\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code><code>=Scan(0,A1:A10,Lambda(x,y,IF(y>0,x+y,x)))<\/code><\/code><\/pre>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><th>A\u5217<\/th><\/tr><tr><td>1<\/td><\/tr><tr><td>-1<\/td><\/tr><tr><td>2<\/td><\/tr><tr><td>3<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u7d50\u679c<\/strong>\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><th>\u7d50\u679c<\/th><\/tr><tr><td>1<\/td><\/tr><tr><td>1<\/td><\/tr><tr><td>3<\/td><\/tr><tr><td>6<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u7b2c29\u540d\uff1aMap\u51fd\u6578<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u529f\u80fd<\/strong>\uff1a\u5c0d\u9663\u5217\u7684\u6bcf\u500b\u503c\u9032\u884c\u8655\u7406\uff0c\u4e26\u8fd4\u56de\u6bcf\u500b\u503c\uff0c\u628aA1:A10\u4e2d\u7a7a\u503c\u66ff\u63db\u70ba\u5927\u5beb\u96f6<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u793a\u4f8b<\/strong>\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code><code>=Map(A1:A10,Lambda(X,IF(X=0,\"\u96f6\",X)))<\/code><\/code><\/pre>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><th>A\u5217<\/th><\/tr><tr><td>1<\/td><\/tr><tr><td>0<\/td><\/tr><tr><td>2<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u7d50\u679c<\/strong>\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><th>\u7d50\u679c<\/th><\/tr><tr><td>1<\/td><\/tr><tr><td>\u96f6<\/td><\/tr><tr><td>2<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u7b2c30\u540d\uff1aLet\u51fd\u6578<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u529f\u80fd<\/strong>\uff1a\u5b9a\u7fa9\u540d\u7a31\u7528\u4f86\u7c21\u5316\u516c\u5f0f\uff0c\u5c0dVlookup\u67e5\u627e\u7d50\u679c\u9032\u884c\u5224\u65b7<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u793a\u4f8b<\/strong>\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code><code>=Let(x,Vlookup(D1,A:B,2,0),IF(x>10,\"\u5b8c\u6210\",\"\u672a\u5b8c\u6210\"))<\/code><\/code><\/pre>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><th>A\u5217<\/th><th>B\u5217<\/th><\/tr><tr><td>1<\/td><td>15<\/td><\/tr><tr><td>2<\/td><td>5<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u7d50\u679c<\/strong>\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><th>\u7d50\u679c<\/th><\/tr><tr><td>\u5b8c\u6210<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u7b2c31\u540d\uff1aByrow\u51fd\u6578<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u529f\u80fd<\/strong>\uff1a\u5c0d\u6bcf\u4e00\u884c\u503c\u9032\u884c\u904b\u7b97\uff0c\u8fd4\u56de\u5340\u57df\u6bcf\u4e00\u884c\u5e73\u5747\u503c<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u793a\u4f8b<\/strong>\uff1a<code>=Byrow(B2:F5,AVERAGE)<\/code><\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><th>B\u5217<\/th><th>C\u5217<\/th><th>D\u5217<\/th><th>E\u5217<\/th><th>F\u5217<\/th><\/tr><tr><td>1<\/td><td>2<\/td><td>3<\/td><td>4<\/td><td>5<\/td><\/tr><tr><td>6<\/td><td>7<\/td><td>8<\/td><td>9<\/td><td>10<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u7d50\u679c<\/strong>\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><th>\u7d50\u679c<\/th><\/tr><tr><td>3<\/td><\/tr><tr><td>8<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u7b2c32\u540d\uff1aByCol\u51fd\u6578<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u529f\u80fd<\/strong>\uff1a\u5c0d\u6bcf\u4e00\u5217\u503c\u9032\u884c\u904b\u7b97\uff0c\u8fd4\u56de\u591a\u500b\u7d50\u679c\uff0c\u8fd4\u56de\u5340\u57df\u6bcf\u4e00\u5217\u5e73\u5747\u503c<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u793a\u4f8b<\/strong>\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code><code>=ByCol(B2:F5,AVERAGE)<\/code><\/code><\/pre>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><th>B\u5217<\/th><th>C\u5217<\/th><th>D\u5217<\/th><th>E\u5217<\/th><th>F\u5217<\/th><\/tr><tr><td>1<\/td><td>2<\/td><td>3<\/td><td>4<\/td><td>5<\/td><\/tr><tr><td>6<\/td><td>7<\/td><td>8<\/td><td>9<\/td><td>10<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u7d50\u679c<\/strong>\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><th>\u7d50\u679c<\/th><\/tr><tr><td>3.5<\/td><\/tr><tr><td>4.5<\/td><\/tr><tr><td>5.5<\/td><\/tr><tr><td>6.5<\/td><\/tr><tr><td>7.5<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\u672c\u6587\u6982\u8ff0\u4e8632\u500bExcel\u51fd\u6578\u7684\u529f\u80fd\u548c\u4f7f\u7528\u793a\u4f8b\uff0c\u5f9e\u57fa\u672c\u7684\u6578\u64da\u91cd\u7d44\u51fd\u6578\u5982Tocol\u548cToRow\uff0c\u5230\u66f4\u8907\u96dc\u7684\u81ea\u5b9a\u7fa9\u51fd\u6578\u5982Lambda\u548cReduce\uff0c\u9019\u4e9b\u51fd\u6578\u5c55\u793a\u4e86Excel\u5728\u6578\u64da\u8655\u7406\u65b9\u9762\u7684\u5f37\u5927\u80fd\u529b\u3002\u900f\u904e\u9019\u4e9b\u51fd\u6578\uff0c\u4f7f\u7528\u8005\u53ef\u4ee5\u66f4\u9748\u6d3b\u5730\u64cd\u4f5c\u6578\u64da\uff0c\u6eff\u8db3\u4e0d\u540c\u7684\u5206\u6790\u9700\u6c42\u3002\u96a8\u8457Excel\u4e0d\u65b7\u9032\u5316\uff0c\u638c\u63e1\u9019\u4e9b\u51fd\u6578\u5c07\u6709\u52a9\u65bc\u7528\u6236\u5728\u6578\u64da\u5206\u6790\u7684\u9053\u8def\u4e0a\u8d70\u5f97\u66f4\u9060\uff0c\u4e26\u5145\u5206\u767c\u63eeExcel\u7684\u6f5b\u529b\u3002<\/p>\n\n\n\n<div style=\"height:var(--wp--preset--spacing--superbspacing-small)\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<div class=\"wp-block-group alignfull has-mono-3-background-color has-background is-vertical is-layout-flex wp-container-core-group-is-layout-4ca38564 wp-block-group-is-layout-flex\" style=\"margin-top:0;margin-bottom:0;padding-top:var(--wp--preset--spacing--superbspacing-large);padding-right:var(--wp--preset--spacing--superbspacing-small);padding-bottom:var(--wp--preset--spacing--superbspacing-large);padding-left:var(--wp--preset--spacing--superbspacing-small)\">\n<h2 class=\"wp-block-heading\">\u5fae\u8edf\u5b98\u65b9\u8aaa\u660e<\/h2>\n\n\n\n<div class=\"wp-block-buttons is-layout-flex wp-block-buttons-is-layout-flex\">\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link wp-element-button\" href=\"https:\/\/support.microsoft.com\/zh-hk\/office\/pivotby-%E5%87%BD%E6%95%B8-de86516a-90ad-4ced-8522-3a25fac389cf\" target=\"_blank\" rel=\"noreferrer noopener\">PIVOTBY<\/a><\/div>\n\n\n\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link wp-element-button\" href=\"https:\/\/support.microsoft.com\/zh-hk\/office\/groupby-%E5%87%BD%E6%95%B8-5e08ae8c-6800-4b72-b623-c41773611505\" target=\"_blank\" rel=\"noreferrer noopener\">GROUPBY<\/a><\/div>\n\n\n\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link wp-element-button\" href=\"https:\/\/support.microsoft.com\/zh-hk\/office\/regexextract-%E5%87%BD%E6%95%B8-4b96c140-9205-4b6e-9fbe-6aa9e783ff57\" target=\"_blank\" rel=\"noreferrer noopener\">REGEXEXTRACT<\/a><\/div>\n\n\n\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link wp-element-button\" href=\"https:\/\/support.microsoft.com\/zh-hk\/office\/filter-%E5%87%BD%E6%95%B8-f4f7cb66-82eb-4767-8f7c-4877ad80c759\" target=\"_blank\" rel=\"noreferrer noopener\">FILTER<\/a><\/div>\n\n\n\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link wp-element-button\" href=\"https:\/\/support.microsoft.com\/zh-hk\/office\/vstack-%E5%87%BD%E6%95%B8-a4b86897-be0f-48fc-adca-fcc10d795a9c\" target=\"_blank\" rel=\"noreferrer noopener\">VSTACK<\/a><\/div>\n\n\n\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link wp-element-button\" href=\"https:\/\/support.microsoft.com\/zh-hk\/office\/xlookup-%E5%87%BD%E6%95%B8-b7fd680e-6d10-43e6-84f9-88eae8bf5929\" target=\"_blank\" rel=\"noreferrer noopener\">XLOOKUP<\/a><\/div>\n\n\n\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link wp-element-button\" href=\"https:\/\/support.microsoft.com\/zh-hk\/office\/textjoin-%E5%87%BD%E6%95%B8-357b449a-ec91-49d0-80c3-0e8fc845691c\" target=\"_blank\" rel=\"noreferrer noopener\">TEXTJOIN<\/a><\/div>\n\n\n\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link wp-element-button\" href=\"https:\/\/support.microsoft.com\/zh-hk\/office\/textsplit-%E5%87%BD%E6%95%B8-b1ca414e-4c21-4ca0-b1b7-bdecace8a6e7\" target=\"_blank\" rel=\"noreferrer noopener\">TEXTSPLIT<\/a><\/div>\n\n\n\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link wp-element-button\" href=\"https:\/\/support.microsoft.com\/zh-hk\/office\/textbefore-%E5%87%BD%E6%95%B8-d099c28a-dba8-448e-ac6c-f086d0fa1b29\" target=\"_blank\" rel=\"noreferrer noopener\">TEXTBEFORE<\/a><\/div>\n\n\n\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link wp-element-button\" href=\"https:\/\/support.microsoft.com\/zh-hk\/office\/textafter-%E5%87%BD%E6%95%B8-c8db2546-5b51-416a-9690-c7e6722e90b4\" target=\"_blank\" rel=\"noreferrer noopener\">TEXTAFTER<\/a><\/div>\n\n\n\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link wp-element-button\" href=\"https:\/\/support.microsoft.com\/zh-hk\/office\/unique-%E5%87%BD%E6%95%B8-c5ab87fd-30a3-4ce9-9d1a-40204fb85e1e\" target=\"_blank\" rel=\"noreferrer noopener\">UNIQUE<\/a><\/div>\n\n\n\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link wp-element-button\" href=\"https:\/\/support.microsoft.com\/zh-hk\/office\/sort-%E5%87%BD%E6%95%B8-22f63bd0-ccc8-492f-953d-c20e8e44b86c\" target=\"_blank\" rel=\"noreferrer noopener\">SORT<\/a><\/div>\n\n\n\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link wp-element-button\" href=\"https:\/\/support.microsoft.com\/zh-hk\/office\/sortby-%E5%87%BD%E6%95%B8-cd2d7a62-1b93-435c-b561-d6a35134f28f\" target=\"_blank\" rel=\"noreferrer noopener\">SORTBY<\/a><\/div>\n\n\n\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link wp-element-button\" href=\"https:\/\/support.microsoft.com\/zh-hk\/office\/tocol-%E5%87%BD%E6%95%B8-22839d9b-0b55-4fc1-b4e6-2761f8f122ed\" target=\"_blank\" rel=\"noreferrer noopener\">TOCOL<\/a><\/div>\n\n\n\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link wp-element-button\" href=\"https:\/\/support.microsoft.com\/zh-hk\/office\/torow-%E5%87%BD%E6%95%B8-b90d0964-a7d9-44b7-816b-ffa5c2fe2289\" target=\"_blank\" rel=\"noreferrer noopener\">TOROW<\/a><\/div>\n\n\n\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link wp-element-button\" href=\"https:\/\/support.microsoft.com\/zh-hk\/office\/hstack-%E5%87%BD%E6%95%B8-98c4ab76-10fe-4b4f-8d5f-af1c125fe8c2\" target=\"_blank\" rel=\"noreferrer noopener\">HSTACK<\/a><\/div>\n\n\n\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link wp-element-button\" href=\"https:\/\/support.microsoft.com\/zh-hk\/office\/choosecols-%E5%87%BD%E6%95%B8-bf117976-2722-4466-9b9a-1c01ed9aebff\" target=\"_blank\" rel=\"noreferrer noopener\">CHOOSECOLS<\/a><\/div>\n\n\n\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link wp-element-button\" href=\"https:\/\/support.microsoft.com\/zh-hk\/office\/chooserows-%E5%87%BD%E6%95%B8-51ace882-9bab-4a44-9625-7274ef7507a3\" target=\"_blank\" rel=\"noreferrer noopener\">CHOOSEROWS<\/a><\/div>\n\n\n\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link wp-element-button\" href=\"https:\/\/support.microsoft.com\/zh-hk\/office\/drop-%E5%87%BD%E6%95%B8-1cb4e151-9e17-4838-abe5-9ba48d8c6a34\" target=\"_blank\" rel=\"noreferrer noopener\">DROP<\/a><\/div>\n\n\n\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link wp-element-button\" href=\"https:\/\/support.microsoft.com\/zh-hk\/office\/take-%E5%87%BD%E6%95%B8-25382ff1-5da1-4f78-ab43-f33bd2e4e003\" target=\"_blank\" rel=\"noreferrer noopener\">TAKE<\/a><\/div>\n\n\n\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link wp-element-button\" href=\"https:\/\/support.microsoft.com\/zh-hk\/office\/arraytotext-%E5%87%BD%E6%95%B8-9cdcad46-2fa5-4c6b-ac92-14e7bc862b8b\" target=\"_blank\" rel=\"noreferrer noopener\">ARRAYTOTEXT<\/a><\/div>\n\n\n\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link wp-element-button\" href=\"https:\/\/support.microsoft.com\/zh-hk\/office\/concat-%E5%87%BD%E6%95%B8-9b1a9a3f-94ff-41af-9736-694cbd6b4ca2\" target=\"_blank\" rel=\"noreferrer noopener\">CONCAT<\/a><\/div>\n\n\n\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link wp-element-button\" href=\"https:\/\/support.microsoft.com\/zh-hk\/office\/sequence-%E5%87%BD%E6%95%B8-57467a98-57e0-4817-9f14-2eb78519ca90\" target=\"_blank\" rel=\"noreferrer noopener\">SEQUENCE<\/a><\/div>\n\n\n\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link wp-element-button\" href=\"https:\/\/support.microsoft.com\/zh-hk\/office\/regexreplace-%E5%87%BD%E6%95%B8-9c030bb2-5e47-4efc-bad5-4582d7100897\" target=\"_blank\" rel=\"noreferrer noopener\">REGEXREPLACE<\/a><\/div>\n\n\n\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link wp-element-button\" href=\"https:\/\/support.microsoft.com\/en-us\/office\/regextest-function-7d38200b-5e5c-4196-b4e6-9bff73afbd31\" target=\"_blank\" rel=\"noreferrer noopener\">REGEXTTEST<\/a><\/div>\n\n\n\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link wp-element-button\" href=\"https:\/\/support.microsoft.com\/zh-hk\/office\/lambda-%E5%87%BD%E6%95%B8-bd212d27-1cd1-4321-a34a-ccbf254b8b67\" target=\"_blank\" rel=\"noreferrer noopener\">LAMBDA<\/a><\/div>\n\n\n\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link wp-element-button\" href=\"https:\/\/support.microsoft.com\/zh-hk\/office\/reduce-%E5%87%BD%E6%95%B8-42e39910-b345-45f3-84b8-0642b568b7cb\" target=\"_blank\" rel=\"noreferrer noopener\">REDUCE<\/a><\/div>\n\n\n\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link wp-element-button\" href=\"https:\/\/support.microsoft.com\/zh-hk\/office\/scan-%E5%87%BD%E6%95%B8-d58dfd11-9969-4439-b2dc-e7062724de29\" target=\"_blank\" rel=\"noreferrer noopener\">SCAN<\/a><\/div>\n\n\n\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link wp-element-button\" href=\"https:\/\/support.microsoft.com\/zh-hk\/office\/map-%E5%87%BD%E6%95%B8-48006093-f97c-47c1-bfcc-749263bb1f01\" target=\"_blank\" rel=\"noreferrer noopener\">MAP<\/a><\/div>\n\n\n\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link wp-element-button\" href=\"https:\/\/support.microsoft.com\/zh-hk\/office\/let-%E5%87%BD%E6%95%B8-34842dd8-b92b-4d3f-b325-b8b8f9908999\" target=\"_blank\" rel=\"noreferrer noopener\">LET<\/a><\/div>\n\n\n\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link wp-element-button\" href=\"https:\/\/support.microsoft.com\/zh-hk\/office\/byrow-%E5%87%BD%E6%95%B8-2e04c677-78c8-4e6b-8c10-a4602f2602bb\" target=\"_blank\" rel=\"noreferrer noopener\">BYROW<\/a><\/div>\n\n\n\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link wp-element-button\" href=\"https:\/\/support.microsoft.com\/zh-hk\/office\/bycol-%E5%87%BD%E6%95%B8-58463999-7de5-49ce-8f38-b7f7a2192bfb\" target=\"_blank\" rel=\"noreferrer noopener\">BYCOL<\/a><\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u5728\u6578\u64da\u9a45\u52d5\u7684\u6642\u4ee3\uff0cExcel \u5df2\u6210\u70ba\u6578\u64da\u5206\u6790\u548c\u7ba1\u7406\u7684\u91cd\u8981\u5de5\u5177\u3002\u672c\u6587\u5c07\u6df1\u5165\u4ecb\u7d39 32 \u500b\u5168\u65b0\u7684 Excel \u51fd\u6578 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":3120,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[8,49,7,25,1,137,12,18],"tags":[228,237,236,248,249,229,250,212,239,247,232,207,235,238,233,240,230,231,234,211,210,209,227,244,243,208,242,245,246,79,216,241],"class_list":["post-3203","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","category-date","category-excel-formulas","category-logical","category-lookup","category-macro-functions","category-mathematical","category-text","tag-arraytotext","tag-bycol","tag-byrow","tag-choosecols","tag-chooserows","tag-concat","tag-drop","tag-filter","tag-groupby","tag-hstack","tag-lambda","tag-let","tag-map","tag-pivotby","tag-reduce","tag-regexextract","tag-regexreplace","tag-regextest","tag-scan","tag-sequence","tag-sort","tag-sortby","tag-take","tag-textafter","tag-textbefore","tag-textjoin","tag-textsplit","tag-tocol","tag-torow","tag-unique","tag-vstack","tag-xlookup"],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2020\/03\/Excel-new10.png?fit=2102%2C679&ssl=1","_links":{"self":[{"href":"https:\/\/www.fyndpro.com\/cn\/wp-json\/wp\/v2\/posts\/3203","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.fyndpro.com\/cn\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.fyndpro.com\/cn\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.fyndpro.com\/cn\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.fyndpro.com\/cn\/wp-json\/wp\/v2\/comments?post=3203"}],"version-history":[{"count":2,"href":"https:\/\/www.fyndpro.com\/cn\/wp-json\/wp\/v2\/posts\/3203\/revisions"}],"predecessor-version":[{"id":3280,"href":"https:\/\/www.fyndpro.com\/cn\/wp-json\/wp\/v2\/posts\/3203\/revisions\/3280"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.fyndpro.com\/cn\/wp-json\/wp\/v2\/media\/3120"}],"wp:attachment":[{"href":"https:\/\/www.fyndpro.com\/cn\/wp-json\/wp\/v2\/media?parent=3203"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fyndpro.com\/cn\/wp-json\/wp\/v2\/categories?post=3203"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fyndpro.com\/cn\/wp-json\/wp\/v2\/tags?post=3203"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}