Subsidium Business Analytics http://subsidiumba.com/articles3 Just another WordPress weblog Sun, 06 Jun 2010 16:01:35 +0000 http://wordpress.org/?v=2.9.2 en hourly 1 Removing Duplicate Rows in Excel http://feedproxy.google.com/~r/SubsidiumBA/~3/U35YOmwkEpY/ http://subsidiumba.com/articles3/?p=17#comments Sun, 06 Jun 2010 15:52:40 +0000 admin http://subsidiumba.com/articles3/?p=17 advanced in the sort and [...]]]> Removing duplicate rows in Excel (de-duping) is sometimes a necessity, We offer an add-in to help accomplish this task at the click of a button, or you can use the method below:

  • Select all the data that you would like to test for duplicates
  • Go to Data=>Filter=>Advanced Filter (Pre 2007) or Data Tab=>advanced in the sort and filter section of the ribbon (2007 and later)
  • Select the “unique records only” check box, then OK
  • Right click highlighted area and choose copy
  • Paste into another location.


    • The pasted results will only include unique rows of data from your original data set.

    Alternatively you can download our Duplicate Deleter. It speeds up removing duplicates drastically.

    Subsidium Team

    ]]>     http://subsidiumba.com/articles3/?feed=rss2&p=17 0 http://subsidiumba.com/articles3/?p=17     Installing Subsidium Add-Ins http://feedproxy.google.com/~r/SubsidiumBA/~3/Rt-6q3eX1Qc/ http://subsidiumba.com/articles3/?p=5#comments Sat, 05 Jun 2010 05:00:18 +0000 admin http://subsidiumba.com/articles3/?p=5 Subsidium Add-ins are easy to integrate into Excel. Follow the steps below for installation:

    Excel Version 97-2003

    1. Save the add in to a location on you computer you will remember
    2. From within Excel, go to the tools menu=>add-ins
    3. Choose “browse”, and go to the location of your add in.
    4. Select the add-in and choose “OK”
    5. The add in should now appear in the “Add ins available” box with a check by it
    6. Click “OK”
    7. The Add in is now installed and ready to use. Subsidium add-ins will appear as an item typically below the menu

    Excel Version 2007

    1. Save the add in to a location on you computer you will remember
    2. From within Excel, select the Office button (Upper left hand corner)=>Excel Options (bottom)=>Add-Ins
    3. Select “Excel Add-Ins” in the Manage box and Choose “Go”
    4. Select “Browse” and go to the add-in, in the location you saved it.
    5. Select the add-in and choose “OK”
    6. The add in should now appear in the “Add ins available” box with a check by it
    7. Click “OK”
    8. The Add in is now installed and ready to use. Subsidium add-ins will typically  appear as an item under the “Add-Ins” menu header above the ribbon.
    ]]>     http://subsidiumba.com/articles3/?feed=rss2&p=5 0 http://subsidiumba.com/articles3/?p=5