C
cj21
I have a huge dataset from which i have created some descriptive
statistics e.g mean, mode, sd, var, skewness (5 columns). These
descriptive statistics themselves create a dataset of about 90 rows * 5
columns. Therefore 450 cells have a formula which creates a value drawn
from the original dataset.
I want to copy column 1-the mean (90 rows), to another spreadsheet. To
present it in a nice table. However when i copy then paste it, it takes
the formulas as well which takes a long time to load. Is it possible
just to take a snap shot of the mean column and paste its raw data
(without the formulas) to the new spreadsheet?
Chris
statistics e.g mean, mode, sd, var, skewness (5 columns). These
descriptive statistics themselves create a dataset of about 90 rows * 5
columns. Therefore 450 cells have a formula which creates a value drawn
from the original dataset.
I want to copy column 1-the mean (90 rows), to another spreadsheet. To
present it in a nice table. However when i copy then paste it, it takes
the formulas as well which takes a long time to load. Is it possible
just to take a snap shot of the mean column and paste its raw data
(without the formulas) to the new spreadsheet?
Chris