| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to reference every second row
Glad it worked, thanks for posting back.
Regards Martin "Neville Bailey" wrote in message ... "MartinW" wrote: Hi Neville, You dont say what your formula is but this may be of some help. This formula placed in Sheet2 and dragged down will return every second value from column A in Sheet1. =OFFSET(Sheet1!A$1,(ROWS($1:1)-1)*2,,) HTH Martin "Neville Bailey" wrote in message ... I have created a formula to reference a cell in another workbook. I now want to copy the formula down a number of consecutive rows, but I want it to reference the cell in every second row in the other workbook. How can I do that? Brilliant! Thanks MartinW, it works like a charm! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reference formula | Excel Discussion (Misc queries) | |||
| Using an offset formula for the reference in a relative reference | Excel Worksheet Functions | |||
| How do I reference the value of a cell within a formula? | Excel Worksheet Functions | |||
| Look Up Reference Formula | Excel Discussion (Misc queries) | |||
| Is it Possible in a formula to have a formula for cell reference? | Excel Worksheet Functions | |||
Threaded Mode
