Challenge #128: Settle the Score

[lwolfie]

The hardest part for me was understanding the problem. Once I understood that, I was able to get it done.

[jlhilgert]

My solution:

[whitefang742]

For reference

[Bren_Spill]

Spoiler

 

[Axelar]

#Solution

[Felipe_Ribeir0]

Here is my solution.

[Bobbyt23]

Spoiler

Took me a bit to remember to change the Case Insensitive flag in my contains formula. I also forgot about the Total Column function in the Cross Tab tool so good to remember that functionality.

[leonardstarrk]

Learned to use RegEx_Match and the Add Totals Crew Macro tool.