Summary of list with multi length numbers
Hi,
I have a list with numbers.
9411007816009306000
9411007816009306001
9411007816009306002
9411007816009306003
9411007816009306004
000123556790
000123556792
000123556796
000123556797
000123556794
000123556799
09459001890
09449001799
09469001790
09455001890
09456001890
-----------------------------------------
Result:
Head Count
816 4
0944 1
0945 3
0946 1
For any 19 digits I would like to count 816 using mid xl function.
For any 12 digits no count.
For any 11 digits I would like to count 0945, 0944, 0946 using left xl
function.
Thx.
|