I have a formula that calculates a count of consecutive cells:
UUUUUUPPUUUUUUEUUU
So the values returned would be 15U, 2P, and 0E since there are no consecutive Es.
That all works fine, but now I have to find a way to ignore if there is a blank space and have it still count:
UUUU UUPPUUUUUE UUU
I would still need it to give me the same values as the first line, ignoring that there is a blank.
Bookmarks