# formula help

#### Eis13

##### New Member
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?

### Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a \$25,000 loan, 5% annual interest, 60 month loan.
Try in B1, copied down

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

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.

Doesnt work, some kind of error appears

Working here. You might have to replace , with ;

Excel Workbook
AB
117
2214
33
44
55
66
77
88
99
1010
1111
1212
1313
1414
1515
1616
1717
1818
Sheet1

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

Replies
6
Views
307
Replies
4
Views
709
Replies
0
Views
143
Replies
3
Views
150
Replies
10
Views
281

1,203,218
Messages
6,054,210
Members
444,710
Latest member
napster91192

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back