Challenge #59: Is it an Anagram?

[Garrett]

Not dynamic, but quickly could be with the addition of an "Ensure Fields" macro.

[Coxta45]

[Removed] 

Posted to wrong weekly challenge.

[SeanAdams]

My approach is the same as @Coxta45 - but looking at some of the others I could have compressed into 1 stream of data by doing the transpose early...

(or one component for the fearless and brave; or for @AdamR_AYX)

Spoiler

[estherb47]

I guess that @alex and I think alike! I came up with the same solution as he did

[jacob]

Spoiler

[LordNeilLord]

Similar to @Coxta45 but I chose to add an extra verification......

Spoiler

As well as summing the characters, I chose to count them as well...just to make certain :)

[mceleavey]

Fairly straightforward (once you know how)

Spoiler

I started by creating a record ID field then transposed to get all words in the same column. I then split that column to rows using regex on any character (.).
Then it was simply a case of sorting by the record ID and alphabetically by letters, cross-tabbing them to concatenate into a single cell, effectively creating a string of the alphabetic order of the letters, then I used a simple formula to determine the matches.

[jamielaird]

Here's my solution. I enjoyed this one lots!

Spoiler

[nick_ceneviva]

Solution Attached

[patrick_digan]

Spoiler

I converted the letters to numbers and made sure that they had the same sum. I also checked the length.