+ Reply to Thread
Results 1 to 5 of 5

is it possible prevent duplicated data for three column matches?

  1. #1
    Forum Contributor
    Join Date
    06-02-2019
    Location
    libya
    MS-Off Ver
    2010
    Posts
    734

    is it possible prevent duplicated data for three column matches?

    hello
    i'm asking if there is way by code in worksheet change to prevent duplicated data in three columns are matched what I would prevent duplicated after write in column 3 for instance
    I have this data as my sample
    1200R20 G580 THI
    if I repeat data in column a,b and when I repeat also column 3 then show me message and clear the cell until get in a new data
    by the way this simple sample but my real data contain at least 1000 rows
    thanks
    Attached Files Attached Files
    Last edited by ABDELFATTA; 12-02-2020 at 01:32 PM.

  2. #2
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: is it possible prevent duplicated data for three column matches?

    Please try

    Please Login or Register  to view this content.
    or use Custom data validation applies to C2:Cxx

    =COUNTIFS(A:A,A2,B:B,B2,C:C,C2)=1
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    06-02-2019
    Location
    libya
    MS-Off Ver
    2010
    Posts
    734

    Re: is it possible prevent duplicated data for three column matches?

    brilliant ! just one thing when ask me clear yes or no and I choose yes I would clear in column a,b,c not only c

  4. #4
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: is it possible prevent duplicated data for three column matches?

    Try

    Please Login or Register  to view this content.

  5. #5
    Forum Contributor
    Join Date
    06-02-2019
    Location
    libya
    MS-Off Ver
    2010
    Posts
    734

    Re: is it possible prevent duplicated data for three column matches?

    well done ! many thanks

+ 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] delete rows contain duplicated data or non duplicated by inputbox
    By ABDELFATTA in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-25-2020, 04:01 PM
  2. [SOLVED] Using Index/Small to return multiple, non-duplicated matches
    By Brawnystaff in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-08-2017, 03:42 PM
  3. Index matched array with duplicated matches, help needed!
    By hbuzz in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-08-2016, 09:45 AM
  4. [SOLVED] VBA Macro to prevent unsorted duplicated row
    By amuk in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-20-2016, 04:16 AM
  5. Replies: 1
    Last Post: 07-20-2015, 10:58 AM
  6. Replies: 3
    Last Post: 01-19-2014, 12:27 PM
  7. How to prevent data in an excel file from being copied, printed or duplicated?
    By greentea2 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-03-2010, 01:44 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