Check if a list of barcodes would form cluster groups inside of another barcode list

[hasan mougharbel]

Hello guys,
I hope you are all doing well today.
I want to check if barcodes in column A are tend to to be grouped in clusters in column C.
or in other words does any group of barcodes in Column A are found to be grouped inside column C as close to each other.
I am so grateful for any kind of assistance.
God bless you.

Please refer to my excel sheet for reference of column A and column C.

[JohnTopley]

Diificult, even with VBA, as the data in the "matching" groups are in different order which entails multiple matches to determine any potential clusters.

For example, 4 matching barcodes in A and C could be defined as a cluster even if they do not appear in sequence in either list,

What determines the barcode order in C ?

In A

95716-04-25/ A92
95768-03-145/ A185
95716-03-25/ A91
95746-03-60/ K138


vs

in C

95746-03-60/ K138
95768-03-145/ A185
95716-03-25/ A91
95716-04-25/ A92

????