On Jul 22, 11:57*am, Erika wrote:
I have my 30 students listed in a spreadsheet, I would like to find a
way in excel that I can set up a formula that will randomly pair them
up in groups of 2. *I have them listed like the example below
1 *Person A
2 *Person B
3 *Person C
etc.

Put =RAND() into a column of 30 cells starting in row 2, e.g. Z2:Z31.

Note: If you do not want your random selection changing everytime you
modify any(!) cell in the worksheet, copy-and-paste-special-value
Z2:Z31 into another range, e.g. Y2:Y31, and substitute "Y" for "Z"
below. (Or you could copy-and-paste-special-value Z2:Z31 over Z2:Z31
if this a one-time thing.)

Suppose your list above is in A1:A30, and you want your pairwise list
in B1:C1 through B15:C15. Enter the following formulas into B1 and C1
and copy down through B15 and C15:

B1: =INDEX($A$1:$A$30,RANK(OFFSET($Z$1,2*ROW(B1)-1,0),$Z$2:$Z$31))
C1: =INDEX($A$1:$A$30,RANK(OFFSET($Z$1,2*ROW(B1),0),$Z $2:$Z$31))