求助老师写一下公式

sucx007

1. =AGGREGATE(15,6,1/(1/D3:J3),{1,2,3,4,1})

复制代码

fgq5910

=TAKE(FILTER(D3:J3, D3:J3<>""), 4)
=AGGREGATE(15,6,D3:J3/(D3:J3<>""),1)

ＷＳＣ123

=LET(A,IFERROR(DROP(REDUCE(0,TRIM(BYROW(D3:J11&" ",CONCAT)),LAMBDA(X,Y,VSTACK(X,TEXTSPLIT(Y," ")))),1),999)*1,HSTACK(TAKE(A,,4),"",BYROW(A,MIN)))

jivy1212

1. =AGGREGATE(15,3,1/D3:J3^-1,{1,2,3,4})

复制代码

1. =AGGREGATE(15,3,1/D3:J3^-1,1)

复制代码

朝露孤烟

前4，=TAKE(FILTER(D3:J3,D3:J3<>""),,4)
最小，=MIN(IF(D3:J3<>"",--D3:J3,""))

袁勇

=LET(x,(0&D3:J3)*1,HSTACK(TAKE(FILTER(x,x>0),,4),MIN(IF(x>0,x))))

gwjkkkkk

1. =DROP(REDUCE("",D3:D11,LAMBDA(x,y,LET(a,TAKE(FILTER(--OFFSET(y,,,,7),IFERROR(--OFFSET(y,,,,7),0)),,4),VSTACK(x,HSTACK(a,"",MIN(a)))))),1)

复制代码

quqiyuan

=INDEX($D3:$J3,SMALL(IF($D3:$J3<>"",COLUMN($A$1:$G$1),2^8),COLUMN(A1)))
=MIN(IF(ISNUMBER(0/D3:J3),--D3:J3,9^9))

小希123

l3=--TAKE(TEXTSPLIT(TEXTJOIN(",",TRUE,D3:J3),",",,TRUE),,4)