S
Scopar
Hi,
I'm looking for a way to count the current consecutive wins for a team in a
two team competition.
I've tried using 'countif', but that doesn't quite seem to work for me. It
seems like it should be a relatively simple thing to do, but I just can't get
it.
My current spreadsheet has the 'winner' of an event listed in column D. It
will only ever be one of two teams (Team 1 or Team 2). How can I set up a
formula in a cell to count the current winning streak of a team.
Ideally, it would reset once a streak is broken (and a new one starts).
Hope all that makes sense.
Thanks,
Scott
I'm looking for a way to count the current consecutive wins for a team in a
two team competition.
I've tried using 'countif', but that doesn't quite seem to work for me. It
seems like it should be a relatively simple thing to do, but I just can't get
it.
My current spreadsheet has the 'winner' of an event listed in column D. It
will only ever be one of two teams (Team 1 or Team 2). How can I set up a
formula in a cell to count the current winning streak of a team.
Ideally, it would reset once a streak is broken (and a new one starts).
Hope all that makes sense.
Thanks,
Scott