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.
I would like the result of the formula to random pair up the students.