ÕªÒª£º 2024-1-25¸üР×ÛºÏÁ·Ï°£º ת»»½á¹¹-Ò»ÁÐת¶þά±í ÒÀ´ÎÌæ»» µÝ¹éʾÀý Let LETº¯Êý Lambda Lambda¹«Ê½£¬º¯Êý¹«Ê½orº¯ÊýÃû£¿ µÝ¹éÖ®Ò» µÝ¹éÖ®¶þ µÝ¹éÖ®Èý¡ª¡ªÍêÕûµÄ¿ÆÄ¿Ãû³Æ MakeArray »ªÀöÀöµØÔ½¹ýÁ˶àάÒýÓõÄMakeArray ByRow/ByCol ÓÐÁËByR ÔĶÁÈ«ÎÄ
posted @ 2022-12-22 16:03 °¾·ÊÑý ÔĶÁ(170) ÆÀÂÛ(1) ÍƼö(0) ±à¼­
ÕªÒª£º 2022-8-13¸üРPower QueryʾÀý»ã×Ü Ö÷Ò³£¨Ñ¡Ï£© ¹ÜÀíÁУ¨×飩 Ñ¡ÔñÁÐ Ñ¡ÔñÁÐTable.SelectColumns ɾ³ýÁРɾ³ýÁÐTable.RemoveColumns ɾ³ýÆäËûÁÐTable.SelectColumns ¼õÉÙÐУ¨×飩 ±£ÁôÐÐ ±£ÁôÇ°ÃæN¡­.First/Firs ÔĶÁÈ«ÎÄ
posted @ 2020-08-15 19:42 °¾·ÊÑý ÔĶÁ(5357) ÆÀÂÛ(0) ÍƼö(1) ±à¼­
ÕªÒª£º 20230401-20240331µÄÁãÉ¢ÊÓƵ£º Á´½Ó£ºhttps://pan.baidu.com/s/1po333w8ST6nccs178eDmUg ÌáÈ¡Â룺foun WPSÁãÉ¢ÊÓƵ£º Á´½Ó£ºhttps://pan.baidu.com/s/1Weuo2iJDZ0PPRXVapEt35gÌáÈ¡Â룺yjn ÔĶÁÈ«ÎÄ
posted @ 2020-07-13 19:16 °¾·ÊÑý ÔĶÁ(1227) ÆÀÂÛ(0) ÍƼö(1) ±à¼­
ÕªÒª£º ÎÊÌ⣺һά±íת³É¶þά±í£¬Öظ´µÄÄÚÈݺáÏòÕ¹¿ª º¯Êý¹«Ê½½â¾ö£º =TOROW(FILTER(B$2:C$7,A$2:A$7=E2)) ÔĶÁÈ«ÎÄ
posted @ 2024-06-30 15:52 °¾·ÊÑý ÔĶÁ(1) ÆÀÂÛ(0) ÍƼö(0) ±à¼­
ÕªÒª£º ÎÊÌ⣺ÖÆ×÷É¢µãͼ£¬¿É¸ù¾Ý²¿ÃÅÇÐƬ£¬Êý¾Ý±êÇ©ÏÔʾÐÕÃû¡¢Ð½×Ê¡¢Òµ¼¨¡£ ½â¾ö£º Ñ¡È¡±íÖÐÈa56爆大奖在线娱乐âÒ»¸öµ¥Ôª¸ñ¡·²åÈë¡·±í¸ñ£¬½«ÆÕͨ±íת³É³¬¼¶±í Ñ¡È¡±íÖÐÈa56爆大奖在线娱乐âµ¥Ôª¸ñ¡·±í¸ñ¹¤¾ß¡·²åÈëÇÐƬÆ÷¡·¹´Ñ¡¡°Ò»¼¶²¿ÃÅ¡±¡·È·¶¨ Ñ¡È¡D1:F9£¬²åÈ롷ͼ±í¡·Ñ¡ÔñÉ¢µãͼ Ë«»÷ͼ±íÈa56爆大奖在线娱乐âλÖá·Í¼±íÑ¡Ïî¡·´óСÓëÊôÐÔ¡·ÊôÐÔ¡·´óСºÍλÖþù¹Ì¶¨ ÔĶÁÈ«ÎÄ
posted @ 2024-06-30 15:49 °¾·ÊÑý ÔĶÁ(2) ÆÀÂÛ(0) ÍƼö(0) ±à¼­
ÕªÒª£º ÎÊÌ⣺A¡¢BÁ½¸ö±í£¬ÔÚB±íÖÐÅжÏÆäÖÐÊý¾ÝÔÚA±íÊÇ·ñ´æÔÚ¡£ º¯Êý¹«Ê½½â¾ö£º =COUNTIF(A!A:A,A2) ÔĶÁÈ«ÎÄ
posted @ 2024-06-30 15:30 °¾·ÊÑý ÔĶÁ(1) ÆÀÂÛ(0) ÍƼö(0) ±à¼­
ÕªÒª£º ÎÊÌ⣺ ÒÔÏÂÊý¾ÝÆðʼֵΪ0£¬Óë0ͬÐеÄ2ÔÚÊý¾ÝÔ´ÖÐÓÐÖظ´£¬ÔòÈ¡ÓëÖ®Öظ´µÄ2µÄͬÐÐÊý¾Ý¼´6£¬6ÔÚÊý¾ÝÔ´ÖÐÈÔÓÐÖظ´£¬ÔÙÈ¡ÓëÖ®Öظ´µÄ6µÄͬÐÐÊý¾Ý8£¬8ÔÚÊý¾ÝÔ´ÖÐûÓÐÖظ´£¬ÔòΪµÚÒ»ÐеڶþÁеĽá¹û¡£ ÒÔ´ËÀàÍÆ¡£ º¯Êý¹«Ê½½â¾ö£º =WRAPROWS(UNIQUE(SORT(TOCOL(A3:B8)),,1),2 ÔĶÁÈ«ÎÄ
posted @ 2024-06-30 15:21 °¾·ÊÑý ÔĶÁ(1) ÆÀÂÛ(0) ÍƼö(0) ±à¼­
ÕªÒª£º ÎÊÌ⣺һÁÐÖеÄ×î´óÖµ¼õÈ¥²»Îª0µÄ×îСÊý£¨ËùÓÐÊý¾Ý¾ùΪÕýÊý£© º¯Êý¹«Ê½½â¾ö£º =MAX(B4:B7)-MINIFS(B4:B7,B4:B7,">0") Èç¹ûÊý¾ÝÓÐÕýÓиº£¬ÔòÐèÒªÓÃMaxIfs¼õÈ¥MinIfs£¬MaxIfsÓëMinIfsÓ÷¨Ïàͬ¡£ ÔĶÁÈ«ÎÄ
posted @ 2024-06-30 15:16 °¾·ÊÑý ÔĶÁ(1) ÆÀÂÛ(0) ÍƼö(0) ±à¼­
ÕªÒª£º ÎÊÌ⣺a56爆大奖在线娱乐ʱ¼ä£¨**Сʱ**·ÖÖÓ**Ã룩ת³ÉСÊý£¬Ð¡Ê±²¿·ÖΪÕûÊý¡£ º¯Êý¹«Ê½½â¾ö£º ´«Í³Ì×· =SUBSTITUTE(SUBSTITUTE(A2,"С",),"ÖÓ",)*24 ÐÂÌ×· =SUBSTITUTES(A2,{"С","ÖÓ"},)*24 ¸üеÄÌ×·£¨ÕýÔò£© =REGEXP(A2,"[СÖÓ]" ÔĶÁÈ«ÎÄ
posted @ 2024-06-30 15:13 °¾·ÊÑý ÔĶÁ(2) ÆÀÂÛ(0) ÍƼö(0) ±à¼­
ÕªÒª£º ÎÊÌ⣺¸ß¼¶É¸Ñ¡Ö±½ÓÉèÖÃÌõ¼þ£¬µ±Ìõ¼þµÄÊý×Ö³¬¹ý15λʱ»á³öÏÖ´íÎó£¬ÒªÈçºÎ½â¾ö¡£ ½â¾ö£ºÔڸ߼¶É¸Ñ¡Ìõ¼þÖÐÉèÖù«Ê½£¬¹«Ê½ËùÒýÓõ¥Ôª¸ñΪÊý¾ÝÔ´±í±êÌâÐÐϵÚÒ»ÐУ¬¹«Ê½ËùÔÚµ¥Ôª¸ñÉÏÒ»¸öµ¥Ôª¸ñ±ØÐë¿Õ ÔĶÁÈ«ÎÄ
posted @ 2024-06-30 15:08 °¾·ÊÑý ÔĶÁ(1) ÆÀÂÛ(0) ÍƼö(0) ±à¼­
ÕªÒª£º Ö¸¶¨Êý×ÖÒÔÄÚµÄËùÓÐÅÅÁÐ×éºÏ£º ¶¨ÒåÃû³Æ°æ£º =pmtt(Ö¸¶¨Êý×Ö) pmtt=LAMBDA(x,IF(x=1,1,VSTACK(pmtt(x-1),REDUCE(SEQUENCE(x),SEQUENCE(,x-1)^0*x,LAMBDA(a,b,TOCOL(a&SEQUENCE(,b))))))) ÔĶÁÈ«ÎÄ
posted @ 2024-06-27 18:29 °¾·ÊÑý ÔĶÁ(4) ÆÀÂÛ(0) ÍƼö(0) ±à¼­
ÕªÒª£º ÎÊÌ⣺ ÓÉÎÊÌâ+´ð°¸Éú³É½á¹û let Ô´ = Excel.CurrentWorkbook(){[Name="±í1"]}[Content], ½á¹û = Table.AddColumn(Ô´, "½á¹û", each Text.Combine(List.Combine(List.Zip({Text.Spli ÔĶÁÈ«ÎÄ
posted @ 2024-06-22 17:26 °¾·ÊÑý ÔĶÁ(4) ÆÀÂÛ(0) ÍƼö(0) ±à¼­
ÕªÒª£º ÎÊÌ⣺ÅúÁ¿Ñ¡È¡ÏàͬÌî³äÉ«µÄ²»ÏàÁڵĵ¥Ôª¸ñ ²éÕÒ·¨£º ¿ªÊ¼¡·²éÕÒ¡·²éÕÒ¡·Ñ¡Ïî¡·¸ñʽ¡·±³¾°ÑÕÉ«¡·µãÑ¡´ø±³¾°ÑÕÉ«µÄµ¥Ôª¸ñ¡·²éÕÒÈ«²¿¡·Ctrl+A ɸѡ·¨£º ɸѡ¡·ÑÕɫɸѡ ѡȡɸѡ½á¹û¡·¿ªÊ¼¡·²éÕÒ¡·¶¨Î»¡·¿É¼ûµ¥Ôª¸ñ¡·¶¨Î» ÔĶÁÈ«ÎÄ
posted @ 2024-06-22 17:12 °¾·ÊÑý ÔĶÁ(1) ÆÀÂÛ(0) ÍƼö(0) ±à¼­