plz help -> finding the occurrence of the "Adjacent" digit (character)

[memooo99]

Hi,

I need help on finding the occurrence of the "adjacent" digits (characters) (in this state is 10 digits(characters) for each single cell of "column A" (cell A4,A5,A6,...Axxx)

http://www.imageblinks.com/upload/bi...8a2c3dca77.jpg


(BLUE color) assume I put the data I want to find the adjacent in A4 to A12 (10 digits) in this state I mean 10 characters as I put a quote (') in front of it,
(Yellow color), is the "TOTAL" count of the number for the occurrence of (Double) digits appears. (Same to Triple, Quadruple, Quintuple, Sextuple, Septuple)
(GREEN color), for column C to L, it shows how many time that occurrence(s) appear(s) for each "Digit" or "Text Character".

For the Double -> 2 repeated adjacent numbers occur, count as 1, another 2 repeated adjacent number occur, count as 2,,,and then so on.... (up to 5 times because 10/2 = 5)
For the Triple -> 3 repeated adjacent numbers occur, count as 1, another 3 repeated adjacent number occur, count as 2,,,and then so on.... (up to 3 times because 10/3 = 3)
For the Quaduple -> 4 repeated adjacent numbers occur, count as 1, another 4 repeated adjacent number occur, count as 2,,,and then so on.... (up to 2 times because 10/4 = 2)
For the Quintuple -> 5 repeated adjacent numbers occur, count as 1, another 5 repeated adjacent number occur, count as 2,,,and then so on.... (up to 2 times because 10/5 = 2)
For the Sextuple -> 6 repeated adjacent numbers occur, count as 1 (up to 1 times because 10/6 = 1)
For the Septuple -> 7 repeated adjacent numbers occur, count as 1 (up to 1 times because 10/7 = 1)

PS. Doulble, Triple, Quaduple,Quintuple, Sextuple, Septuple will be on a "Separate" worksheet", but will be put in the similar column as for Double (column A -> input data), (column B -> Total Occurrence appears), (column C -> no.of occurrence for each digit (text character).


If you doubt any part of my question, please don't hesitate to ask, I hope you can help me out on my problem

Thank you so much my friends.

[memooo99]

IF anyone got an idea please share it with me,

Thank you so much

[memooo99]

Anyone please...... T___T

[memooo99]

maybe previous detail I gave it not enough, so I edit & put more detail in OP,

Hope someone can help me out,

Thank you so much

[sktneer]

Please find the attached sheet and click on the Green Button on Sheet "2" to get the desired output on all the sheets. See if this helps.