View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
gareth gareth is offline
external usenet poster
 
Posts: 37
Default 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