+ Reply to Thread
Results 1 to 7 of 7

IF cell is duplicate

  1. #1
    Registered User
    Join Date
    10-17-2015
    Location
    Kosovo
    MS-Off Ver
    MS
    Posts
    58

    IF cell is duplicate

    Hello to All,
    Is possible to pup up text on cell so on which cell is duplicate Add.JPG so if cell I15 match number on cells from B2:B501 pup up text or show up which cells is duplicate on cell M15 so this case B2 to show up at M15 cell.
    Attached Files Attached Files

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    48,337

    Re: IF cell is duplicate

    Not possible with formulas, but probably do-able with VBA

    Another option, possible with formulas, would be to have an adjacent cell show a message, instead?
    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

  3. #3
    Forum Contributor saravnepali's Avatar
    Join Date
    01-14-2019
    Location
    Nepal
    MS-Off Ver
    2010
    Posts
    169

    Re: IF cell is duplicate

    IF you want to determine the cell that is duplicate OR NOT, its achievable EVEN WITHOUT VBA.
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    See attached if this help

    Advise if you needed something else
    Attached Files Attached Files
    Last edited by saravnepali; 11-28-2019 at 06:30 AM.
    If helpful reward by clicking on star bottom left.

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Northern Ireland
    MS-Off Ver
    Excel 2013 & 2016
    Posts
    23,777

    Re: IF cell is duplicate

    Saravnepali, that's rather nice!!

    A tweak to return the cell address:

    =IFERROR(ADDRESS(IF(COUNTIF(B2:B58,D14)>1,MATCH(D14,B2:B58,0),"")+1,2,4),"")


    Bixha, you may need to use ; instead of ,
    Last edited by Glenn Kennedy; 11-28-2019 at 07:26 AM.
    Glenn



  5. #5
    Forum Contributor saravnepali's Avatar
    Join Date
    01-14-2019
    Location
    Nepal
    MS-Off Ver
    2010
    Posts
    169

    Re: IF cell is duplicate

    Glenn,
    Agree with you if you need the proper cell address.

    I tried to get to cell as I prefer to use it as it can be easily refrenced to offsets etc.
    Last edited by AliGW; 12-01-2019 at 07:52 AM. Reason: Please don't quote unnecessarily!

  6. #6
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    48,337

    Re: IF cell is duplicate

    Quote Originally Posted by saravnepali View Post
    IF you want to determine the cell that is duplicate OR NOT, its achievable EVEN WITHOUT VBA.
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    See attached if this help

    Advise if you needed something else
    I stand corrected, well done

  7. #7
    Forum Contributor saravnepali's Avatar
    Join Date
    01-14-2019
    Location
    Nepal
    MS-Off Ver
    2010
    Posts
    169

    Re: IF cell is duplicate

    Please mark the thread as SOLVED, if this solves your problem.

    Also, you can click on the star if you wish if you think someone helped you.
    Last edited by AliGW; 12-01-2019 at 07:54 AM. Reason: Edited so that rep request does not appear to be a requirement.

+ 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