Results 1 to 5 of 5

Deleting duplicate rows

Threaded View

  1. #1
    Registered User
    Join Date
    03-21-2007
    Posts
    13

    Deleting duplicate rows

    Hi,

    I have an excel sheet, that - post data-cleaning - has multiple rows. For example:

    A B C D E F
    Ohio 1020 Paul
    Ohio 1020 Paul
    New York 1110 Virginia
    Ohio 1020 Paul
    Ohio 1020 Paul

    Which Should ideally look like


    A B C D E F
    Ohio 1020 Paul
    New York 1110 Virginia

    All those entries for Ohio are duplicates, and I want only one row for Ohio. I have simplified the excel to understand the approach I must take - actual excel sheet has around 15/20 columns for now.

    Ideally this would be a function/procedure that I can call from multiple subroutines (at the end of data-cleaning). Tried searching for online examples and other posts in the forum, after my attempts at this fell flat on my face (I even successfully managed to delete *all* rows in the sheet, without any recovery possible, after the cleaning subroutine took 45 mins to run. Brilliant.

    Attaching a sample work sheet to illustrate. Is this even possible? Thanks..
    Attached Files Attached Files
    Last edited by Upparna; 01-31-2012 at 06:30 PM. Reason: The grammar

Thread Information

Users Browsing this Thread

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

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