Efficient Copying Problem
Posted by Yasmin Thomas on November 26, 2001 11:40 AM
I have a very big worksheet with about 2000 lines. In every 20th line is a value that i want to work with. I have to calculate the deviation of these values, but because i cant give excel the formula =dev(b10:b2000) (there are other values between the interesting ones) it would be =dev(b10;b30;b50;b70...) with 100 arguments and excel cant take this.
Is there an easy way to gather the values of each 20th cell in a tight new area on the worksheet?
Tank you in advance!