Sorry that I broke a rule before I made this tread. I will not do that again.

I have been working on making formula on streak on wins and losses on my excel for football statistics. The formula I am using is:

"=(INDEX(G10:G26,COUNT(H10:H26))&(INDEX(H10:H26,COUNT(H10:H26))))"

The result came out as L4 (lost 4 straight games), that result is just what I want, but the problem is when I put in the final score on next game, the result came out blank. I couldn't figure the problem.

Thanks