+ Reply to Thread
Results 1 to 15 of 15

Remove Duplicates from Rows

  1. #1
    Forum Contributor
    Join Date
    09-05-2009
    Location
    Tokyo, Japan
    MS-Off Ver
    Excel 2016
    Posts
    131

    Remove Duplicates from Rows

    I have a big sheet A1 - BQ 1064 with words in each cell.
    I need to remove duplicates in the individual rows (because they often repeat in the every column)
    Please consider, I have no knowledge of VBA / Macros, so explain it the most simple way.

    Thank you.

    dwc

  2. #2
    Valued Forum Contributor
    Join Date
    02-09-2012
    Location
    Mauritius
    MS-Off Ver
    Excel 2007
    Posts
    1,055

    Re: Remove Duplicates from Rows

    Hi,

    Post a sample file.
    Click *, if my suggestion helps you. Have a good day!!

  3. #3
    Forum Contributor
    Join Date
    09-05-2009
    Location
    Tokyo, Japan
    MS-Off Ver
    Excel 2016
    Posts
    131

    Re: Remove Duplicates from Rows

    Well just words in a row from A1 to BQ1, and it happen, that the words repeat sometimes, so they should be removed

  4. #4
    Valued Forum Contributor
    Join Date
    02-09-2012
    Location
    Mauritius
    MS-Off Ver
    Excel 2007
    Posts
    1,055

    Re: Remove Duplicates from Rows

    Try this:

    removeduplicates.xlsm
    Attached Files Attached Files
    Last edited by jraj1106; 02-19-2013 at 03:38 AM.

  5. #5
    Forum Contributor
    Join Date
    09-05-2009
    Location
    Tokyo, Japan
    MS-Off Ver
    Excel 2016
    Posts
    131

    Re: Remove Duplicates from Rows

    hmm.. it says unreadable content.

  6. #6
    Forum Contributor
    Join Date
    09-05-2009
    Location
    Tokyo, Japan
    MS-Off Ver
    Excel 2016
    Posts
    131

    Re: Remove Duplicates from Rows

    would you have any idea, why I can not read the macros from your file?
    The Macro settings are : Enable all Macros.

  7. #7
    Forum Contributor
    Join Date
    09-05-2009
    Location
    Tokyo, Japan
    MS-Off Ver
    Excel 2016
    Posts
    131

    Re: Remove Duplicates from Rows

    I was finally figuring out, why it did not run... the VBA seem to be not enabled.
    Got to run it now. Wow! this is great!
    But... I am very new to Macros; it works in the first row, but how will I make it run all the 1640 rows?

    Sorry for such a beginners question!

  8. #8
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,376

    Re: Remove Duplicates from Rows

    Hi dwc
    try it
    Please Login or Register  to view this content.

  9. #9
    Forum Contributor
    Join Date
    09-05-2009
    Location
    Tokyo, Japan
    MS-Off Ver
    Excel 2016
    Posts
    131

    Re: Remove Duplicates from Rows

    Thank you nilem, but I am at a total loss.... do I have to select thev range I want the duplicates removed?
    I pasted your formula in and run it as macro, but don't see any removal

  10. #10
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,376

    Re: Remove Duplicates from Rows

    Please attach your example in the file

  11. #11
    Forum Contributor
    Join Date
    09-05-2009
    Location
    Tokyo, Japan
    MS-Off Ver
    Excel 2016
    Posts
    131

    Re: Remove Duplicates from Rows

    this is only a small sample.
    The rows go down to 1640 and columns up to BQ
    Attached Files Attached Files

  12. #12
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,376

    Re: Remove Duplicates from Rows

    Here's your macro file. Press Alt+F8, select "ertert" and Run.
    For example, the second line is removed repeated word "Skyline".
    Do you want to delete duplicates in rows or columns?
    You just want to clear the duplicate cells or delete them?
    It would be better if you could set an example (about 5-10 lines) with the desired result.
    Attached Files Attached Files

  13. #13
    Forum Contributor
    Join Date
    09-05-2009
    Location
    Tokyo, Japan
    MS-Off Ver
    Excel 2016
    Posts
    131

    Re: Remove Duplicates from Rows

    Yes, the duplicates should be removed. Not sure, if the empty cell then can be removed as well?
    If not, I have to trim all single cells into 1 cell.
    I was communicating with somebody in the Philippines and I got following result.
    Only problem, the words need to be separated by a coma.

    I just tried your xlsm.... WOW!
    Attached Files Attached Files

  14. #14
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,376

    Re: Remove Duplicates from Rows

    Well, if I understand correctly, then so (click green arrow in the file)
    Attached Files Attached Files

  15. #15
    Forum Contributor
    Join Date
    09-05-2009
    Location
    Tokyo, Japan
    MS-Off Ver
    Excel 2016
    Posts
    131

    Re: Remove Duplicates from Rows

    WOW!! This is great!! But.. the words need to be separated with a coma at the end. (Maybe could also include it in the Macro after the words start with upper case, I need 1 more cell, where all words start with lower case. I think, the function is called =LOWER.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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