2. Enter =RAND () in the grid outside the area, such as G 1, and then drop down 25 lines.
3. Enter = rank (G 1, $ G $ 1: $ G $25) in the required area, such as A 1: E5.
In which G 1 is replaced by G2, G3 and G25, respectively.
Description: Each click will change the contents of the cell. ...
There is almost no possibility of making mistakes. If you are not at ease, you can add a verification cell and enter the following:
=IF(SUM(A 1:E5)=325, "The table is correct", "If there is any error, click to regenerate").