+ Reply to Thread
Results 1 to 6 of 6

Matching cell values to check for duplicates or not

  1. 08-05-2018, 10:44 PM #1
    farm58
    farm58 is offline
    Registered User
    Join Date
    02-15-2018
    Location
    Springfield, mo
    MS-Off Ver
    MO
    Posts
    11

    Matching cell values to check for duplicates or not

    I used an index match function to match similar ID values from data file 2 to data file 1.
    Can someone show me another method to report what ID value in Data file 1 is or is not in Data file 2 and vice versa.
    I've looked at countif and vlookup but have not got the result i am looking for. Just trying to do this another way.

    Thanks
    Attached Images Attached Images
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 08-05-2018, 10:51 PM #2
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,939

    Re: Matching cell values to check for duplicates or not

    Would this work for you?
    C2=IF(ISNUMBER(MATCH(B2,$B$18:$B$36,0)), "found", "not Found")
    copied down
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    Reply With QuoteRegister To Reply
  3. 08-05-2018, 11:14 PM #3
    farm58
    farm58 is offline
    Registered User
    Join Date
    02-15-2018
    Location
    Springfield, mo
    MS-Off Ver
    MO
    Posts
    11

    Re: Matching cell values to check for duplicates or not

    yes, that works also, thank you.
    Can this problem be done with countif or vlookup?
    Reply With QuoteRegister To Reply
  4. 08-05-2018, 11:24 PM #4
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,939

    Re: Matching cell values to check for duplicates or not

    Sure...
    =IF(ISERROR(VLOOKUP(B2,$B$18:$B$36,1,0)),"not found","found")
    and
    =IF(COUNTIF($B$18:$B$36,B2),"found","not found")
    Reply With QuoteRegister To Reply
  5. 08-06-2018, 07:35 AM #5
    farm58
    farm58 is offline
    Registered User
    Join Date
    02-15-2018
    Location
    Springfield, mo
    MS-Off Ver
    MO
    Posts
    11

    Re: Matching cell values to check for duplicates or not

    Both of these work perfectly. Thank you very much!
    Reply With QuoteRegister To Reply
  6. 08-06-2018, 03:53 PM #6
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,939

    Re: Matching cell values to check for duplicates or not

    Thanks for the feedback
    Reply With QuoteRegister To Reply
+ Reply to Thread
« 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. [SOLVED] Align Duplicates Or Matching Values In Two Columns With VBA Code
    By webiscore in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-29-2017, 12:01 PM
  2. check for duplicates with different values in another column
    By stephme55 in forum Excel General
    Replies: 2
    Last Post: 11-09-2016, 09:08 PM
  3. [SOLVED] using IF formula to check 2 colomns for same values (not duplicates)
    By Thorwald77 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-24-2016, 10:38 AM
  4. Matching values in two columns - one column has duplicates
    By morganz in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-08-2015, 10:38 AM
  5. Macro to check for blank cell entry, copy previous value, and check for duplicates
    By xPunxNotDeadx in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-26-2009, 06:33 PM
  6. matching values in columns that contain duplicates
    By jellybean in forum Excel General
    Replies: 8
    Last Post: 08-14-2006, 09:20 PM
  7. check for duplicates, then sum unique values
    By Weissme in forum Excel General
    Replies: 0
    Last Post: 08-09-2006, 11:35 AM

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