counting the occurrence of a set of continguous values

[2013April]

I have one column of information.
It ranges from cells A1 to A20000.
For simplicity, the values in the cell is a 5-digit number that can range from 10000-30000.

I would like to look only at the first three digits of the data set.
Looking at cell A1 (value is 13245), how many occurences of '132' can I find in the range A1-A20000?
Then looking at cell A2 (value is 16756), how many occurences of '167' can I find in the range A1-A20000?
Continue this with each cell until cell A20000.

Next step, I want to look only at the second, third, and fourth digits of the data set.
So looking at cell A1 (value is 13245), how many occurences of '324' can I find in the range A1-A20000?
Then looking at cell A2 (value is 16756), how many occurences of '675' can I find in the range A1-A20000?
Continue this with each cell until cell A20000.

Next step, I want to look only at the third, fourth, and fifth digits of the data set.
So looking at cell A1 (value is 13245), how many occurences of '245' can I find in the range A1-A20000?
Then looking at cell A2 (value is 16756), how many occurences of '756' can I find in the range A1-A20000?
Continue this with each cell until cell A20000.

Any help would be greatly appreciated!

Thanks!

[mehmetcik]

I don't really understand what you want.

But this will count all occurrances of 123 in the range A1 to A20.

Please Login or Register  to view this content.

[2013April]

Thanks for looking mehmetcik. I've editted the orginal thread to try to explain what I want to do.

[mehmetcik]

Well that is clearer, how do you want the answers displayed?

[2013April]

column titles would be:
original data
first 3 digits
# of occurrences
next 3 digits
# of occurrences
next next 3 digits
# of occurrences

I will ultimately need to make a distribution graph.

Thanks!
-geneva