猜 取工作表 1 问题一 S3{=IFERROR(SMALL(IF(COUNTIF('1'!3:5,ROW(1:30))=LOOKUP(1,0/$S1:S1,$S1:S1),ROW(1:30)),COLUMN(A1)-LOOKUP(1,0/($S1:S1<>""),COLUMN($A:A))+1),"")
问题一 BF3{=IFERROR(SMALL(IF(COUNTIF($S3:$BE3,ROW(1:30))=0,ROW(1:30)),COLUMN(A1)),"")
问题二{=IFERROR(INDEX(3:3,SMALL(IF($S3:BL3<>"",COLUMN($S:BL)),COLUMN(A1))),"") |