Five random items from a a list into a single cell separated by a comma-CodePudding

I have n number of unique values in n cells in Column A. (For ex: EDN12, EDN122, EDN991, ....)

I want to return any five unique values without repetition in a random order from Column A into an individual cell n times separated by a comma. For example; (EDN12, EDN112, EDN991, EDN881, EDN12)

How do I achieve this?

I have tried this formula provided here (

If your list of data is very short, then it can return non-unique values.
Although your example appears to have at least 1000 data rows, so it will not be a problem.