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

Challenge #28: Formatting Financial Data

greggrimmer1
8 - Asteroid
Spoiler
greggrimmer_0-1603484566204.png

 

A2H
11 - Bolide
Spoiler
Capture d’écran, le 2020-10-26 à 23.44.35.png
WernerE
8 - Asteroid

I clearly overcomplicated this. Lesson learned I hope...

Than_Alien
8 - Asteroid

Uploaded

LHolmes
9 - Comet

Good use of prep tools!

 

Spoiler
028 - Solution.PNG
p-g
8 - Asteroid

My 5 step solution to the challenge. Love the flexibility that the Formula functions provide. Can do almost any cleaning, formatting, extracting exclusively using these.

 

Spoiler
p-g_0-1606727623059.png
MikeLR
8 - Asteroid

Good practice with a few different tools:

Spoiler
MikeLR_0-1606915102432.png

 

PhilipMannering
16 - Nebula
16 - Nebula

Solution Attached.

TarunDeep
8 - Asteroid

Straight one. Solution attached.

Spoiler
Solution 28.png

 

DN
8 - Asteroid
Spoiler
Capture.PNG