How does EXCEL randomly select three names from 20 names containing itself, and these three names cannot contain themselves and repetition.

If there are 20 names in cell A 1:A20, enter =RAND () in cell B 1:B20. Press Ctrl+Enter to end;

Enter the following formula in the target cell, and then fill the formula down.

=INDEX(A:A，MATCH(LARGE(B:B，ROW(A 1))，B:B，0))