Hi!

I'm having an issue with a large spreadsheet of raw data I'm using for my dissertation. I'm trying to do some analysis of the data (averages, t-tests, standard deviation etc.) in a second sheet. I create an equation to conduct, for example, a t-test looking at a particular variable, however when I move onto my next calculation, and filter/sort the table so I can see the measurements I want, my previous calculations are changing. I assume this is because the rows are moving around.

Is there any way to fix this? I've had a workaround suggested to me, where I copy the values needed for an equation onto a new sheet before calculating, however this would be quite time consuming since I'm looking at conducting 60-70 equations. Any ideas?

Thanks in advance.