Challenge #11: Identify Logical Groups

[Laszlo_D]

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[kmickelson]

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[TomProwse]

Solution Attached

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[jarjarbingie]

Spoiler

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[aazimh]

Spoiler

Decided to go super heavy on the formula tool for this one 🙂

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[JennyMartin]

Spoiler

Definitely didn't complete this challenge in the most efficient way possible so looking forward to seeing other solutions!

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[Yoyo_Master]

Not relevant to the challenge, but I learned of the cache function! 

Spoiler

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[Adam_Dooley]

My last step could use a Regex_Replace formula to remove the commas perhaps, but I got the Boolean IIF function to work just fine.

Spoiler

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[jusdespommes]

All done - did it first by Text to Rows but couldn't get the same count, which was weird. Did it my backup way and got the right count though 🙂

Spoiler

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[timrains]

Challenge done. A horrible hard coded version and more dynamic one. 

Spoiler

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.