this must be easy
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 6 of 6

Thread: this must be easy

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    20
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    ....A
    1 joe
    2 dan
    3 mark
    4 jack
    5 bob
    lets say we have a column with these names
    and we want to copy a1 to f1 and a3 to f2 and
    a5 to f3 so f column will look like

    ...F
    1 joe
    2 mark
    3 bob
    is there a way for this

  2. #2
    MrExcel MVP Mark O'Brien's Avatar
    Join Date
    Feb 2002
    Location
    Columbus, OH, USA
    Posts
    3,530
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    What exactly are you trying to do? Take every other name from column A and put them in consecutive rows in column F?

    I'm assuming that column A is larger than just 5 rows of data or else you would just do this manually with the formula in F1 being "=A1" (or whatever cell you want).

  3. #3
    New Member
    Join Date
    Apr 2002
    Posts
    20
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    HELLO
    of course column A is around 9000 rows and i want a formula to copy (for example) cell a1 then cell a3 then cell a5 and so on... to column F but
    to f1,f2,f3,f4 and so on

  4. #4
    New Member
    Join Date
    Apr 2002
    Posts
    20
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    İ JUST WANT TO KNOW İF THİS İS POSSİBLE
    A FORMULA MAYBE?

  5. #5
    MrExcel MVP Mark O'Brien's Avatar
    Join Date
    Feb 2002
    Location
    Columbus, OH, USA
    Posts
    3,530
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Yeah, it's possible.

    Assuming your data is in A1 and you want the other list to start in F1, put this formula in cell F1:

    =OFFSET($A$1,((ROW(F1)*2)-2),0)

    Copy this formula as far down as you need.

  6. #6
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    or, in F1 :

    =INDIRECT("A"&(ROW()*2)-1)

    Copy this formula as far down as you need.


    _________________
    Hope this helps,
    Chris


    [ This Message was edited by: Chris Davison on 2002-04-18 13:33 ]

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com