• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 247
  • Last Modified:

copy referenced cell and increment by one row

Spreadsheet Div1, column AN, has data in evey other row starting with row 5.  I want to copy the data to another spreadsheet named Place.  In Place, cell E3 I have entered the standard reference formula.

='Div1'!AN5

Is it possible (wihtout using VBA)to copy the reference to the remaining cells in column E incrementing by one row?

Desired results:

Place E3 ='Div1'!AN5
Place E4 ='Div1'!AN7
Place E5 ='Div1'!AN9

and so on.
0
Lindahq
Asked:
Lindahq
  • 2
  • 2
1 Solution
 
Saqib Husain, SyedEngineerCommented:
Try something like

=offset('Div1'!$AN$5,(row()-3)*2,0)

in E3 and then copy down
0
 
LindahqAuthor Commented:
THANK YOU!!!!!!
0
 
LindahqAuthor Commented:
I followed the solution provided and it worked for rows 5 through 25, but the spreadsheet goes to row 57.  After row 25 the result is #N/A.  Why?
0
 
Saqib Husain, SyedEngineerCommented:
Check the spreadsheet and make sure that the numbers are all in odd numbered rows.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now