+ Reply to Thread
Results 1 to 3 of 3

Removing rows with duplicates

  1. #1
    Registered User
    Join Date
    10-10-2014
    Location
    Norway
    MS-Off Ver
    2010
    Posts
    3

    Removing rows with duplicates

    I have a table where I want to remove the rows that have duplicated values (in a spesific column). When I test the remove-duplicates function on that column alone it works, but not when I mark the entire table. When I do that and cross off the column I want to base the removal on, it can't find any duplicates. I have made sure there are duplicates there by using COUNTIF and also checked that the cells have the right formate (general). Does anyone have any idea of what is wrong?

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,603

    Re: Removing rows with duplicates

    The remove duplicates will only work if the entire row is duplicated.Different techniques are documented at this place

  3. #3
    Registered User
    Join Date
    10-10-2014
    Location
    Norway
    MS-Off Ver
    2010
    Posts
    3

    Re: Removing rows with duplicates

    Okay! Thank you Pepe Le Mokko!

+ 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. Replies: 7
    Last Post: 10-12-2012, 10:26 PM
  2. Difficult: Removing duplicates between 2 sheets, or copying Unique rows.
    By RonaldRS in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-02-2012, 09:03 AM
  3. Replies: 6
    Last Post: 03-29-2012, 12:16 AM
  4. Removing Duplicates
    By drob59233 in forum Excel General
    Replies: 1
    Last Post: 10-25-2011, 06:44 PM
  5. Removing rows based on duplicates?
    By spyrule in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-26-2007, 03:20 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1