Trying to compile different W/L streaks

[miles00577]

I have compiled a list of game scores for different sports for an athletic program.

In Column J, I have where the game was played (Home = H/Away = A/Neutral = N)
In Column K, I have if the game was a conference game (Y/N)
In Column L, it lists if the game was a win/loss/tie (W/L/T)

I've got coding to work in Columns AM and AN to tabulate consecutive winning/losing streaks using the IF statement, using the following:

In Cell AM3, I have the following: =IF(L3="W",1,IF(L3="L",0,IF(L3="","",0)))
In Cell AN3, I have the following: =IF(AM3<>"",IF(AM3=0,0,AN2+1),"")

This coding works perfect for tabulating the overall streaks, but obviously if I create a column for just home games, it's going to leave blanks and reset the streak if a game wasn't at home. I want to be able to go much deeper into the numbers to find winning/losing streaks for home or away, conference and non-conference, conference home or away, non-conference home and away, etc. Can someone point me in the right direction?

 

[DRSteele]

Review this thread in the Forum and let us know whether or not it helps.

https://www.mrexcel.com/forum/excel-questions/978269-streaks;-current-streak-conditions.html

 

[miles00577]

Yes! Well, to an an extent. Not quite sure where I need to make it work to do multiple conditions (i.e., conference home/away, non-conf home/away, etc.). Those formulas in the thread you posted work great for just searching two columns, which I can use... but for a further breakdown of other categories, I'll need three or more. Would be even better if I can get it to post the dates of the streak next to the column for reference as well. Definitely on the right track though.