Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Ben Hur
 
Posts: n/a
Default Incrementing formula by two rows

Hi,

This should be a simple question, but I can't get to the bottom of it.
I have imported a text file, but the data for every record is spread
over two rows. I need to extract data from every second row, i.e.:

=MID('Sheet2'!$A1,2,1)

However, I want to drag down so that the next formula reads:

=MID('Sheet2'!$A3,2,1)

I've been trying (and failing) to use the offset command for this.
The only other criteria is that I don't want to use a helper column if
possible as the resulting data will be automatically loaded onto a
system and I don't want to risk forgetting to delete the helper
column!

Thanks.
BH
  #2   Report Post  
Steve
 
Posts: n/a
Default

Have your tried a combination of Row and Indirect:

=MID(INDIRECT("Sheet2!A"& ROUNDUP(ROW()*2-1,0)),2,1)


"Ben Hur" wrote in message
...
Hi,

This should be a simple question, but I can't get to the bottom of it.
I have imported a text file, but the data for every record is spread
over two rows. I need to extract data from every second row, i.e.:

=MID('Sheet2'!$A1,2,1)

However, I want to drag down so that the next formula reads:

=MID('Sheet2'!$A3,2,1)

I've been trying (and failing) to use the offset command for this.
The only other criteria is that I don't want to use a helper column if
possible as the resulting data will be automatically loaded onto a
system and I don't want to risk forgetting to delete the helper
column!

Thanks.
BH



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Automatically 'incrementing' formulas for new rows. MediaScribe New Users to Excel 3 February 21st 05 06:29 PM
Formula to compare multiple rows values based on another column? Murph Excel Worksheet Functions 4 February 21st 05 02:44 AM
How do you copy a formula without incrementing some constants? JohnT Excel Worksheet Functions 2 February 18th 05 11:09 AM
incrementing formula reference by 7 Patti Excel Discussion (Misc queries) 2 January 20th 05 08:23 PM
How get the rows indicated by one formula to become the input for. katgolightly Excel Worksheet Functions 5 December 29th 04 12:01 AM


All times are GMT +1. The time now is 02:44 AM.

Powered by vBulletin® Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"