Randomizing pairing list, does not duplicate

[MangoButter]

Hello,

I'm looking for a way to pair two lists of names randomly that do not duplicate. In column A) I have 6 names, and in Column B) I have 12 names. Column A would then be paired with two names from column B. Is this at all possible?

Thanks for the help!

 

[Cubist]

Try:

Book2
	A	B	C
1	List1	List2	Pairing
2	Emma	Sophia	Emma
3	Lucas	Ethan	Mason
4	Ava	Isabella	Olivia
5	Mason	James	Emma
6	Olivia	Mia	Liam
7	Liam	Noah	Liam
8		Harper	Ava
9		Benjamin	Mason
10		Amelia	Olivia
11		Alexander	Ava
12		Grace	Lucas
13		Samuel	Lucas
Sheet3

Cell Formulas
Range	Formula
C2:C13	C2	=INDEX(A2:A7,SORTBY(ROUNDDOWN(SEQUENCE(12,,,0.5),0),RANDARRAY(12)))
Dynamic array formulas.

 

[MangoButter]

Thank you, very helpful!

Oone question though, if I need to add a few more names to List2 but keep the same amount of names in List1, how would I adjust the formula to do that?

 

[Cubist]

If you add more people in List2, what's the maximum number of times List1 can be repeated? It is no longer 2.

 

[MangoButter]

If you add more people in List2, what's the maximum number of times List1 can be repeated? It is no longer 2.

I think the max number of repeating would be 3. So example would be if I have 6 names in List1 and 14 names in List2?s

 

[Cubist]

Try this:

Book2
	A	B	C
1	List1	List2	Pairing
2	Emma	Sophia	Ava
3	Lucas	Ethan	Mason
4	Ava	Isabella	Lucas
5	Mason	James	Ava
6	Olivia	Mia	Olivia
7	Liam	Noah	Lucas
8		Harper	Emma
9		Benjamin	Ava
10		Amelia	Emma
11		Alexander	Mason
12		Grace	Olivia
13		Samuel	Mason
14		Jordan	Lucas
15		Lance	Emma
Sheet3

Cell Formulas
Range	Formula
C2:C15	C2	=LET(a,A2:A7,r,ROWS(B2:B15),INDEX(a,SORTBY(INT(SEQUENCE(r,,,1/ROUNDUP(r/ROWS(a),0))),RANDARRAY(r))))
Dynamic array formulas.

 

[MangoButter]

Thank you!