+ Reply to Thread
Results 1 to 6 of 6

delete rows contain duplicated data or non duplicated by inputbox

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

    delete rows contain duplicated data or non duplicated by inputbox

    hello
    i have data some of them are duplicated and another non duplicated I would when I write duplicated into inputbox based on column b it gives me message is two choices ok or no if ok deleted if no is ignored and if I delete specific names like asd123 or write more than name like this asd123 & asd124 .. and so on
    Attached Files Attached Files

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

    Re: delete rows contain duplicated data or non duplicated by inputbox

    Maybe use Data validation on B2:Bxx

    Custom
    =COUNTIFS(B$1:B1,B2)=0
    Data Validation.png
    Attached Files Attached Files

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

    Re: delete rows contain duplicated data or non duplicated by inputbox

    Thanks , but you seem misunderstood what I meant if I have duplicated data then should delete by inputbox my data is filled earlier not prevent writing duplicated data

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

    Re: delete rows contain duplicated data or non duplicated by inputbox

    How about this

    Please Login or Register  to view this content.
    Attached Files Attached Files

  5. #5
    Forum Contributor
    Join Date
    01-02-2020
    Location
    Idaho, USA
    MS-Off Ver
    365
    Posts
    103

    Re: delete rows contain duplicated data or non duplicated by inputbox

    Not exactly sure what you want yet, but this code will ask you for a name to delete duplicates of, then delete all of those names except the first one.

    Please Login or Register  to view this content.
    Attached Files Attached Files

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

    Re: delete rows contain duplicated data or non duplicated by inputbox

    well done ! yes it works well 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. Macro shows duplicated entries but sometimes they are not duplicated due to data.
    By tweacle in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-05-2020, 04:47 PM
  2. Delete Duplicated rows
    By lorena.tgarza in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-09-2012, 07:49 PM
  3. How delete rows duplicated???
    By Wilmarjr in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-22-2012, 05:59 PM
  4. Delete both rows if data is duplicated
    By thillis in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-26-2009, 01:46 PM
  5. Delete Duplicated rows
    By lefty55 in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 04-28-2008, 06:25 PM
  6. How can I delete 'fuzzy' duplicated rows?
    By ani_unicorn in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 12-22-2005, 06:40 PM
  7. Delete non duplicated rows
    By cape in forum Excel General
    Replies: 1
    Last Post: 07-07-2005, 10:05 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