Results 1 to 3 of 3

When first pair are matched, copy entry beside the column to another column

Threaded View

  1. 05-22-2015, 11:04 AM #1
    seanryano
    seanryano is offline
    Registered User
    Join Date
    05-22-2015
    Location
    Dublin
    MS-Off Ver
    2010
    Posts
    2

    When first pair are matched, copy entry beside the column to another column

    Hi,

    I have attached a excel example.

    In the excel sheet, I want each id of D to match the first entry of that in B. Once the first is matched, I want the value of A to be put in E

    So in the example attached this would be the result below

    Column D Column E
    1988470 AABlgaABgAAACDtAE9
    1988471 AABlgaABgAAACDtAE+
    1988472 AABlgaAAGAAAR7qAD4
    1988473 AABlgaAAGAAAR7qAD9
    2019607 AABlgaAAGAAAR7qAD+
    2019608 AABlgaAAGAAAR7qAD/
    2019609 AABlgaAAGAAAR7qAEA
    2185250 AABlgaAAGAAAR7qAEB

    I would be grateful if someone could help me here.

    Ryan
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. File Open and Search column from A1:CE1. If matched than copy entire row for that column.
    By shivanisachdeva167 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-05-2014, 01:51 PM
  2. Copy/Paste filtered data from one sheet to another with only matched column headings
    By archerrc in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-08-2013, 05:00 PM
  3. [SOLVED] Compare 2 pair of columns then copy value of third column over different sheets
    By a3des in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-13-2012, 09:11 AM
  4. Compare an alphanumeric cell with column and copy data from the matched adjacent value
    By fondofexcel in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-31-2012, 12:05 AM
  5. [SOLVED] How can i have all alike product codes in column A be matched with like cities in column B and then add the totals that are in column C
    By genesisoxygen@gmail.com in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-01-2006, 08:15 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1