How do I shuffle values in a column

[Nick_HE]

Ok here’s quite a deep dive into this topic:

Randomize / shuffle a List

Lets say i have a list which is =List("alpha","beta","delta","charlie","echo","foxtrot") now what i want to achieve is a formula that outputs a re-shuffled randomized order of that list. (be it triggered by a button or document edit. as long as a formula combination that does it) any coda expert that has elegant solution for this? i can’t figure it out.

It’s really bugging me that I can’t come up with a quick solution to this.