Search

Close

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

Cool challenge..

I had to read up on the Reporting tools but learn about Column Rules in the process!

So that's how cell formatting is done...

woof

Challenge 249 2021-03-04.jpg

My attempt

Good practice on the reporting tools - these are super useful tools to know.

Result:

Solution:
- Appended a maximum value (using Transpose & summarise) to the data table
- Then used simple column rules in the table to compare the column value to the max value

Solution:- Appended a maximum value (using Transpose & summarise) to the data table- Then used simple column rules in the table to compare the column value to the max value

My Solution:

Solution attached.

RT