Remove Custom Styles

The following are the basics of using Duplicates Remover Macro


The Duplicates Remover macro finds duplicate entries within a column and copies the duplicate items to another Worksheet. This macro is useful when trying to filter on only unique items. All rows with unique entries and the first row of any duplicate will be copied to a 'unique' Worksheet. Any rows containing duplicate entries will copied to a 'duplicates' Worksheet.

graphic

Workbook: Select the Workbook containing the Worksheet to check.
Worksheet: Select the Worksheet to check.
Duplicates Column: Click the selection box, then navigate to the Worksheet to be checked and click on either the column header that contains the data to be checked, or any cell in that column.

Example:

Suppose you are requested to analyse a list of part numbers and determine which parts are currently needed Unfortunately the list contains the same part number a number of times (as shown below).

Original Data:


graphic

Running Duplicates Remover using the second column as the Duplicates Column will create a new Workbook with two sheets. The first occurance of each part number will be included in the 'Uniques' column. All other occurances will be placed in the 'Duplicates' column. This can be seen below.

Unique occurances:


graphic 

Duplicate occurances:


graphic


  

Created with the Personal Edition of HelpNDoc: Easily create PDF Help documents