I want to randomise the 157 entries in randomised complete block design using MS Excel
S Sabar May 13, 2009 #1 I want to randomise the 157 entries in randomised complete block design using MS Excel
D Dave Peterson May 13, 2009 #2 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.
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.
