How do I...
Posted by Martin Schmidt on November 16, 2000 9:43 AM
Is there a short-hand way of doing the following:
How can I take a column with say 1000 observations and take every 3rd (or any constant) observation and place them consequatively in another column?
for example:
1 3
2 6
3 9
4
5
6
7
8
9
10
Posted by Ben O. on November 16, 2000 10:07 AM
You could create a column that repeats the number sequence 1, 2, 3 all the way down. Then you could apply the autofilter and show only the columns with number 3.
If you copy and paste the filtered list, it will ignore the hidden rows (numbered 1 and 2) and just paste the rows that you want.
-Ben
Posted by Aladin Akyurek on November 16, 2000 2:44 PM
=IF(ISNUMBER(INDIRECT(CONCATENATE("A",ROW(A1)*Nth))),INDIRECT(CONCATENATE("A",ROW(A1)*Nth)),"")
where I assume that the first observation is in A1 and the constant (e.g., your 3th) in some cell named as "Nth" via Name Box. Put the above formula in B1 and copy down as far as needed.
Aladin
