[FONT="]I have performed a study using qualtrics, collected all the results but realized after I had started that I needed some data I hadn't downloaded in the first place. So I downloaded the data from qualtrics in .csv-file, opened it in excel and was to merge the matrix from my previously downloaded data (in which I have had no problems in excel) and the new data-file. I figured the easiest way was to have the two matrix' in its own sheet and have a third sheet where I use a simple =matrix1A1+matrix2A2-formula. But when I do so I get #value! in the sum matrix.[/FONT]
[FONT="]I have tried a lot of different options:[/FONT]
[FONT="]Thanks for any tips available!
View attachment Matrix sum problems.xlsxView attachment Matrix sum problems.xlsx[/FONT]
[FONT="]I have tried a lot of different options:[/FONT]
- Formating the data as numbers
- =if(istext(A1);"";A1) and =if(istext(A1);0;A1)
- Paste special
- And so on
[FONT="]Thanks for any tips available!
View attachment Matrix sum problems.xlsxView attachment Matrix sum problems.xlsx[/FONT]