Hi,
I have a range of cells (A1 to F10) with numbers in them.
In cell A12 I put =A1 and it returns whatever is in cell A1.
I would then like to drag the formula across into B12, C12, D12. It would return the contents of C1, E1, G1 into B12, C12, D12.
So essentially it returns the contents of every 2nd column.
Anyone know how to do this?
Last edited by D_N_L; 10-16-2012 at 07:42 AM.
try
=INDEX(C1:G1, 2*COLUMN(A1)-1)
Last edited by zbor; 10-16-2012 at 06:17 AM.
Hi Zbor,
That works like a charm! Only thing is when I apply it to my worksheet (where the range is different) it fails to work. My range in my worksheet is E481:X489. I use the same principles as what to reference in the formula but I receive an error.
I'm assuming some part of your formula is hard-coded so to speak?
I assume you didn't start from A column in your new range:
=INDEX($E$481:$X$489, 2*COLUMN(A1)-1)
or
=INDEX($E$481:$X$489, 2*COLUMNS($E481:E481)-1)
No, the specific range I am using is E481:X489 and the cell i'm entering data into is E495. I tried your two examples above but both returned a REF error.
I'll need to use the formula in other worksheets, that have dirfferent ranges so I was hoping to apply the principles of how your formula works to them. I guess i'm missing something...
i didn't notice at the first time but your range is not in one row $E$481:$X$481:
=INDEX($E$481:$X$481, 2*COLUMN(A1)-1)
Thank you zbor. Very kind. Works great!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks