Hi
I would like to know if it possible to
- enter several numerical data in one cell (like in an array: {35, 42, 37, 46})
- and then calculate from another cell the average or standard deviation from these values
Is there any function in Excel97 which do that.
If not, has anybody an idea of a macro which I could use to calculate the average of a cell which contain the example above: {35, 42, 37, 46} .
Would it be preferable to enter the array with "={35, 42, 37, 46}"
Thanks for your help
Emmanuel
I would like to know if it possible to
- enter several numerical data in one cell (like in an array: {35, 42, 37, 46})
- and then calculate from another cell the average or standard deviation from these values
Is there any function in Excel97 which do that.
If not, has anybody an idea of a macro which I could use to calculate the average of a cell which contain the example above: {35, 42, 37, 46} .
Would it be preferable to enter the array with "={35, 42, 37, 46}"
Thanks for your help
Emmanuel