Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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 #69: Web Stock Data

tammybrown_tds
8 - Asteroid
Spoiler
tammybrown_tds_0-1602803274879.png

 

Sylvana
8 - Asteroid

My solution. Just using "Text to Columns":

Spoiler
Sylvana_0-1602837108998.png

 

A2H
11 - Bolide
Spoiler
Capture d’écran, le 2020-10-23 à 21.08.15.png
kaianderson
8 - Asteroid

I learned something new with this one.

The switch function is very cool.

joshbennett
11 - Bolide
11 - Bolide

Here is my solution!

 

 

mollyhatch
8 - Asteroid
Spoiler
69 Picture.PNG

 

kmedici
8 - Asteroid
Spoiler
kmedici_0-1606841293486.png

 

Scythe80
6 - Meteoroid
Spoiler
YAC191185_0-1606843743925.png

Not too much different from what I have seen from others. I needed to refer to one person's solution for the initial Text to Columns though. Can someone explain how the "\n" works as a delimiter in text to columns? I didn't notice it within the extract, and would never have thought to use it.

dicky5150
8 - Asteroid
Spoiler
Challenge 69.jpg
beccat
8 - Asteroid

My solution.