请教各位老师：07版本用不了以下三位老师的公式。有适用07版本的公式吗

z2016 · 发表于 2023-5-15 09:15

本帖最后由 z2016 于 2023-5-15 18:34 编辑

_22(}1$A)TJM8IMA]O(J.png

Book1.rar (9.44 KB, 下载次数: 10)

苏Lang · 发表于 2023-5-15 10:23

复制代码

三键

祝洪忠- · 发表于 2023-5-15 10:35

=TEXTJOIN(",",,TEXT(I3:AD3,"00"),ROW($1:$4)+(COUNT(I3:AD3)>14))

橒♂蝣 · 发表于 2023-5-15 11:17

=IF(COUNT(I3:AD3)>14,TEXTJOIN(" ",1,TEXT(I3:AD3,"00"))&":2,3,4,5;",TEXTJOIN(" ",1,TEXT(I3:AD3,"00"))&":1,2,3,4;")

z2016 · 发表于 2023-5-15 18:36

请老师指教！

z2016 · 发表于 2023-5-15 18:39

谢谢楼上老师指教！

高个子 · 发表于 2023-5-15 18:57

本帖最后由高个子于 2023-5-15 19:04 编辑

https://club.excelhome.net/thread-1650045-1-1.html
07版就下载这位老师的自定义函数，这个问题不用textjoin公式只能像你那么写，很长并且不方便维护。当然，你也可以去VBA版块问。

=IF(I3="","",TEXT(I3," 00"))&IF(J3="","",TEXT(J3," 00"))&IF(K3="","",TEXT(K3," 00"))&IF(L3="","",TEXT(L3," 00"))&IF(M3="","",TEXT(M3," 00"))&IF(N3="","",TEXT(N3," 00"))&IF(O3="","",TEXT(O3," 00"))&IF(P3="","",TEXT(P3," 00"))&IF(Q3="","",TEXT(Q3," 00"))&IF(R3="","",TEXT(R3," 00"))&IF(S3="","",TEXT(S3," 00"))&IF(T3="","",TEXT(T3," 00"))&IF(U3="","",TEXT(U3," 00"))&IF(V3="","",TEXT(V3," 00"))&IF(W3="","",TEXT(W3," 00"))&IF(X3="","",TEXT(X3," 00"))&IF(Y3="","",TEXT(Y3," 00"))&IF(Z3="","",TEXT(Z3," 00"))&IF(AA3="","",TEXT(AA3," 00"))&IF(AB3="","",TEXT(AB3," 00"))&IF(AC3="","",TEXT(AC3," 00"))&IF(AD3="","",TEXT(AD3," 00"))&IF(COUNTIF(I3:AD3,">0")<=14,":1,2,3,4;",":2,3,4,5;")

复制代码

z2016 · 发表于 2023-5-15 20:38

谢谢高个子老师指教！

橒♂蝣 · 发表于 2023-5-15 20:51

升级版本吧老兄，时代在进步

		自动登录	找回密码
密码			免费注册

[已解决] 请教各位老师：07版本用不了以下三位老师的公式。有适用07版本的公式吗