Counting Partial Number Instances Within a Set Number Length.

[MurasakiK]

Hello,

I'm trying to count all the instances that a partial number sequence occurs within a column of data. The ID numbers have varying lengths of 7-digits and 8-digits and so, I need to separate out the partial string of numbers from both lengths. The COUNTIF function seems to work well with alphanumeric strings but, no so much with numbers only.

EXAMPLE

Column A

1112223
11223344
1124435
11233367
1134426
11122234

And so, how would I tabulate the 7-digit numbers that start with 112... separate from the 8-digit numbers that start with 112... and so on and so forth? I'm trying to factor for a situation where I have a lot of data to sort through and making a mistake in counting by sight is easy. Any and all help is most appreciated.

[martindwilson]

=SUMPRODUCT(--(LEFT($A$1:$A$60,3)="112"),--(LEN($A$1:$A$60)=7))
=SUMPRODUCT(--(LEFT($A$1:$A$60,3)="112"),--(LEN($A$1:$A$60)=8)) will count them
to seperate them
in b1
=IF(AND(LEFT($A1,3)="112",LEN($A1)=7),$A1,"")
in c1
=IF(AND(LEFT($A1,3)="112",LEN($A1)=8),$A1,"")

[MurasakiK]

That works! Thanks so much.