Increment cells by one

  • Thread starter Thread starter Marc Bachand
  • Start date Start date
M

Marc Bachand

I have cells on sheet1 which are in the following format:

P-100 340626.411 254837.931 298.38 600 SICPP 1 P-100 340627.963
254833.319 298.37 600 SICPP 0
P-101 340657.085 254875.95 298.5 600 SICPP 1 P-101 340626.264
254838.781 298.405 600 SICPP 0
P-102 340647.268 254885.237 300.641 300 SICPP 1 P-102 340657.085
254875.95 300.383 300 SICPP 0


This data has been imported into the spreadsheet from a text file and needs
to be in this format.

When I reorginize the data on sheet2 it looks like this:

P-100 340626.411 254837.931 298.38 600 SICPP 1
P-100 340627.963 254833.319 298.37 600 SICPP 0

P-102 340647.268 254885.237 300.641 300 SICPP 1
P-102 340657.085 254875.95 300.383 300 SICPP 0


Problem is when I try to drag and fill the cells below on sheet2 they
increment by two because I need to highlight the first two rows before
filling the rows below. The formulas fill in as follows:

=Sheet1!A2
=Sheet1!G2
=Sheet1!A4
=Sheet1!G4

Does anyone know a way to get the formulas to look like this:

=Sheet1!A2
=Sheet1!G2
=Sheet1!A3
=Sheet1!G3
 
Hi
try the following in A2 on your sheet 2
=INDIRECT("'sheet1'!" & IF(MOD(ROW(),2)=0,"A" & ROW(),"G" & ROW()-1))
and copy down
 
Back
Top