| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Referencing every other line
I have Tab 1 that will reference cells in Tab 2. Tab 1's referencing will be
sequential.....row 1, 2, 3, etc....but I want them to reference rows 1, 3, 5, etc. on Tab 2. Can I copy and paste in Tab 1 where it brings over every other line on Tab2? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Referencing every other line
Try this:
=OFFSET(Sheet2!A1,ROW()-1,0) HTH Elkar "Mark" wrote: I have Tab 1 that will reference cells in Tab 2. Tab 1's referencing will be sequential.....row 1, 2, 3, etc....but I want them to reference rows 1, 3, 5, etc. on Tab 2. Can I copy and paste in Tab 1 where it brings over every other line on Tab2? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Referencing every other line
Try this:
Assuming you want to reference column A on Sheet2. Entered on Sheet1 in cell A1: =INDEX(Sheet2!A:A,ROWS(A$1:A1)*2-2+1) -- Biff Microsoft Excel MVP "Mark" wrote in message ... I have Tab 1 that will reference cells in Tab 2. Tab 1's referencing will be sequential.....row 1, 2, 3, etc....but I want them to reference rows 1, 3, 5, etc. on Tab 2. Can I copy and paste in Tab 1 where it brings over every other line on Tab2? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to convert a dotted line to a solid line in a line graph | Charts and Charting in Excel | |||
| average Line created in an existing line graph- based on one cell | Charts and Charting in Excel | |||
| referencing a different tab by referencing a list in the current s | Excel Worksheet Functions | |||
| Make a line in a bar chart, and change color of any bars that exceed the line | Excel Discussion (Misc queries) | |||
| coloring overy other line without doing so line by line | Excel Worksheet Functions | |||
Linear Mode
