In column A I have a set of cells with either a L, H or blank Value. In column B I have 256 different patterns of possible consecutive L and H combinations to a run of 8. I want to find out how many times each of those pattern combinations show up in column A. The blank values interrupt the pattern.
Bookmarks