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 #53: Parsing Report Formatted Data

estherb47
15 - Aurora
15 - Aurora

@mbogusz 

A little more streamlined, and different use of the Tile tool in this workflow.

Cheers!

Esther

estherb47
15 - Aurora
15 - Aurora

@mbogusz , exactly!! I find the Tile tool much easier for those "within group" numbering of rows, because you don't need to write up a formula. 

One of the amazing aspects of this community is learning lots of tricks from others

parvez
6 - Meteoroid

clipboard_image_0.png

jagdeep_singh85
8 - Asteroid

PFA my solution

Ellie_P
8 - Asteroid
 
jagdeep_singh85
8 - Asteroid

PFA my solution

SubratDas5
10 - Fireball

My solution for the parsing challenge.

MattBenj
9 - Comet

Solution attached. No macro used.

JennyMartin
9 - Comet
Spoiler
AWC53.PNG

Nice and simple 

Laszlo_D
8 - Asteroid

image.png