Only two values (numbers) for 150 random cells in a column of 300 cells

[andrugrasu]

It's strange, but I want to populate 150 cells with values 0 and 1 at random from a column of 300 cells. Is it possible?

[Marcol]

You could try this

Please Login or Register  to view this content.

Drag/Fill Down through your range.

Copy and paste special > Values if you need to keep the result permanently.

Hope this helps

[andrugrasu]

Thanks Marcol. It works perfectly.