Results 1 to 3 of 3

Thread: vertical linking of cells

  1. #1

    Question vertical linking of cells



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello Everyone.!
    is there any method to make verical linking of cells..?
    Not getting my point??
    Ok.. Here is an example
    A1=m
    A2=n
    A3=o
    A4=p
    .....onwards....
    if i put value of
    B1 to ---> "=A1" ,, indirectly saying "m"
    and
    of C1 to ---> "=A2",, indirectly saying "n"
    Then can i use any method by which it automaticaly takes value of the next cells? i.e. D1 = "=A3" , E1 = "=A4" , and onwards??
    Last edited by vinay; 2011-10-25 at 08:09 PM.

  2. #2
    Seeker jpr73's Avatar
    Join Date
    Apr 2011
    Location
    France
    Posts
    15
    Articles
    0
    Hay,
    You have 2 possibility :
    - Copy the data, select the cell where you want the first data, Paste Special then Transpose
    - By formula, select the first cell where you want the first data, select in horizontal the same number of vertical cell, wrote the formula =TRANSPOSE(A1:A4) and valid by Ctrl+Shift+Enter (Array Formula result {=TRANSPOSE(A1:A4)})
    You can also put your data in a table and the formula will be =TRANSPOSE(Table name) and also valid as an array formula
    Best regards

  3. #3
    Super Moderator JoePublic's Avatar
    Join Date
    Sep 2011
    Location
    Askew
    Posts
    170
    Articles
    0
    One easy way is to enter zzA1 in B1 and zzA2 in C1, select both cells then drag across as far as you want. Now replace (Ctrl+H) zz with =
    Alternatively, IN b1:
    =INDEX($A:$A,column()-1)
    and copy across.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •