| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I sum up random cells | Excel Worksheet Functions | |||
| How to select other random cells | Excel Worksheet Functions | |||
| #Value in random cells | Excel Worksheet Functions | |||
| how to identify unique list of 200 random entries from a list of 3 | Excel Worksheet Functions | |||
| Random select entries | Excel Discussion (Misc queries) | |||
Threaded Mode
