| 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 |
| 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 | |||
Threaded Mode
