Copying values
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Copying values

  1. #1
    Guest

    Default

     
    Hello People
    I am just wondering if I have a spreadsheet with the following format
    Test1 11
    Test2 22
    Test3 33
    Test4 33
    Test1 33
    Test2 33
    Test3 11
    Test4 22
    ...
    ...
    Is there a way to create another column and copy the value from Test1 directly to that new column?
    eg.
    11 Test1 11
    Test2 22
    Test3 33
    Test4 33
    33 Test1 33
    Test2 33
    Test3 11
    Test4 22
    Please Help me
    Thank you

  2. #2
    MrExcel MVP Barrie Davidson's Avatar
    Join Date
    Feb 2002
    Location
    Winnipeg
    Posts
    2,330
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    On 2002-03-07 11:56, Anonymous wrote:
    Hello People
    I am just wondering if I have a spreadsheet with the following format
    Test1 11
    Test2 22
    Test3 33
    Test4 33
    Test1 33
    Test2 33
    Test3 11
    Test4 22
    ...
    ...
    Is there a way to create another column and copy the value from Test1 directly to that new column?
    eg.
    11 Test1 11
    Test2 22
    Test3 33
    Test4 33
    33 Test1 33
    Test2 33
    Test3 11
    Test4 22
    Please Help me
    Thank you
    How about inserting a column and using an IF statement to populate that column? So your IF formula would be:

    =IF(B1="Test1",C1,"")

    Would that work for you?
    Barrie Davidson

    "You're only given a little spark of madness. You mustn't lose it." - Robin Williams

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