| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
what can I do to randomly select cells that contain text?
I have a spreadsheet of text cells ... I wish to randomly select a specified
number of cells from a specified column ... what must I do to accomplish that random selection? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
what can I do to randomly select cells that contain text?
assuming column A is your specified column:
=INDIRECT("A"&ROUND(RAND()*500+1,0) This assumes you have 500 cells with values in them. Copy and paste this formula the specified number of times, and you will get the values in those random cells. Every time you edit any cell, the values will change. "gmadden2" wrote: I have a spreadsheet of text cells ... I wish to randomly select a specified number of cells from a specified column ... what must I do to accomplish that random selection? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
what can I do to randomly select cells that contain text?
Including duplicates, which may not be desirable.
If your text values are in A1:A100, put =RAND() in B1:B100 and then in C1:C100 put the following: =INDEX($A$1:$A$100,RANK(B1,$B$1:$B$100)) Copy the number of values desired from column C. Sean Timmons wrote: assuming column A is your specified column: =INDIRECT("A"&ROUND(RAND()*500+1,0) This assumes you have 500 cells with values in them. Copy and paste this formula the specified number of times, and you will get the values in those random cells. Every time you edit any cell, the values will change. "gmadden2" wrote: I have a spreadsheet of text cells ... I wish to randomly select a specified number of cells from a specified column ... what must I do to accomplish that random selection? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Randomly populating empty cells with other text cells | Excel Discussion (Misc queries) | |||
| does ctrl f select cells randomly? | Excel Discussion (Misc queries) | |||
| Randomly Select Records | Excel Worksheet Functions | |||
| how to randomly select a name in a list and then the select the ne | Excel Worksheet Functions | |||
| randomly select value WITHOUT changing | Excel Worksheet Functions | |||
Linear Mode
