Challenge #135: Locker Problem

[afv2688]

Nice one!

Spoiler

[T_Willins]

My solution   ...as John Bender runs down the hall, closing lockers, singing, "I wanna be an Airborne Ranger..."

Spoiler

[abassett]

There is an intuition to this solution rather than relying on macros as I have done.

Spoiler

Locks that will be open are those with an odd number of factors (numbers that divide it).

As factors come in pairs, the only way a number can have odd number of factors is if one factor pairs with itself, ie the number is a (perfect) square.

Then it just all the squares upto N.

Generate rows upto SQRT(N) then square each number.

But that's too much maths and Alteryx is more fun!

[dsmdavid]

Finally able to attach files.

[sgrabish1]

Thanks for practice exercise; mod is useful indeed!

[Chantelb]

Spoiler

[KMiller]

Solution attached.

Spoiler

[AV8]

Getting good practice with iterative macros.

Spoiler

Spoiler:

Spoiler

Spoiler:

[nini]

My Solution:

[chhanditachowdhury]

my solution