deduplicate macro

  1. D

    Macro to Dedupe Raw Data From two or More Pivot Tables

    Hi there, I've created a spreadsheet that consists of 2 pivot tables that drilldown into 2 individual lists of customer reference numbers based on the individual pivot table report filters. Due to the report filters selected some customer references numbers can be duplicated in either pivot...
  2. R


    I know this has been visited before... Excel 2003 macro: I routinely extract a LOT of information that requires deduplication. I get tired of walking through the same steps every time so I recorded them. Sub DeDuplicate() Range("A1").Select Range("A1:C1103").AdvancedFilter...

Some videos you may like

This Week's Hot Topics