Generating random names from a list without repeats

I trying to make a row of XLOOPUP formulas in a row that are all the same but as you move right along the row, the value of the one to the left is removed.

For example: I have a list of 10 names and i want five XLOOKUP formulas to give five different names without repeat. So if the first formula comes up as Charlie, I don't want any of the other formulas to come up as Charlie

Using Microsoft Office 365 home.