+ Reply to Thread
Results 1 to 2 of 2

Copy data from one column to another based off certin critera

  1. #1
    Registered User
    Join Date
    02-25-2009
    Location
    Philadelphia, PA
    MS-Off Ver
    Excel 2007
    Posts
    4

    Copy data from one column to another based off certin critera

    Here's what i am trying to accomplish...

    In column A i have a list of about 2000 accounts each that contain multiple email addresses. In column C i have blank spaces to move my new codes to. In column D i have the same list of individual accounts only without any duplicates and in column E i have the actual codes i need to copy over.

    I had to generate a unique code for each account so I copied all the accounts out to a new column (D), removed duplicates generated codes for each account and pasted the results next to the individual account (E).

    Here's where the problem comes in i'm trying to copy the codes to from Column E to Column C only if the data in Column A matches whats next to that code in Column E.
    For example...

    A B C D E
    Account1 [email protected] Code1 Account1 Code1
    Account2 [email protected] Code1 Account2 Code1
    Account3 [email protected] Code3 Account3 Code3
    Account4 ][email protected] Code4 Account4 Code4
    Account 5 [email protected] Code5 Account 5 Code5
    Account6 [email protected] Code6 Account6 Code6
    Account6 [email protected] FALSE Account7 Code7
    Account6 [email protected] FALSE Account8 Code8
    Account7 [email protected] FALSE Account9 Code9
    Account7 [email protected] FALSE Account10 Code10
    Account7 [email protected] FALSE Account11 Code11

    I attempted to use the following formula...

    =if(A2=D2,E)
    now it will go down as far as the last line that matches directly across from it, but anything like that just says FALSE...

  2. #2
    Forum Contributor GuruWannaB's Avatar
    Join Date
    01-24-2008
    Location
    An hour due East of Cowtown Ohio
    MS-Off Ver
    2010
    Posts
    421

    Re: Copy data from one column to another based off certin critera

    thats because an IF statement has a =if(criteria, TRUE, FALSE) setup. Your formulat didn't indicate what to do if the criteria was false...so it simply put FALSE.

    Try modifying to this...

    =if(a2=d2,e2,"")

    This will leave a blank if A1 and D1 don't have the same data
    I help because of the Pavlovian dog that resides in the inner me...so if you are happy with the results, please add to my reputation. It helps keep me motivated!



    Please mark your threads as Solved once it is solved. Check the FAQ's to see how.

+ 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