公式合并

chenwenke

=IFERROR(INDIRECT(TEXT(MIN(IF((I$5:I$66="节假日")*(B$5:H$66>"")*(COUNTIF(K$3:K4,B$5:H$66)=0),ROW($5:$66)/1%+COLUMN(B:H))),"!r0c00"),),"")
=IFERROR(INDIRECT(TEXT(MIN(IF((J$5:J$66="节假")*(B$5:H$66>"")*(COUNTIF(X$3:X4,B$5:H$66)=0),ROW($5:$66)/1%+COLUMN(B:H))),"!r0c00"),),"")
两组公式合并

hcm19522

I8{=IFERROR(INDIRECT(TEXT(MIN(IF((MMULT(N($E$8:$F$27<>""),{1;6})=COLUMN(A1))*($B$8:$D$27>"")*(COUNTIF(I$5:I7,$B$8:$D$27)=0),ROW($8:$27)/1%+COLUMN($B:$D))),"!r0c00"),),"")

I8複製到N8 下拉