filter duplicates

  1. G

    Copying data from one column in multiple worksheets

    Hi guys, I'm new to the forum and VBA in general, just started using it a couple of weeks ago and am having trouble trying to write a code for something I am looking to automate. Basically, I need some help with copying data from a few worksheets in a workbook to another worksheet in the same...
  2. J

    Advanced Filter Help - I DARE YOU TO SOLVE THIS ONE!

    Hi guys and girls, sorry for the re-post but I just figured out how to share my file on Windows SkyDrive. https://skydrive.live.com/redir.aspx?cid=4cdbd283ac4cd6f6&resid=4CDBD283AC4CD6F6!102 In the attachment you will find a list of products named "list." The first column is the product...
  3. C

    HELP!! My Job Depends on it!

    :eeek: I have a HUGE spreadsheet that lists every transaction ever done by my company since 2000 (31000+ line items). I have been asked to find out the minimum and maximum price for each part # repaired. Many of them have been repaired more than once and many have a dollar amount of $0.00 which...
  4. F

    how to filter to KEEP duplicate records

    Hi, I have a sorted column. I want to remove all singletons from this list, and keep duplicates (and triplicates, quadruplicates, etc). How can I achieve this? (VBA method is fine - I'm looking for either something already built into Excel, or something efficient if done in VBA) Thanks!

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