Maybe you could insert a new column.

Fill the first cell with a formula like:
=rand()
then copy down as far as you need.

Then select the entire range and sort by this helper column.

Then you can hide or delete this helper column.

Sabar wrote:

I want to randomise the 157 entries in randomised complete block design using
MS Excel

--

Dave Peterson