duplicate row deletion

  1. S

    Sum if Cell matches another on different sheet, but only keep one row to continuous tally sum

    Hello- I am making a service trackers for hours earned by students. I have it set to sum their hours as they enter them, however, it creates a duplicate line with the total every time they submit a new entry. What do I need to add to my formula so that once a student is on the total sheet, it...
  2. L

    Remove duplicate rows macro

    Hello All, I work at a test lab and i have over 500,000 test records. I need to remove the duplicate record rows. The file has this layout. A patient can have multiple test and on rare cases have a different case number. <tbody> Case Number Patient Name Test Patient ID 1011 John Smith...
  3. V

    How to remove entire rows with one specific matching cell.

    i AM A high school student. In this excel document there is list of 100000 doctors. With their unique registeration number in a cell. Like this <tbody> Doc1 1234 adhh rnier Doc2 5678 dscu dcwofn Doc3 9012 ijwo dnw Doc1 1234 fne oeirfj </tbody> Here entire row is not duplicate But the...
  4. K

    Multiple List Clear

    I have a list on sheet3 that is generated by a user and a list on sheet2 that is automatically provided. What I would like to have happen is when when a macro is run on sheet3 it goes down the list (could be variable in length) item by item and clears any identical values in sheet2. For...
  5. E

    Delete Duplicate Rows Excel

    Is there a way to use excel to remove duplicate repeating rows where one column=another column that is not in the same row? Example Date Team1 Team2 3/7/08 tigers wildcats 3/8/08 tigers broncos 3/9/08 tigers mustangs 3/7/08 wildcats tigers 3/8/08 wildcats mavericks 3/9/08 wildcats broncos The...
  6. P

    Macro or Script to delete ROW based on duplicate phone number

    Say I have a large CSV file of addresses with phone numbers, and some records might be duplicates. If I sort by the phone number; the duplicate records will appear in sequence... is there a way to HIGHLIGHT or MARK those particular rows for me to visually look at and decide which to delete or...

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