| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to identify unique list of 200 random entries from a list of 3
How do I get a list of 200 unique random entries from a list of 3100 unique
entries? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to identify unique list of 200 random entries from a list of 3
In a helper column next to your entries, enter =Rand() and fill down. Then
sort by the random column and take the top 200. HTH Regards, Howard "tjb" wrote in message ... How do I get a list of 200 unique random entries from a list of 3100 unique entries? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to identify unique list of 200 random entries from a list of 3
the simplest way is to use a helper column next to the data set, enter =rand()
and paste to the bottom of the data. you can either sort the two columns beased on the helper column and use just the top 200 values "tjb" wrote: How do I get a list of 200 unique random entries from a list of 3100 unique entries? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to identify unique list of 200 random entries from a list of 3
Hello,
I suggest to use my UDF UniqRandInt: http://www.sulprobil.com/html/uniqrandint.html Regards, Bernd |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Identify & List unique values from a list using functions/formulas | Excel Worksheet Functions | |||
| Unique list of entries | Excel Worksheet Functions | |||
| Best way to get a list of unique entries in a field | Excel Worksheet Functions | |||
| counting unique entries in a list | Excel Discussion (Misc queries) | |||
| How to identify entries in a matrix also present in another list | Excel Worksheet Functions | |||
Linear Mode
