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
Please find attached excel sheet for diagonal matrix by formula.
Regards,
Suhas
Hi thanks,
Can you explain what are the cells for me to put in row() and column().
I have a straight vertical line of data
I have attached what i understand, if you need something different then please attache your sheet with expected results.
Regards,
Suhas
Attached file is the example. I have about 500 lines of data in real.
Try
=IFERROR(INDEX($C$7:$C$9,ROW(A1)*(ROW(A1)=COLUMN(A1)))*(1-INDEX($C$7:$C$9,ROW(A1)*(ROW(A1)=COLUMN(A1)))),0)
Life's a spreadsheet, Excel!
Say thanks, Click *
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks