I am trying to return the consecutive times a certain number or letter appears excluding any blanks. i.e. "1,1, blank,1,blank,blank,1,2,1,blank" the formula (if trying to see the number of consecutive 1s would return 4 as 1 appears consecutively 4 times.
I have attached an example.
Kind Regards
Paul
Bookmarks