+ Reply to Thread
Results 1 to 11 of 11

Code for Eliminating duplicate rows and re arrange without deleting rows

  1. 08-19-2016, 11:33 AM #1
    pvsvprasad
    pvsvprasad is offline
    Forum Contributor
    Join Date
    12-16-2013
    Location
    World
    MS-Off Ver
    Excel 2007
    Posts
    215

    Question Code for Eliminating duplicate rows and re arrange without deleting rows

    Dear Well wishers,

    My Code is 

    Please Login or Register  to view this content.
    while using my code, printed duplicates instead of single.
    please fix this bug. i have attached sample excel file for actually produced values and required format.

    please find raw data of Text file.


    Thanking you all,
    Best regards.
    Attached Files Attached Files
    Last edited by pvsvprasad; 08-19-2016 at 02:20 PM.
    Reply With QuoteRegister To Reply
  2. 08-19-2016, 01:11 PM #2
    pvsvprasad
    pvsvprasad is offline
    Forum Contributor
    Join Date
    12-16-2013
    Location
    World
    MS-Off Ver
    Excel 2007
    Posts
    215

    Re: Code for Eliminating duplicate rows and re arrange without deleting rows

    Dear all ,

    Kindly fix the above bug.

    Thanking you all,
    Best regards.
    Last edited by pvsvprasad; 08-19-2016 at 01:46 PM.
    Reply With QuoteRegister To Reply
  3. 08-19-2016, 03:13 PM #3
    sanram
    sanram is offline
    Valued Forum Contributor
    Join Date
    06-21-2013
    Location
    Bangladesh
    MS-Off Ver
    Excel 2000, Excel XP, Excel 2002, Excel 2007, Excel 2010, Excel 2013
    Posts
    975

    Re: Code for Eliminating duplicate rows and re arrange without deleting rows

    Actually I don't know much about text file extracting. But you can skip double data with a trick here. Try this:
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  4. 08-20-2016, 04:40 AM #4
    pvsvprasad
    pvsvprasad is offline
    Forum Contributor
    Join Date
    12-16-2013
    Location
    World
    MS-Off Ver
    Excel 2007
    Posts
    215

    Re: Code for Eliminating duplicate rows and re arrange without deleting rows

    THANK YOU VERY MUCH SIR,

    your code is working well.

    Best regards.
    Reply With QuoteRegister To Reply
  5. 08-20-2016, 07:20 AM #5
    sanram
    sanram is offline
    Valued Forum Contributor
    Join Date
    06-21-2013
    Location
    Bangladesh
    MS-Off Ver
    Excel 2000, Excel XP, Excel 2002, Excel 2007, Excel 2010, Excel 2013
    Posts
    975

    Re: Code for Eliminating duplicate rows and re arrange without deleting rows

    You are welcomed.

    Yes, I have tested that it was working. But I have solved the issue with a trick. May be Experts will provide you any perfect solution.
    Reply With QuoteRegister To Reply
  6. 08-20-2016, 07:22 AM #6
    sanram
    sanram is offline
    Valued Forum Contributor
    Join Date
    06-21-2013
    Location
    Bangladesh
    MS-Off Ver
    Excel 2000, Excel XP, Excel 2002, Excel 2007, Excel 2010, Excel 2013
    Posts
    975

    Re: Code for Eliminating duplicate rows and re arrange without deleting rows

    You are welcomed.

    Yes, I have tested that it was working. But I have solved the issue with a trick. May be Experts will provide you any perfect solution.
    Reply With QuoteRegister To Reply
  7. 08-20-2016, 11:32 AM #7
    pvsvprasad
    pvsvprasad is offline
    Forum Contributor
    Join Date
    12-16-2013
    Location
    World
    MS-Off Ver
    Excel 2007
    Posts
    215

    Re: Code for Eliminating duplicate rows and re arrange without deleting rows

    Thank you for your effort.
    Can you add 2 more columns from text file, with your trick?
    Reply With QuoteRegister To Reply
  8. 08-20-2016, 01:03 PM #8
    sanram
    sanram is offline
    Valued Forum Contributor
    Join Date
    06-21-2013
    Location
    Bangladesh
    MS-Off Ver
    Excel 2000, Excel XP, Excel 2002, Excel 2007, Excel 2010, Excel 2013
    Posts
    975

    Re: Code for Eliminating duplicate rows and re arrange without deleting rows

    Which columns?
    Reply With QuoteRegister To Reply
  9. 08-20-2016, 01:10 PM #9
    pvsvprasad
    pvsvprasad is offline
    Forum Contributor
    Join Date
    12-16-2013
    Location
    World
    MS-Off Ver
    Excel 2007
    Posts
    215

    Re: Code for Eliminating duplicate rows and re arrange without deleting rows

    In text file sir,
    need 2 columns in excel from text file. kindly see my other thread named as "Extract specific text from Text file". please solve that issue.those two columns are produced next to you provided #3 code, up to AK Column. extra columns are AL and AM.please make a look.

    Thanking you sir,
    Best regards.
    Reply With QuoteRegister To Reply
  10. 08-21-2016, 01:06 PM #10
    pvsvprasad
    pvsvprasad is offline
    Forum Contributor
    Join Date
    12-16-2013
    Location
    World
    MS-Off Ver
    Excel 2007
    Posts
    215

    Unhappy Re: Code for Eliminating duplicate rows and re arrange without deleting rows

    Quote Originally Posted by sanram View Post
    Actually I don't know much about text file extracting. But you can skip double data with a trick here. Try this:
    [CODE]Sub test()
    Dear sir,
    I am tested one file with your code and found one row is missing.i.e B E A M 2 and B E A M 12 please find text file and output Excel file.

    Kindly fix the bug.

    Thanking you sir,
    Best regards.
    Attached Files Attached Files
    Last edited by pvsvprasad; 08-21-2016 at 01:40 PM.
    Reply With QuoteRegister To Reply
  11. 08-21-2016, 02:42 PM #11
    sanram
    sanram is offline
    Valued Forum Contributor
    Join Date
    06-21-2013
    Location
    Bangladesh
    MS-Off Ver
    Excel 2000, Excel XP, Excel 2002, Excel 2007, Excel 2010, Excel 2013
    Posts
    975

    Re: Code for Eliminating duplicate rows and re arrange without deleting rows

    Quote Originally Posted by pvsvprasad View Post
    Kindly fix the bug.
    I told you before that I don't know much about data extraction from text file. So, it would be better if someone else may help you on that matter. Because my solution may have bug all the time as I don't understand them well.
    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. What's wrong with my deleting duplicate rows code?
    By dalakada in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-11-2016, 03:04 PM
  2. Changing code from deleting rows to cut/paste rows into another sheet and delete blank row
    By kmarshall6576 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-18-2013, 01:54 AM
  3. [SOLVED] I need to delete duplicate values without losing/eliminating the rows they are in.
    By dionnmj1 in forum Excel General
    Replies: 7
    Last Post: 08-24-2012, 11:23 AM
  4. Macro required to delete duplicate rows and arrange numerical sequence
    By domex in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-19-2010, 07:13 AM
  5. Deleting duplicate rows
    By therealjag in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-09-2009, 04:53 AM
  6. Eliminating Duplicate rows in one column
    By philde in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-27-2009, 10:55 AM
  7. Deleting Duplicate rows...VBA Code
    By robkozak in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-24-2008, 03:46 PM

Tags for this Thread

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