Hye,


The diagonal matrix that I want should be something like this.

10000
02000
00300
00040
00005

However it become like this (having repeated value)

10000
02000
02300
00040
00045

Im using this array formula IF(A8:A18=TRANSPOSE(A8:A18),A8:A18,0)

Please help me, thanks