Hey!
Would like some help with counting certain characters in a one cell.
3312221133111
1. Would like to count certain character combination in the string above. The combination I would like to search for is how many times "11" appears.
For me is should be 3 times. First 11 then the 111 contains "11" two times.
"11" = 3 times
"22" = 2 times
"33" = 2 times
2. Would also try to count occurrences of "1". It should count just one time even tho its a single(1), double(11) or tripple(111) and so on.
Here I would like it to count 3 in the string above.
1 = 3 times
2 = 1 time
3 = 2 times
Would like some help with counting certain characters in a one cell.
3312221133111
1. Would like to count certain character combination in the string above. The combination I would like to search for is how many times "11" appears.
For me is should be 3 times. First 11 then the 111 contains "11" two times.
"11" = 3 times
"22" = 2 times
"33" = 2 times
2. Would also try to count occurrences of "1". It should count just one time even tho its a single(1), double(11) or tripple(111) and so on.
Here I would like it to count 3 in the string above.
1 = 3 times
2 = 1 time
3 = 2 times