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 #151: Meta Parsing

peter_gb
9 - Comet

Nice, I immediately went macro but could have been simpler, also couldn't really be bothered to faff with the column order but note others' solutions and persistence to do so!

Spoiler
challenge_151_pgb.png

JamesCharnley
13 - Pulsar
Spoiler

JamesCharnley_1-1659823979145.png

For some reason it had never crossed my mind that you could update a string formula like that until I just tried it!

Brian32
8 - Asteroid

Challenge Solution:

Spoiler
Brian32_0-1660927680697.png

 

nandagaikwad03
8 - Asteroid
Spoiler
Challenge_151_Workflow.png

grazitti_sapna
17 - Castor

workflow

 

grazitti_sapna_1-1662007600698.png

 

 

 

Macro

grazitti_sapna_0-1662007566603.png

 

Sapna Gupta
MilindG
12 - Quasar
Spoiler
MilindG_0-1662065691959.png

 

tammybrown_tds
8 - Asteroid
Spoiler
tammybrown_tds_0-1663796139733.png

 

Spoiler
tammybrown_tds_1-1663796158840.png

 

 

Liusaidhowen
8 - Asteroid

My solution

acarter881
12 - Quasar

Here's my solution. The standard macro contains similar tools.

Spoiler
my_weekly_challenge_151_solution.png
karlhansen
9 - Comet
Spoiler
solution_151.jpg