Mark up pairs, triplets, quads, and quints+ of repeating cells and give each a designator

Hi I'm new to VBa and I have a problem. I have 28,000 rows of data that are in Column A. In Column B I need to put "<-3> [SSM] (CSM)" next to all grouped cells that contain duplicate data of 2s, 3-4s, & quantities of 5+ but I want to exclude/ignore 0 readings.

So if I have 3 adjacent cells in column A that contain the same data, I want to put the text "<1> [SSM] (CSM)" next to each one in column B.

I tried modifying the code I found here http://www.excelforum.com/excel-prog...ata-macro.html but I can't get it to work.

Please Login or Register  to view this content.

I have tried this code, but I can't get it to work:

Please Login or Register  to view this content.

Please show me how to edit my code to make this work.

Any help is appreciated!

Try this:-

Please Login or Register  to view this content.

Regards Mick

Thanks Mick, that's closer, but I only need it to select the cells that are adjacent. Using this code returned the following results in some places

Please Login or Register  to view this content.

The first 3 single values should not have been designated. How can that be fixed?

Thanks again!

I'm understanding you to mean that those values that are Not Adjcent but have duplicates are being marked, but you only want values that are duplicate and in adjacent cells to be marked.
Try this:-

Please Login or Register  to view this content.

Regards Mick

Awesome! Thank you!

Your welcome
Regrds Mick