Challenge #187: Generate Prime Numbers

[hpaulina]

Dirty but works fine for the small numbers

[ConradW]

Complete

[kmcdaniel]

Spoiler

[JonMcMillin]

Thanks ChristineB! that was deceptively hard! Originally I tried to use an iterative macro with factorials, but quickly run into field size, and big number challenges that Alteryx has. 

Then had to think of another way to skin the cat, that was not brute force 🙂

Spoiler

[KMiller]

Solution attached using an iterative macro. The number 1 is included in the result for good measure.

Spoiler

[mtedw]

Spoiler

Gave this one a good think ahead of attempting it, went down a few blind alleys and ended up with a simple solution. Want to iterate to solve where 50 can be replaced by 'x' though.

[JamesCameron]

Here's my effort.

Macro is based on the Sieve of Eratosthenes algorithm: Wikipedia 

[PaulRB]

My solution. Only 4 tools (excluding tools to check the answer).

Spoiler

[JoshuaGostick]

I feel as if there are various interesting ways to accomplish this!

Spoiler

[dshirer]

First time doing a weekly challenge!

I used a macro which basically eliminates composite numbers, so that all that's left at the end is primes. I verified up to 10,000,000, which took 10min to run