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 #117: Credit/Debit Midpoints

estherb47
15 - Aurora
15 - Aurora

The Make Columns tool definitely made this easier.

 

Once I understood the logic needed, the workflow was easy. No great surprise that my solution matches @NicoleJohnson - we often think alike on these :)

LordNeilLord
15 - Aurora

I went for the simple approach

 

Spoiler
117.png
DawnR
8 - Asteroid

Got it! Took me longer than I'd care to admit.

StevenBetts
8 - Asteroid

I took heavy inspiration from @NicoleJohnson's method on this one and learned some new tools in the process. Thanks! :)

 

Spoiler
Challenge 117.jpg
cplewis90
13 - Pulsar
13 - Pulsar

Probably not the best solution for this one and will definitely look for the iterative macro solution as I used a batch macro solution. Great challenge!

Spoiler
Challenge 117.JPG
jasperlch
12 - Quasar

Advanced Join macro used. Solution Attached. Thanks!

MPolin
6 - Meteoroid

My solution using an iterative macro

jamielaird
14 - Magnetar

Got there in the end..

 

Spoiler
solution_117_JL.png
danilang
19 - Altair
19 - Altair

Nice challenge.  I started down the same route as @NicoleJohnson but split and then used a join to pull the streams back together

 

Spoiler
Solution 117.png

 

Dan

DavidP
17 - Castor
17 - Castor

Fun challenge!