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 |
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 |
All times are GMT +1. The time now is 03:44 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com