Need macro for duplicates of specific cells in one column

I am looking for a macro that can find duplicates in the same column located between division markers and that have the same label in column A.

In other words, I have a spreadsheet with labels in Column and values in Column B. I want to find duplicates of values in column A, but ONLY among items with the same label in column A.

For the sake of example, suppose I have a list of countries, states, counties, and cities. Then I might only want to find duplicate city names, not duplicate county or state names.

Additionally, column B has section divisions, and I only want to find duplicates within a section. For the sake of this example, let's say Column B has some cells with the value "Region". I would only want to find duplicate cities between "Region" cells.

Attached is a spreadsheet showing the example. For the spreadsheet, the macro's result should write in Column C that "Phoenix" is a duplicate. However, it should ignore "Mesa" (because the two instances of "Mesa" are in different regions.

Hi

How about

Please Login or Register  to view this content.

rylo

Wow! That was fast! When I try the macro in the sample spreadsheet I provided, it works. However, when I try it on a diffent workbook, I get the error message "Run-time error '1004': Appllication-defined or object-defined error'

---------- Post added at 05:00 PM ---------- Previous post was at 04:56 PM ----------

I tried it again, and now the error is "Method 'Range' of object'_Global' failed.

Hi

Can you attach a copy of the workbook where it doesn't work?

rylo

Sorry for the delay. I needed to change the spreadsheet to go with the example for security reasons.

Hi

OK, this has a slightly different structure, so try

Please Login or Register  to view this content.

rylo

Amazing. It seems to work like a charm! Thank you, thank you.