I have a list of names in col A.
What I want to do is find a quick and dirty way to create a random list
of pairs (different each time I do it).
Example
Jack
Joe
Sally
Sue
Paul
John
Ringo
Earl
The desired result would be written to col B (or perhaps to B and C if
that's easier) and would be something like
Earl, Sally
Paul, Ringo
Sue, Jack
John, Joe
The next time I do it, the result might be
Sally, Sue
Paul, Joe
John, Ringo
Earl, Jack.
Thanks.