hi all..

i have the following data setup:

from a2 to a950 there are entries like a7213 - f3030 - eu112 - gu331 - a7213 - gu331 - gu331 - f3030 - f3030 - f3030 - eu112 - eu112 - ht471 ... and so on...

i like to know which entries occured consecutively as gu331 twice, f3030 three times and eu112 twice ....

i can't use a helper column for the table has 12 columns and i get it from an outside source...

therefore, a macro solution would be nice...

thank you very much...
wolfgang