how to randomise the treatments in trial layout
 

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

how to randomise the treatments in trial layout
 

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