+ 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 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    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
    Valued Forum Contributor saravnepali's Avatar
    Join Date
    01-14-2019
    Location
    Sydney Australia
    MS-Off Ver
    2010
    Posts
    447

    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 you think someone helped you, click on the "* Add Reputation" as a way to say thank you.

    If your problem is solved, go to Thread Tools and select Mark This Thread Solved

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    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




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  5. #5
    Valued Forum Contributor saravnepali's Avatar
    Join Date
    01-14-2019
    Location
    Sydney Australia
    MS-Off Ver
    2010
    Posts
    447

    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 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    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
    Valued Forum Contributor saravnepali's Avatar
    Join Date
    01-14-2019
    Location
    Sydney Australia
    MS-Off Ver
    2010
    Posts
    447

    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)

Similar Threads

  1. Replies: 5
    Last Post: 01-21-2018, 07:33 PM
  2. Replies: 3
    Last Post: 01-19-2018, 01:56 PM
  3. [SOLVED] Code to check cell against a list for duplicate, if no duplicate, post to bottom of list..
    By wannabacat in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-28-2015, 11:42 AM
  4. Replies: 1
    Last Post: 06-01-2013, 01:27 AM
  5. [SOLVED] Delete rows based on duplicate cell, but leaving first and last duplicate.
    By LadyNicole in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-28-2013, 05:07 AM
  6. Replies: 5
    Last Post: 08-10-2012, 04:32 PM
  7. Replies: 1
    Last Post: 01-26-2012, 10:06 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1