在N3输入数组公式:
=IF(MIN(IF(($A1:$K1<>"")*($B2:$L2<>""),COLUMN($B:$L),COLUMN($M:$M)))=13,"",IF(COLUMN(A1)<9-MIN(IF(($A1:$K1<>"")*($B2:$L2<>""),COLUMN($B:$L),COLUMN($M:$M))),"",INDEX(3:3,MIN(13,COLUMN(A1)-(8-MIN(IF(($A1:$K1<>"")*($B2:$L2<>""),COLUMN($B:$L),COLUMN($M:$M))))))&""))
向右向下复制公式。
原数1.rar
(68.68 KB, 下载次数: 4)
|