本帖最后由 dim麻辣君 于 2022-1-22 14:28 编辑
- =TEXT(SUM(INT(MID(SMALL(IF((N(+A$1:A27)<INT(A$2:A28-1))+(A$2:A28<INT(A$3:A29-1)),A$2:A28,A$28),ROW()*2-{3,2})+{0,1},3,9))*{1000,1}),"k4!0+0-k4!0+000")
复制代码 长长的火车先给个
- =TEXT(SUM(INT(SMALL(IF(N(+A$1:A27)<INT(A$2:A28-1),IF({1,0},A$1:A27,A$2:A28),A$28),ROW()*2-{3,2})+{0,1})*10^{5,0}),"k00+000-k00+000")
复制代码
第二题:
- =TEXTJOIN("-",,AGGREGATE({15,14},,IF(MMULT(N(N(4/1%%+MID(D2,{5,13},3)-A$2:A28>0)={0,1}),{1;1})=2,B$2:B28),1))
复制代码 第二题低版:- =SUBSTITUTE(TEXT(SUM(AGGREGATE({15,14},,IF(MMULT(N(N(4/1%%+MID(D2,{5,13},3)-A$2:A28>0)={0,1}),{1;1})=2,B$2:B28),1)*10^{6,2}),"0!.00-00!.00"),"-0","-")
复制代码
|