正常公式IFERROR(SMALL(IF(COUNTIF($A1:$U1,ROW($1:$10)-1)=0,ROW($1:$10)-1),COL

Question

正常公式IFERROR(SMALL(IF(COUNTIF($A1:$U1,ROW($1:$10)-1)=0,ROW($1:$10)-1),COLUMN(A1)),"")改成IFERROR(SMALL(IF(COUNTIF($CM4:$CS4,$CE4:$CK4),IF($CE4:$CK4="","",$CE4:$CK4)),COLUMN(CE4)),"")为什么不能用

Answer 1

COLUMN(CE4)改为COLUMN(A4)
=IFERROR(SMALL(IF(COUNTIF($CM4:$CS4,$CE4:$CK4),IF($CE4:$CK4="","",$CE4:$CK4)),COLUMN(A4)),"")