+ Reply to Thread
Results 1 to 3 of 3

Transferring data from one column to another automatically?

  1. #1
    Registered User
    Join Date
    07-02-2013
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    1

    Transferring data from one column to another automatically?

    Column A and B are going to continuously be updated. I need to create a formula that 1) searches columns C and D for the contents of Column A and B for each specific row e.g. I need it to search for A2 and B2 as a combination (not search the columns individually) and 2) copy any data entered in Col A and B to Col C and D if the data isn't found in C and D. If the data is found nothing needs to be done.


    Thanks

  2. #2
    Forum Contributor
    Join Date
    08-11-2004
    Posts
    109

    Re: Transferring data from one column to another automatically?

    Attach some sample data. Also attached the expected result.

  3. #3
    Registered User
    Join Date
    11-14-2012
    Location
    Derby, England
    MS-Off Ver
    Excel 2013
    Posts
    32

    Re: Transferring data from one column to another automatically?

    I'm not clear if the data in C or D is supposed to be A&B concatenated or just A or B... but one of the below should work for you:

    =IF(A2&B2=C2&D2,"",A2&B2)

    or

    =IF(OR(A2&B2=C2,A2&B2=D2),"",A2&B2)
    If somebody helps you, say thanks, by clicking *

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1