Free Trial

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 #74: Build a Factorial Calculator

marcreid
7 - Meteor

Solution

Spoiler
Macro
image.png
Natasha
9 - Comet

Solution

Spoiler
Screen Shot 2017-11-12 at 14.08.50.pngScreen Shot 2017-11-12 at 14.09.01.png
ggruccio
ACE Emeritus
ACE Emeritus

I knew what I wanted to do but kept losing something in the iteration.  Finally decided on a nested macro - which works nicely!

LandonG
8 - Asteroid

Solution attached.

samN
10 - Fireball

Pretty fun

Spoiler
Used a generate rows tool and then did a rolling sum with some filters at the end
jasperlch
12 - Quasar

Solution attached.

JosephSerpis
17 - Castor
17 - Castor

Challenge Completed

SGolnik
11 - Bolide
11 - Bolide

I love macros :-)

CHarrison
8 - Asteroid

As a mathematician, this one pleased me ;) 

Ozzy_Campos
8 - Asteroid

Solution Attached.  Started trying to make iterative macros embedded in one another, then realized that I had dramatically over-complicated it.  Good learning experience.