formula help

[Eis13]

Hi to all
I am new to the site, and I would really need your help in the creation of a formula.
Here is the situation:
I have thousand of values in column A, what i need to do is grab the A7 value
and paste it to B1,
then the A14 value to B2
the A21 value to B3 etc etc
is there a way to do this using a formula?
thnx in advance

 

[VoG]

Try in B1, copied down

=INDEX(A:A,ROW()*7)

 

[jasonb75]

Welcome to the board!

Try entering

=INDEX(A:A,ROWS(B$1:B1)*7

In B1, then fill it donw the rest of the column as required.

 

[Eis13]

Doesnt work, some kind of error appears

 

[VoG]

Working here. You might have to replace , with ;

Excel Workbook
	A	B
1	1	7
2	2	14
3	3
4	4
5	5
6	6
7	7
8	8
9	9
10	10
11	11
12	12
13	13
14	14
15	15
16	16
17	17
18	18
Sheet1

 

[Eis13]

Yeap the ; did it.
worrks fine now.
Thanks a lot.