Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Dragging Across
I am trying to drag information across a row but skip a column inbetween.
for example my data is in columns A1,B1,C1,D1, E1 and i want to be able to put my cursor on a random cell in row 1 and have it bring back cell A1, then a blank cell, then cell B1, then another blank cell, then C1 and a blank, and so on. Everytime I do it, I get A1, then blank then C1, then blank, then E1...and i cant figure it out!! -Yasmeen |
#2
|
|||
|
|||
If you're also starting in column A, then this formula will work:
=IF(MOD(COLUMN(),2)=0,"",INDEX(1:1,(COLUMN()+1)/2)) Bob Umlas Excel MVP "Yasmeen" wrote in message ... I am trying to drag information across a row but skip a column inbetween. for example my data is in columns A1,B1,C1,D1, E1 and i want to be able to put my cursor on a random cell in row 1 and have it bring back cell A1, then a blank cell, then cell B1, then another blank cell, then C1 and a blank, and so on. Everytime I do it, I get A1, then blank then C1, then blank, then E1...and i cant figure it out!! -Yasmeen |
#3
|
|||
|
|||
Bob, thanks for replying. This formula gave me a blank cell but wen I went
to drag next to it, the info in column "C" came up when i'm looking for info in column "B" my spreadsheet looks like this: (Column) A B C D E RED BLUE GREEN YELLOW ORANGE I want it to look like this: RED BLUE GREEN YELLOW ORANGE i'm currently getting: RED GREEN ORANGE Am I using your formula incorrectly? "Bob Umlas" wrote: If you're also starting in column A, then this formula will work: =IF(MOD(COLUMN(),2)=0,"",INDEX(1:1,(COLUMN()+1)/2)) Bob Umlas Excel MVP "Yasmeen" wrote in message ... I am trying to drag information across a row but skip a column inbetween. for example my data is in columns A1,B1,C1,D1, E1 and i want to be able to put my cursor on a random cell in row 1 and have it bring back cell A1, then a blank cell, then cell B1, then another blank cell, then C1 and a blank, and so on. Everytime I do it, I get A1, then blank then C1, then blank, then E1...and i cant figure it out!! -Yasmeen |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to set up reference to allow dragging | New Users to Excel | |||
Dragging formulas | Excel Worksheet Functions | |||
Copy and dragging cells | Excel Worksheet Functions | |||
VLOOKUP dragging down | Excel Worksheet Functions | |||
VLOOKUP dragging down | Excel Worksheet Functions |