Enter random number once per row/column range

[reddwarf]

Hi,
I need to randomly place the number number 1 in range E3 to I3, and then replicate down about 10000 rows (I am creating a test data), but it must only occur once in every row & column.

For example:

Row E F G H I
3 1
4 1
5 1
6 1
7 1
8 1 1

Is it possible to factor in a weighting to the placement of the '1', i.e. ColE will have most likelihood and ColI will have least likelihood?

Stumped on this - if someone could help it could save me hours of work.

Thanks

[reddwarf]

Forget this - figured out another method