第1个回答 2022-05-06
COSH–上˜下—（–˅ˆ：…220‚39∼22„）=OFFSET(Sheet2!$C$2,MOD(COLUMN(D:D),4)+ROW(1:1)*4-4,)=LOOKUP(1,0/((Sheet1!$A$1:$A$17=$I$2)*(Sheet1!$B$1:$B$17=J1)),Sheet1!$C$1:$C$17)2（Sheet2） =VLOOKUP($A4,INDIRECT("CLYS0"&ROW(A1)&"!$A$2:$D$3"),3,FALSE)=TEXT(MIN(LOOKUP(C4:D4,{"","",""},--{"14:00","08:00","10:00"})),"hh:mm")&"-"&TEXT(MAX(LOOKUP(C4:D4,{"","",""},--{"22:00","18:00","18:00"})),"hh:mm") =COUNTIF(V2:AL2,">"&AM2) AM2 =SUMPRODUCT(A1:A4,ROW(1:4)) =IFERROR(IF(A2="","",IF(VLOOKUP(A2,Sheet2!A:B,2,0)=B2,"","")),"") =LOOKUP(L2,1:121,AN2:FD2)