Announcement

Collapse
No announcement yet.

Dragging Formula Across Row Returns Column Values

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Dragging Formula Across Row Returns Column Values



    Column 1 has roughly 20 rows of information. Cell C1 has the formula =A1.

    Is there a formula so that when I drag C1 horizontally into D1, E1, F1, ..., the values placed in each cell will be =A2, =A3, =A4, ...

    I do not want to transpose the values from column 1 into C1, D1,.... I want these cells to have a formula that links them up to column 1's values

    Thanks
    Last edited by oldman33; September 22nd, 2011, 09:15.

  • #2


    Re: Dragging Formula Across Row Returns Column Values

    Place this formula in C1 and drag across
    =INDEX($A$1:$A$20,COLUMNS($C1:C1))
    Hope that helps
    Regards
    Anthony

    ​​​You have your way. I have my way. As for the right way, the correct way, and the only way, it does not exist.



    Comment

    Working...
    X