reference while skipping rows


G

Guest

What is the easiest way to fill down referenced data from a column so that
the data skips rows? Loads to do and spread unevenly around various sheets.
e.g.
A1: 5
A2: 10
A3: 15

goes to

A1: 5
A2:
A3: 10
A4:
A5: 15
Cheers

M
 
Ad

Advertisements

R

RagDyeR

In A1 enter 5,
In A3 enter 10,
Then select A1:A4

Click on the fill handle of the 4 cell selection, and drag down to copy as
needed.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


What is the easiest way to fill down referenced data from a column so that
the data skips rows? Loads to do and spread unevenly around various sheets.
e.g.
A1: 5
A2: 10
A3: 15

goes to

A1: 5
A2:
A3: 10
A4:
A5: 15
Cheers

M
 
G

Guest

sorry, wasn't clear
cells A1, A3, A5 etc are refering to other data spread around the worksheet
in columns
e.g.. A1, A3, A5 contain
=B1, =B2, =B3
(5, 10, 15 was just an example)
 
Ad

Advertisements

B

Bob Umlas

=IF(MOD(ROW(),2)=0,"",INDEX(A:A,(ROW()+1)/2))

Bob Umlas
Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top