+ Reply to Thread
Results 1 to 14 of 14

Macro to delete duplicate number in ranges columns AP to AY

  1. 12-15-2018, 02:46 AM #1
    oeyandyprawira
    oeyandyprawira is offline
    Forum Contributor
    Join Date
    12-17-2012
    Location
    indonesia
    MS-Off Ver
    Excel 2019
    Posts
    170

    Macro to delete duplicate number in ranges columns AP to AY

    Hi please kindly help is there a macro to delete same number in columns.

    Below is the screenshot of data, yellow highlight is the same number need to be delete because there was already a same number in ranges columns AP to AY
    181215-Before duplicate.JPG

    Below is what it should be after the macro running, thx
    181215-After duplicate.JPG
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 12-15-2018, 03:16 AM #2
    YasserKhalil
    YasserKhalil is offline
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: Macro to delete duplicate number in ranges columns AP to AY

    Have a look at this link
    https://www.excelforum.com/excel-pro...ing-cells.html
    < ----- Please click the little star * next to add reputation if my post helps you
    Visit Forum : From Here
    Reply With QuoteRegister To Reply
  3. 12-15-2018, 03:33 AM #3
    mohan.r1980
    mohan.r1980 is offline
    Valued Forum Contributor mohan.r1980's Avatar
    Join Date
    09-18-2010
    Location
    Mumbai, India
    MS-Off Ver
    Excel 2010 (windows7)
    Posts
    729

    Re: Macro to delete duplicate number in ranges columns AP to AY

    Hi

    try

    Please Login or Register  to view this content.
    Regards,
    MohanS


    "Perfection is not attainable, but if we chase perfection we can catch excellence." - Vince Lombardi

    You can simply say thanks by clicking "*Add Reputation" icon
    Reply With QuoteRegister To Reply
  4. 12-15-2018, 03:54 AM #4
    oeyandyprawira
    oeyandyprawira is offline
    Forum Contributor
    Join Date
    12-17-2012
    Location
    indonesia
    MS-Off Ver
    Excel 2019
    Posts
    170

    Re: Macro to delete duplicate number in ranges columns AP to AY

    Hi Yasser, thx, from that link it will delete for another replicate by rows, for mine I need to delete another replicate on columns
    Reply With QuoteRegister To Reply
  5. 12-15-2018, 03:58 AM #5
    oeyandyprawira
    oeyandyprawira is offline
    Forum Contributor
    Join Date
    12-17-2012
    Location
    indonesia
    MS-Off Ver
    Excel 2019
    Posts
    170

    Re: Macro to delete duplicate number in ranges columns AP to AY

    Hi Mohan , thx , had tried your macro but nothing happen
    Reply With QuoteRegister To Reply
  6. 12-15-2018, 04:05 AM #6
    YasserKhalil
    YasserKhalil is offline
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: Macro to delete duplicate number in ranges columns AP to AY

    Try using this line first
    Please Login or Register  to view this content.
    before this line
    Please Login or Register  to view this content.
    If that doesn't work for you please attach your desired results ..
    Reply With QuoteRegister To Reply
  7. 12-15-2018, 04:16 AM #7
    mohan.r1980
    mohan.r1980 is offline
    Valued Forum Contributor mohan.r1980's Avatar
    Join Date
    09-18-2010
    Location
    Mumbai, India
    MS-Off Ver
    Excel 2010 (windows7)
    Posts
    729

    Re: Macro to delete duplicate number in ranges columns AP to AY

    hi
    try below code

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  8. 12-15-2018, 04:58 AM #8
    jindon
    jindon is offline
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,516

    Re: Macro to delete duplicate number in ranges columns AP to AY 

    Please Login or Register  to view this content.
    Last edited by jindon; 12-15-2018 at 05:03 AM.
    Reply With QuoteRegister To Reply
  9. 12-15-2018, 05:25 AM #9
    oeyandyprawira
    oeyandyprawira is offline
    Forum Contributor
    Join Date
    12-17-2012
    Location
    indonesia
    MS-Off Ver
    Excel 2019
    Posts
    170

    Re: Macro to delete duplicate number in ranges columns AP to AY

    Hi YasserKhalil , it's work , thx
    Reply With QuoteRegister To Reply
  10. 12-15-2018, 05:27 AM #10
    oeyandyprawira
    oeyandyprawira is offline
    Forum Contributor
    Join Date
    12-17-2012
    Location
    indonesia
    MS-Off Ver
    Excel 2019
    Posts
    170

    Re: Macro to delete duplicate number in ranges columns AP to AY

    Perfect Jindon, thx
    Reply With QuoteRegister To Reply
  11. 12-15-2018, 05:30 AM #11
    oeyandyprawira
    oeyandyprawira is offline
    Forum Contributor
    Join Date
    12-17-2012
    Location
    indonesia
    MS-Off Ver
    Excel 2019
    Posts
    170

    Re: Macro to delete duplicate number in ranges columns AP to AY

    Quote Originally Posted by mohan.r1980 View Post
    hi
    try below code

    Please Login or Register  to view this content.
    Hi Mohan , still not right, thx
    fail.JPG
    Reply With QuoteRegister To Reply
  12. 12-15-2018, 05:49 AM #12
    mohan.r1980
    mohan.r1980 is offline
    Valued Forum Contributor mohan.r1980's Avatar
    Join Date
    09-18-2010
    Location
    Mumbai, India
    MS-Off Ver
    Excel 2010 (windows7)
    Posts
    729

    Re: Macro to delete duplicate number in ranges columns AP to AY

    because it has space (i didn't notice it prior) anyway
    after all you got nice solution by Jindon Sir
    Reply With QuoteRegister To Reply
  13. 12-15-2018, 05:57 AM #13
    oeyandyprawira
    oeyandyprawira is offline
    Forum Contributor
    Join Date
    12-17-2012
    Location
    indonesia
    MS-Off Ver
    Excel 2019
    Posts
    170

    Re: Macro to delete duplicate number in ranges columns AP to AY

    yes thx Mohan
    Reply With QuoteRegister To Reply
  14. 12-15-2018, 06:24 AM #14
    mohan.r1980
    mohan.r1980 is offline
    Valued Forum Contributor mohan.r1980's Avatar
    Join Date
    09-18-2010
    Location
    Mumbai, India
    MS-Off Ver
    Excel 2010 (windows7)
    Posts
    729

    Re: Macro to delete duplicate number in ranges columns AP to AY

    Your welcome and thanks for Rep++
    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. macro to delete columns greater than specified number
    By vbahelpme12 in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 03-08-2016, 02:39 PM
  2. Macro add or delete columns by entering number in cell
    By HDMI in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-17-2013, 09:24 AM
  3. Duplicate Named Ranges, how to specify which one to delete
    By treygriffin in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-11-2013, 10:45 AM
  4. VBA macro needed to delete duplicate entries matching across multiple columns
    By chicolocal in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-01-2012, 02:34 PM
  5. Macro To Delete Duplicate Records (Rows), While Omiting Specific Columns
    By Orangeworker in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-09-2010, 12:37 PM
  6. Delete ranges after duplicate is found
    By WhiteKelso in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 12-04-2007, 06:02 PM
  7. Delete Duplicate Ranges in Excel
    By Krishna234 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-27-2007, 10:47 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