remove duplicate rows

  1. R

    Dynamic "Columns:=Array(1,2,3)" in RemoveDuplicates excel VBA

    I am new to VBA. Currently I am using this, lastColumn is last column of worksheet. lastRow is last row of worksheet. It is working fine for: ActiveSheet.Range(Cells(1,1), Cells (lastRow,lastColumn)). RemoveDuplicates(Columns:=Array(1,2,3), Headers:=xlNo) - But it will work only for 3 columns...
  2. A

    Removing conditional duplicate rows using comparative data from multiple columns

    Hi experts I am new to vba and looking for a way to modify data in a large file (extract below) as explained below. <tbody> Record ref Date created Type Stage Status Department Client Cost Price AAM000001 01/04/2015 APP Closed - Funded Application v1 - Approved CEEEE FUN00023 487,993.00...
  3. S

    Delete duplicates of one column based on multiple criteria to keep the oldest entry

    Hi, I am new to the forum and decently new to VBA so if this is an easy solution or there are other answers available sorry in advance. I have a fairly large workbook that serves as a sort of action list that is built from user input on a separate sheet. There is the possibility that someone...
  4. S

    Remove Duplicate (Sort of) Row based on => Value in another Cell

    I need to add this to a Macro I am working on and this one is beating me right now. Any help is much appreciated. These are columns B,C,D and E in my spreadsheet. What I am trying to accomplish is if there is a duplicate value in column "B" to evaluate the numbers in column "E". If the numbers...
  5. Z

    Problem with removing duplicates

    Hi, I have a large data worksheet. I want to remove duplicates from it but problem is found that duplicates everything but category are different. if I un-select category colum from function remove duplicates it will deleted all duplicates which are different category ? worksheet link...
  6. V

    Comparing Multiple Sheets and Removing Existing Rows

    Greetings, I attempted a search but could not find any issues similar to mine. For my job, I am trying to keep track of the number of issues and have created a pivot table to show by type, state, etc. which works fine. I copy+paste the data directly from a log (from a company program) into...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top