Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!
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 #79: Find the Closest Prime Number

Watermark
12 - Quasar
12 - Quasar

Decided to make an app where you enter any number less than 100k

 

Spoiler
MT Solution 79.png

TonyAndriani
9 - Comet

Reposting under my new user ID.

 

Rwebber1991
8 - Asteroid

I may have taken the long way with two iterative macros but we got it done!

binuacs
21 - Polaris

solution attached

SylwiaDragon
8 - Asteroid

I started with challenge 187 first, and it helped a lot with solving this one :)

mmontgomery
11 - Bolide
11 - Bolide

Challenge #79

scoles0617
8 - Asteroid

My solution:

ddiesel
13 - Pulsar
13 - Pulsar

Super fun challenge!

 

My solution:

Spoiler
As I was building this I knew it was wildly inefficient... but it works. Now I'm going to RUN to go read all the brilliant submissions to this challenge.

I set the limit arbitrarily to a maximum of 10,000. If a number is equal distance from two prime numbers, it will return both.

Capture.JPG
DataNath
17 - Castor
17 - Castor

My solution for #79. Not fully dynamic as it adopts the 6n +/- 1 approach, but a little strapped for time. In reality could just generate a full list of divisors based on generating rows from 1 to n where n is the number in question, and counting the number of times the number/divisor is 1.

 

Spoiler
DataNath_0-1656270138110.png

 

DataNath_1-1656270227206.png

 

 

aiahwieder
8 - Asteroid

PRIIIIIIIIIIIIIIIIIIIIIIIIIIME