二座標移動後 最後值 (14957)

H2:I3=MID(SUBSTITUTE(VLOOKUP($G2,$B:$D,3,),",",REPT(" ",9)),(H$1=$I$1)*9+1,9)+SUMPRODUCT(MMULT(N($C$4:$C$21="Move"&{"Right","Left","Up","Down"}),IF(H$1=$H$1,{1;-1;0;0},{0;0;1;-1}))*($B$4:$B$21=$G2)*$D$4:$D$21)



留言