|
|
|
|
#1
04-08-2015, 07:38 AM
|
|||
|
|||
Please Help!!!
I've been trying for a couple days now and just couldn't get it to work. I need help to create a formula to drag it across Row 1 to (infinite). I need D1=B2, E1=B3, F1=B4, G1=B5, and so on.... As shown in the attached photo. Anyone's help would be greatly appreciated! 
|
|
#2
04-08-2015, 09:34 AM
|
||||
|
||||
|
Perhaps=INDEX($$B2:$B$100,column()-3) Drag right as needed
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
|
|
| Tags |
| excel 2010 |
|
|
Please Help!!!
Windows 7 64bit 
Office 2010 64bit
Hybrid Mode