Random Selection－software｜痞客邦

Mar 09 Fri 2007 20:36
Random Selection

close

How do I randomly select say 6 names from an 18 word list from excel?

Put the names in a column (say from A1 thru A18) in B1 thru B18 enter:

=RAND()

Sort the data by column B. This shuffles the names in column A. Just pick
the top six. To get another sample just re-sort and pick the top six again.
--
Gary's Studentquot;Cookiequot; wrote:

gt; How do I randomly select say 6 names from an 18 word list from excel?

Take a look he

mcgimpsey.com/excel/udfs/samplenoreplace.html

In article gt;,
Cookie gt; wrote:

gt; How do I randomly select say 6 names from an 18 word list from excel?

software

software

software 發表在痞客邦留言(0) 人氣()

E-mail轉寄

全站分類：不設分類
個人分類：title
此分類上一篇： Ecel Filtering Currency Formatted to AED
此分類下一篇： multiply a row of numbers by %
上一篇： Q: Can a formula reference a cell to get the file name to link to for data?
下一篇： Calculating value across multiple worksheets

歷史上的今天

2007: Row height/column width
2007: excel quot;Networkdayquot; function
2007: Group amp; Stacked Chart
2007: Data Validation
2007: Creating ODBC link within SELECT statement
2007: Excel recalculates on startup?
2007: new copy of spreadsheet using old spreadsheet info.
2007: How do I count letters and numbers in a formula?
2007: update cells to today date in a list of dates
2007: exel conditional formula,calculate a bilateral tolerance(.2/-.2)?
2007: Counting Cell with Quotation
2007: Protection of identical cells on multiple worksheets
2007: How do I which file in collection is being used in the calculation
2007: getpivotdata function
2007: Sum up a particlar cell in multiple Excel worksheets within same b
2007: References to Blank Cells turn into Zeros
2007: How do I delete lt;brgt; or lt;bgt; that appears in text?
2007: how do i copy just the data and not the formula in a cell?
2007: Conditional Formatting I can't seem to figure out......
2007: Can I filter cells by color?
2007: IF formula for 13 plus variables
2007: Option Box Run Time Error Cell Locked
2007: How to feed the contents of a cell as row index?
2007: Linking Large Access Table into Excel
2007: Remove the quot;Falsequot; from Statement
2007: MRound
2007: countif, sumif, sumproduct
2007: hiding content when there is a #REF in a cell
2007: How do I change the format/cell/border/automatic color to black
2007: How do I get multiple matches when using the Vlookup function?
2007: What does the second parameter in ACCRINT do?
2007: HOW DO I USE EXCEL FOR QUALITY CONTROL CHART SUCH AS TEMPERATURE .
2007: Summing a range with conditions
2007: How do I create a running total (balance) in a pivot table?
2007: Convert Seconds and decimals to time
2007: Labels responsive to cell values
2007: Strange problem....excel not responding
2007: Autosum refreshing
2007: Polynomial equations
2007: Data Valitaion Input message
2007: getting combinations
2007: How do I combine 2 COUNTIF formulas??
2007: vlookup question
2007: Adding or combining time problem.
2007: HELP
2007: not copying correct value
2007: Excel Formulas
2007: headers on excell worksheets
2007: Excel formula to increment the month by 2?
2007: Automatic extend row in workshet.
2007: Split a Value
2007: Advanced Filter Question
2007: Combining LEFT\IF and Concatenation
2007: size limitations on auto filter
2007: Forms controls
2007: How do I keep Excel in manual calcuation?
2007: Scheduler and passwords
2007: How can I seperate the demensions from the description?
2007: Adding relevant sheets
2007: Copy/Paste Rows that Contain Specific Text
2007: 1-9 not as a date
2007: How can I lookup a cell that's to the left?
2007: when I enter an amount in the A column move the row to another she
2007: Legend Modification
2007: delete a check box
2007: Damaged software
2007: The Formula is Too Long
2007: Data Entry Form and List
2007: Excel Help Needed......
2007: extract year from the date in a cell
2007: Depriciation Matrix
2007: VLOOKUP
2007: How do I create template fields?
2007: In Excel, how do I make the same changes to different values?
2007: Inserting Picture in protected sheet
2007: printing worksheet on 3x5 card
2007: Matching List Entries
2007: Normal distribution test in excel?
2007: Excel showing a row of ##### in stead of dollars, but when
2007: Help finding and summing across worksheets
2007: How do I insert an excel spreadsheet in Word?
2007: sequential numbers
2007: auto format help
2007: =bahttext(A1) please tell me about language in english how can i
2007: how do I calculate the time service minus holidays?
2007: Vlookup always gives me #NA
2007: nonadjacent selections
2007: How do I create an quot;outline summaryquot;
2007: how to compute a range of cells based on another range of cells?
2007: Iteration
2007: Formatting Question
2007: Workbook_Open() Event
2007: Can I set up a newsletter style column in Excel?
2007: sum stopped calculating
2007: Find amp; Copy Data query
2007: PRINTING
2007: DAVERAGE criteria HELP!!!!
2007: Large integers in excel 2003 are rounded ?? Is this a BUG ?
2007: Data Broadcasting in Excel
2007: row that needs to wait till the next page break befor copying

留言列表

站方公告

活動快報

newdirect

看更多活動好康

我的好友

熱門文章

文章分類

最新文章

最新留言

動態訂閱

文章精選

所有文章列表

文章搜尋

新聞交換(RSS)

誰來我家

參觀人氣

本日人氣：
累積人氣：

QR Code

qrcode

POWERED BY

(登入)