+ Reply to Thread
Results 1 to 7 of 7

RemoveDuplicates if too many columns exist

  1. 09-20-2014, 10:32 PM #1
    HerryMarkowitz
    HerryMarkowitz is offline
    Forum Contributor HerryMarkowitz's Avatar
    Join Date
    09-10-2012
    Location
    Europe
    MS-Off Ver
    Office 2021 - Win10
    Posts
    1,014

    RemoveDuplicates if too many columns exist

    Greetings,
    I want to remove duplicates rows based on A column but didnt succeeded.
    1- Open Book1 file.
    2- Run Macro1.
    Please Login or Register  to view this content.
    3- After running Macro1 you will see that remove duplicates job is not ok. (Because it removes only A column duplicates but not entitled rows)

    Need your assistance...

    Note: I want result showed in the Book2.
    Last edited by HerryMarkowitz; 09-20-2014 at 10:40 PM. 
    Sub DontForgetThese()
     If Your thread includes any code Then Please use code tags...
     If Your thread has been solved Then Please mark as solved...
     If Anybody has helped to you Then Please add reputation...
End Sub
    Reply With QuoteRegister To Reply
  2. 09-20-2014, 11:16 PM #2
    xladept
    xladept is offline
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: RemoveDuplicates if too many columns exist 

    Please Login or Register  to view this content.
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
    Reply With QuoteRegister To Reply
  3. 09-20-2014, 11:19 PM #3
    sktneer
    sktneer is offline
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,655

    Re: RemoveDuplicates if too many columns exist

    You may try this.....
    Please Login or Register  to view this content.
    Regards
    sktneer

    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.
    Reply With QuoteRegister To Reply
  4. 09-20-2014, 11:23 PM #4
    alansidman
    alansidman is offline
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 insider Version 2505 Win 11
    Posts
    24,754

    Re: RemoveDuplicates if too many columns exist

    Here is code I have been using for many years to remove rows of data where duplicates are in a particular column

    Please Login or Register  to view this content.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
    Reply With QuoteRegister To Reply
  5. 09-20-2014, 11:26 PM #5
    sktneer
    sktneer is offline
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,655

    Re: RemoveDuplicates if too many columns exist

    Or you can use the code of xladept like this also.....
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  6. 09-20-2014, 11:31 PM #6
    Vikas_Gautam
    Vikas_Gautam is offline
    Forum Expert Vikas_Gautam's Avatar
    Join Date
    06-04-2013
    Location
    Ludhiana,Punjab, India
    MS-Off Ver
    Excel 2013
    Posts
    1,850

    Re: RemoveDuplicates if too many columns exist

    This done it...
    Please Login or Register  to view this content.
    Check the attached file....
    Attached Files Attached Files
    Regards,
    Vikas Gautam
    Excel-buzz.blogspot.com
    Excel is not a matter of Experience, its a matter of Application.
    Say Thanks, Click * Add Reputation
    Reply With QuoteRegister To Reply
  7. 09-21-2014, 10:15 AM #7
    Vikas_Gautam
    Vikas_Gautam is offline
    Forum Expert Vikas_Gautam's Avatar
    Join Date
    06-04-2013
    Location
    Ludhiana,Punjab, India
    MS-Off Ver
    Excel 2013
    Posts
    1,850

    Re: RemoveDuplicates if too many columns exist

    You are always welcome...
    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. VBA Removeduplicates?
    By Chiezo in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-01-2014, 11:30 AM
  2. [SOLVED] Help with RemoveDuplicates
    By 0mgman in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-27-2012, 06:04 AM
  3. [SOLVED] Concatenate if already exist in Columns...
    By edvavi in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-13-2012, 12:21 PM
  4. RemoveDuplicates in VBA
    By j_Southern in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 11-25-2011, 11:13 AM
  5. Determine if columns exist
    By strippy in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 04-19-2011, 09: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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1