Hi! I've had the same problem as you, counting current win/loss/tie streaks. I've been using the formula below and it's ok, except it doesn't work when there are blank cells in the range:

=LOOKUP(1E100,FREQUENCY(IF(B2:B7=LOOKUP("zzz",B2:B7),ROW(B2:B7)),IF(B2:B7<>LOOKUP("zzz",B2:B7),ROW(B2:B7))))&"
"&LOOKUP("zzz",B2:B7)

Can anyone help me please, by making the formula ignore blank cells? Thks!