Challenge #64: Catch Me If You Can

[KOBoyle]

Solution attached. Got stuck on my first attempt.

Spoiler

[OllieClarke]

Here's my solution, looking through other people's solutions, I clearly over complicated things

Spoiler

[JDelgado]

I don't know why the Crosstab tool mangles the column name strings, but otherwise here's my solution.

[OldDogNewTricks]

Fun dealing with the special characters and cross-tab tool.  I'll have to check some other solutions and see how others dealt with this problem.

Spoiler

[JoBen]

Cheers!

[Laurap1228]

Very cool macro to continually randomize the inputs!

[MarMu]

Pretty tricky challenge. Very hard to debug column sorting. I feel like I've tried every combination of sorting and re-ordering before I re-read the description. I absolutely killed it with the Dynamic Select tool. Such a simple solution. It brought the no. of tools down to 3.

It's a bit annoying that the shuffle-macro is locked for editing and I cannot rename the file to match (my made up) naming convensionrest of the other weekly challenges. Why?

Anywho. I made it, yay me

Spoiler

[pasccout]

Here is my solution

[justynam]

My solution

[jssandom]

One of my all time faves!