Hi All,
I am working with some long lists of test data. Is there any way I can average the 10 maximum and 10 minimum values automatically? At the moment I am having to go through the lists and pick them out myself.
Also, is there a way I can automatically split the data into blocks and average them? For example, if I have 100 entries, is it possible to average the first 10 entries, the second 10 entries... and so on so that I have 10 values?
As always, any help is greatly appreciated.
Thanks.
I am working with some long lists of test data. Is there any way I can average the 10 maximum and 10 minimum values automatically? At the moment I am having to go through the lists and pick them out myself.
Also, is there a way I can automatically split the data into blocks and average them? For example, if I have 100 entries, is it possible to average the first 10 entries, the second 10 entries... and so on so that I have 10 values?
As always, any help is greatly appreciated.
Thanks.
Last edited: