Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語

IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

My Solution

solved

Done.

Not the most efficient probably, but I did it.

My numbers were slightly different

Screen Shot 2023-06-15 at 15.02.43.png

Nice one! Use CountWords function to match the word count result. I was trying regex earlier.

My solution attached.

First 3 questions pretty simple, use summarize tool to group by and then count the records. Last question used get words function in formula tool and then summed up the number of words.

PFA for solution

Screenshot 2023-07-07 152444.png

My solution.