4X4 matrix for example =CELL("address",INDEX($A$1:$C$4,MAX(($A$1:$C$4=D1)*ROW($A$1:$C$4))-ROW($A$1: $C$4)+1,MAX(($A$1:$C$4=D1)*COLUMN($A$1:$C$4))-COLUMN($A$1:$C$4)+1)) which must be entered using control+shift+enter.
【在 s******g 的大作中提到】 : 4X4 matrix for example : =CELL("address",INDEX($A$1:$C$4,MAX(($A$1:$C$4=D1)*ROW($A$1:$C$4))-ROW($A$1: : $C$4)+1,MAX(($A$1:$C$4=D1)*COLUMN($A$1:$C$4))-COLUMN($A$1:$C$4)+1)) : which must be entered using control+shift+enter.
【在 s******g 的大作中提到】 : 4X4 matrix for example : =CELL("address",INDEX($A$1:$C$4,MAX(($A$1:$C$4=D1)*ROW($A$1:$C$4))-ROW($A$1: : $C$4)+1,MAX(($A$1:$C$4=D1)*COLUMN($A$1:$C$4))-COLUMN($A$1:$C$4)+1)) : which must be entered using control+shift+enter.