Formula to rearrange names in random order

[FryGirl]

Using the names in row 1, randomly display the same names in row 2 with a formula starting in A2 without duplicating the same name in the same column. Something like the below.

Data Range
[TABLE="class: grid"]
<tbody>[TR]
[TD][/TD]
[TD]

A​

[/TD]
[TD]

B​

[/TD]
[TD]

C​

[/TD]
[TD]

D​

[/TD]
[TD]

E​

[/TD]
[/TR]
[TR]
[TD]

1​

[/TD]
[TD]

Jack​

[/TD]
[TD]

Cheryl​

[/TD]
[TD]

Bob​

[/TD]
[TD]

Jim​

[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

2​

[/TD]
[TD]

Bob​

[/TD]
[TD]

Jack​

[/TD]
[TD]

Jim​

[/TD]
[TD]

Cheryl​

[/TD]
[TD]

Formula for a random Order​

[/TD]
[/TR]
</tbody>[/TABLE]

 

[Marcelo Branco]

Maybe this

Regular formula in A2
=INDEX(A1:D1,RANDBETWEEN(1,4))

Array formula in B2 copied across until D2
=INDEX($A$1:$D$1,SMALL(IF(ISNA(MATCH($A$1:$D$1,$A2:A2,0)),COLUMN($A$1:$D$1)-COLUMN($A$1)+1),RANDBETWEEN(1,4-COUNTA($A2:A2))))
Ctrl+Shift+Enter

M.

 

[FryGirl]

Ciao Marcelo,

Works great. Thank you for your time.

 

[Marcelo Branco]

You are welcome. Glad to help.

M.