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.
I have tried a lot of different options:
Formating the data as numbers
=if(istext(A1);"";A1) and =if(istext(A1);0;A1)
Paste special
And so on
I attached the file here so a helpful soul can have a look at the problem.
Thanks for any tips available!
Link to file: xxxxx. fm / u / eakjzqqd where xxxx is files
Bookmarks