Sorry to take so long getting back to you - busy day yesterday.

I see what you're trying to do, but the presence of the "bye" row means that the count function returns the wrong row number.

The formula that works for me is =INDEX(G:G,MAX(INDEX(ROW(H10:H26) *(H10:H26<>"") * (OFFSET(H10:H26,1,0)=""),0)),1) & INDEX(H:H,MAX(INDEX(ROW(H10:H26) *(H10:H26<>"") * (OFFSET(H10:H26,1,0)=""),0)),1)

Not as simple, but it does seem to do the job.

You can simplify it by putting in another helper column. In I10 put the formula =IF(SUM($H$10:$H$26)=SUM($H$10:H10),TRUE,FALSE) and copy down. You can then simplify your streak formula to =INDEX(G10:G26,MATCH(TRUE,I10:I26,0),1) & INDEX(H10:H26,MATCH(TRUE,I10:I26,0))

Whichever method you prefer, I suppose.