数组公式
AA13
- =IFERROR(INDEX($B$1:$AB$1,MAX(IF(OFFSET($A$2,MATCH($Z13,$A$3:$A$9,0),1,,30)>0,COLUMN(A:AB),-1))),"无")
复制代码
AB13
- =IFERROR(OFFSET($A$2,MATCH($Z13,$A$3:$A$9,0),MAX(IF(OFFSET($A$2,MATCH($Z13,$A$3:$A$9,0),1,,30)>0,COLUMN(A:AB),-1))),"无")
复制代码
AF13
- =IFERROR(INDEX($B$1:$AB$1,SMALL(IF(OFFSET($A$2,MATCH($AE$13,$A$3:$A$9,0),1,,30)>0,COLUMN(A:AB),4^8),ROW(1:1))),"无")
复制代码
AG13
- =IFERROR(INDEX($B$2:$AB$2,SMALL(IF(OFFSET($A$2,MATCH($AE$13,$A$3:$A$9,0),1,,30)>0,COLUMN(A:AB),4^8),ROW(1:1))),"无")
复制代码
AH13
- =IFERROR(OFFSET($A$2,MATCH($AE$13,$A$3:$A$9,0),SMALL(IF(OFFSET($A$2,MATCH($AE$13,$A$3:$A$9,0),1,,30)>0,COLUMN(A:AB),4^8),ROW(1:1))),"无")
复制代码
下拉,拉,拉 |