In the following example
if I am counting the number of consecutive "y" s the answer in cell R3 would be "3"
E F G H I J R 3 y y y y y 4 y y y y y 5 y y y y
but the answer in cell R4 would be "2"
but the answer in cell R5 would be "1"
Thanks in advance
Bookmarks