Dragging Forumla to equal column

[jfrey]

Hello,

I'm in cell B4 and make it equal D21, when i drag to B5 i want it to equal D22. I've always know it will equal the next column unless you use an absolute reference, but is there a way to make it equal the row below and still be in the same column ? From example above when I drap from B4 to B5, B5 would = D22.

I've attached she worksheet i'm working in. I had to manuall hit = and click on the correct cell.

Any help would be nice.

Thanks,

JR

[jeffreybrown]

If you are going from B4 to B5, click on B4 and using the fill handle drag down. B5 will now =D22

[jfrey]

I'm sorry i meant to say dragging from B4 to C4 and i want the cell to =D21 in B4 and =D22 in C4.

[jeffreybrown]

Highlight B4:C4 and enter =Transpose(D21:D22)

IMPORTANT
This is an array formula
Enter the formula >> press F2 then >> CTRL + SHIFT + ENTER
If entered correctly, the formula will be enclosed in {brackets}
Do not enter the {brackets} manually

[ConneXionLost]

In cell B4 try:

Please Login or Register  to view this content.

Cheers,

[jfrey]

Thanks guys! the array forumla worked. This will definatly help me with a lot of the excel spreadsheet I make.