| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Offset every 27th row in a column that is 2 cells wide (merged cel
I am trying to move values from one worksheet to another using the OFFSET
function. The worksheet I am pulling from has data on every 27th row and the cells are 2 columns wide (the cells are merged i.e. A1:B1). This is the formula I used: =OFFSET('Elem Bnchmrk'!$B$17:$C$17,ROW()*27-1,0) Please help! -- KS |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Offset every 27th row in a column that is 2 cells wide (merged cel
Try this instead in the starting cell:
=OFFSET('Elem Bnchmrk'!$A$17,ROWS($1:1)*27-27,) Copy down -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "KS" wrote: I am trying to move values from one worksheet to another using the OFFSET function. The worksheet I am pulling from has data on every 27th row and the cells are 2 columns wide (the cells are merged i.e. A1:B1). This is the formula I used: =OFFSET('Elem Bnchmrk'!$B$17:$C$17,ROW()*27-1,0) Please help! -- KS |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Offset every 27th row in a column that is 2 cells wide (merged cel
Hi
One way =INDEX('Elem Benchmark'!$A:$A,(ROW(A1)-1)*27) Copy down as far as required -- Regards Roger Govier "KS" wrote in message ... I am trying to move values from one worksheet to another using the OFFSET function. The worksheet I am pulling from has data on every 27th row and the cells are 2 columns wide (the cells are merged i.e. A1:B1). This is the formula I used: =OFFSET('Elem Bnchmrk'!$B$17:$C$17,ROW()*27-1,0) Please help! -- KS |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Offset every 27th row in a column that is 2 cells wide (merged
Thank you for your help! I finally got it to work. I've been reading help
files and these discussion groups for a couple of days trying to get it to work! -- KS "Roger Govier" wrote: Hi One way =INDEX('Elem Benchmark'!$A:$A,(ROW(A1)-1)*27) Copy down as far as required -- Regards Roger Govier "KS" wrote in message ... I am trying to move values from one worksheet to another using the OFFSET function. The worksheet I am pulling from has data on every 27th row and the cells are 2 columns wide (the cells are merged i.e. A1:B1). This is the formula I used: =OFFSET('Elem Bnchmrk'!$B$17:$C$17,ROW()*27-1,0) Please help! -- KS |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Offset every 27th row in a column that is 2 cells wide (merged
You didn't manage to get the OFFSET option to work, huh?
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Autofit Merged cell Code is changing the format of my merged cells | Excel Discussion (Misc queries) | |||
| How do I make the 1st column constant in viewing a wide spreadshee | Excel Worksheet Functions | |||
| Copying a column of single cells into a column of merged cells | Excel Discussion (Misc queries) | |||
| how do i link merged cells to a merged cell in another worksheet. | Excel Worksheet Functions | |||
| Sorting merged cellsHow do I sort merged cells not identically siz | Excel Worksheet Functions | |||
Hybrid Mode
