Extract duplicates

I would like to extract a list of duplicate products based on location.

Any product duplicated with products in location ob* are placed in a new list.

Please refer to the posted simplified sheet for reference.

The spreadsheet in question has thousands of rows so i would like the duplicates list to be compiled in a new sheet.

Please forgive my poor use of terminology, and thanks in advance for any suggestions posted.

Thanks again

Hello Excelexcess,

This macro will keep only the duplicate products that contain the string "ob" in them. The data must be sorted by product before the macro is run. You can change both the data table cells, and also the location of the new table (code is in blue). The macro is not designed to overwrite the original table. This is installed in the attached workbook.
Macro Code

Please Login or Register  to view this content.

Sincerely,
Leith Ross

These solutions are very useful, and have solved my problem, thanks

I can adapt each to my needs in other areas as well