Basically it boils down to this:
Is there some easy way to fill out column B referencing column A, but only incrementing by 1 row in A every 2 cells in B?
Example:
Column A:
A1 = 1
A2 = 2
A3 = 3
etc...
Column B (I would like to fill this, referencing column A):
B1 = A1
B2 empty
B3 = A2
B4 empty
B5 = A3
etc
Last edited by nogit; 02-01-2010 at 06:18 PM.
Welcome to the forum.
In B1, =INDEX(A:A, 2 * ROW() - 1)
Then select B1 AND (empty cell) B2, and drag the fill handle down.
Last edited by shg; 02-01-2010 at 05:44 PM.
Entia non sunt multiplicanda sine necessitate
In B1: =A1
in B2: =IF(MOD(ROW(),2)=0,"",INDEX(A:A,COUNT($B$1:B1)+1)) copied down.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Thanks everyone,
SHG, that doesnt quite work but if I change it to
In B1, =INDEX(A:A,ROW()/2+1) it does
Thanks a bunch
Good catch, sorry.that doesnt quite work but
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks