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

Screenshot (83).png

A bit of a brute force strategy I think, but I got it. Fun challenge!

Solution Attached

Solution

here is my solution

1. Formula 1: Left([Date], 1)

Formula 2: IF Length([Date]) >2 THEN Right([Date], 2) ELSE "" ENDIF

2. Multi-Row Formula for the Year column: IF IsEmpty([Year]) THEN [Row-1:Year] ELSE [Year] ENDIF

3. Multi-Row Formula to create a month number/count column: [Row-1:Month number]+1

4. Switch function to replace numbers with month abbr: Switch([Month number],Null(),1,'Jan',2,'Feb',3,'Mar',4,'Apr',5,'May',6,'Jun',7,'Jul',8,'Aug',9,'Sep',10,'Oct',11,'Nov',12,'Dec')

5. Select tool to hide a month number/ count column

solution

5 KB

Solution Attached !!

curated machine learning resources