entries into random cells
I have a sheet with approx 7,000 rows of data. Column A
has the value 1, 2 or 3 sorted into ascending order.
I want to enter "R" in column D for 10% of the records
with 2 or 3 in column A.
If possible I would like this selection to be random (i.e.
not just pick one in ten) so that if I were to run the
macro twice I wouldn't get the same results.
Thanks in advance.
Gareth
|