said by aurgathor:I have some .csv data, containing 10 colums and lots of rows whose number can vary from 10k to several hundred k.
What I would like to do is get average, median, and stdev for every, say, 5000 rows, and append it to the end, and save the data as .xls.
I just did it by hand -- doable, but it's rather tedious and time consuming. How can I do this automatically?
TIA
with a vbscript or macro (same thing) - record macro next time you do it by hand, and that will give you a great start on a script.