|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
September 22nd, 2008, 10:49 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Random Sample
I have a list of data in excel. Is there anyway that excel can pick a randam
sample of say 20 entries? 
|
|
#2
September 22nd, 2008, 11:07 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Random Sample
Say the data is in column A from A1 thru A1000.
In B1 thru B1000 enter: =RAND() Sort cols A&B by B. This will "shuffle" the items in column A. Just pick the top 20 items in col A. Re-sort to get another sample. -- Gary''s Student - gsnu200805 "Funkyfido" wrote: I have a list of data in excel. Is there anyway that excel can pick a randam sample of say 20 entries?
|
|
#3
September 22nd, 2008, 11:09 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Random Sample
Hi,
Say your data are in colimn A put this in b1 and double click the fill handle to make it fill down:- =Rand() Now select Columns A & B and sort on column B. The top 20 elements in column A are randomely selected from the list. Tap F9 and re-sort for another 20. Mike "Funkyfido" wrote: I have a list of data in excel. Is there anyway that excel can pick a randam sample of say 20 entries?
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
