compare two text strings, return a result and count it

tauqeeracma 

Thanks for your assistance. It kind of works, but I need a little more. Let me explain further:

For each team (there are 16 teams), I need to know how many times that team was guessed, and what the outcome was (win or lose). This will then enable me to calculate how 'reliable' that team is (i.e. how many times they are picked, and how many times they actually win).

An example:

The team Bulldogs have performed very poorly in 2021. Picking them to win is a very risky move, and so they are 'unreliable'. Conversely, the team named Storm have won almost every single one of their games this year. Picking them is a very reliable choice.

Are you available to chat and discuss this further?