ShawnStorm
New Member
- Joined
- Jul 16, 2022
- Messages
- 5
- Office Version
- 365
- Platform
- Windows
Good day,
I am trying to create a diagonal matrix from a column data set. I saw this formula online but its not working. Any help would be appreciated. {=IF(A1:A900=TRANSPOSE(A1:A900),A1:A900,"0")}
I am trying to create a diagonal matrix from a column data set. I saw this formula online but its not working. Any help would be appreciated. {=IF(A1:A900=TRANSPOSE(A1:A900),A1:A900,"0")}