|
楼主 |
发表于 2014-9-18 17:45
|
显示全部楼层
baksy 发表于 2014-9-18 15:42
AA1单元格复制以下公式,横拉、下拉;
=IF(INT(LEN(SUBSTITUTE($Z1,",",REPT(" ",99)))/100)
谢谢!请问如果“$C$1:$V$1”变成"$C$1:$IB$1", ”$C$20:$V$20“变成”$C$103:$IB$103 , "Z1"变成“IK1",这个公式应该如何写?,REPT和COLUMN在这里的作用是什么?
=IF(INT(LEN(SUBSTITUTE($Z1,",",REPT(" ",99)))/100)<COLUMN(A1)-1,"",INDEX($C$1:$V$1,MATCH(MIN(TRIM(MID(SUBSTITUTE($Z1,",",REPT(" ",99)),(COLUMN(A1)-1)*100+1,99))),$C$20:$V$20,)))
|
|