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 #284: Division with Macros

patrick_digan
17 - Castor
17 - Castor

@Watermark that's a pretty neat way to do it in a single formula tool! I hadn't thought of anything like that.

geoff_zath
Alteryx
Alteryx

Workflow

Spoiler

geoff_zath_0-1641587544563.png

Macro

Spoiler
geoff_zath_1-1641587591698.png

 

PatrickW_
Alteryx Alumni (Retired)

that was a doozy!

Robinvm
8 - Asteroid

Tricky Challenge - I love it

fvojtesek
8 - Asteroid

I managed to do this only using the multi-row tool, no macro was required.  You could easily wrap this up into a simple macro if you wanted though.  

OllieClarke
15 - Aurora
15 - Aurora

This has been such a bugbear for me, but finally got it :)

Spoiler
OllieClarke_0-1649690331999.pngOllieClarke_1-1649690364361.png

 

TonyAndriani
9 - Comet

Reposting under my new user ID.

scoles0617
8 - Asteroid

My solution:

mmontgomery
11 - Bolide

Challenge #284

 

Workflow

 

Spoiler
mmontgomery_0-1655236610449.png

Iterative Macro

Spoiler
mmontgomery_2-1655236676051.png

 

Amol_Telore
11 - Bolide
Spoiler
Amol_Telore_0-1657701119873.png

Here is my solution