+ Reply to Thread
Results 1 to 3 of 3

Need help with making duplicates in Column A show up in Column B with data from C

  1. #1
    Registered User
    Join Date
    10-27-2015
    Location
    Hong Kong, China
    MS-Off Ver
    2010
    Posts
    1

    Need help with making duplicates in Column A show up in Column B with data from C

    I've recently started working at a job where data input takes up most of my intern's day and I wish to make their lives (and my own) easier. I'm trying to build a new spreadsheet where duplicates (phone numbers and/or e-mails) that were entered before in previous entries would be automatically detected and the Ref Code show up in another column. English is not my first language and what I've said is a little confusing, so I've attached a screenshot of the set up I have now and what I'm trying to do (highlighted in red in the pic) below:

    \1

    If anyone can help me, I would be very grateful.
    Attached Images Attached Images

  2. #2
    Forum Expert azumi's Avatar
    Join Date
    12-10-2012
    Location
    YK, Indonesia
    MS-Off Ver
    Excel 2019
    Posts
    2,360

    Re: Need help with making duplicates in Column A show up in Column B with data from C

    for better explanation try to upload your sample workbook not an image, click "Go Advanced" button and find paperclip image button to atach the file

    cheers

  3. #3
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: Need help with making duplicates in Column A show up in Column B with data from C

    Try these formulas in this small sample. Excel file is also attached.

    Row\Col
    A
    B
    C
    D
    E
    F
    1
    Ref Code E-mail Phone number Ref Code check email Ref Code check phone
    2
    A [email protected] +852 123-4567
    1
    1
    In D2 :=IF(COUNTIF(B$2:B2,B2)>1,"Ref code: "&INDEX($A$2:$A$5,MATCH(B2,B$2:B$5,0)),COUNTIF(B$2:B2,B2))
    3
    B [email protected] +852 2244-4554
    1
    1
    In E2 :=IF(COUNTIF(C$2:C2,C2)>1,"Ref code: "&INDEX($A$2:$A$5,MATCH(C2,C$2:C$5,0)),COUNTIF(C$2:C2,C2))
    4
    C [email protected] +852 123-4567 Ref code: A Ref code: A
    5
    D [email protected] +852 3344-4554
    1
    1
    Dave

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] only show data if other column has a figure, otherwise show zero.
    By jitterbug888 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-05-2015, 11:28 PM
  2. Replies: 8
    Last Post: 02-13-2014, 11:30 AM
  3. Find duplicates in one column & add data from another column to duplicate-free sheet
    By ingiabouzeid in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-09-2013, 03:37 AM
  4. [SOLVED] Find duplicates in column A, add values from column B (possibly delete duplicates)
    By luarwhite in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-12-2013, 04:34 PM
  5. Add Date in Column A Plus Number of Days in Column B and show result in Column C
    By excelforumcrisis in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-12-2013, 02:01 PM
  6. Making a second column from data in first column
    By sek0910 in forum Excel General
    Replies: 2
    Last Post: 05-28-2006, 10:40 AM
  7. [SOLVED] Matching one column against another column of data to show the same amount of data.
    By dodat in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 12-30-2005, 02:20 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1