Re: Sample
Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance
Another option...
insert a helper column
put =rand() in the top row
and drag down the column.
Sort your data by that column and copy the first 250 in the sorted list.
You could use another column and put
1 (in the top row)
2 (in the second row)
And drag down that column.
If you need to resort to get it back to the original order, sort by that other
helper column.
David wrote:
>
> I have a list of 2730 numbers in a worksheet, used Sampling in the Tool menu
> area, my question is that it picks some of the numbers twice and puts that as
> a part of the sample. I need a output of 250, I get the 250, but with some
> duplications. Any help you can provide would be greatly appreciated.
--
Dave Peterson
.
Relevant Pages
- Re: Excel Question: How to Delete All Blank Rows from a worksheet?
... Put =rowin the first row and drag down. ... Sort your data to get those blanks together. ... Use that helper column to put things back in the same order that you started. ...
(microsoft.public.excel.misc) - Re: identify similar cell values
... I'd insert a helper column and put =rowin B1 and drag down. ... Then sort by your real column. ... > cells have the same value, I would like to identify those cells. ...
(microsoft.public.excel.misc) - Re: How do I randomly sort data in a column?
... goody, you could use a helper column put =RAND() in a column next to your ... fill down to the end of your data and then sort on that column ...
(microsoft.public.excel.misc) - Re: Generating unique random number
... The simplest way, especially if you only need to do it once, is to use a helper column. ... enter =RAND() and copy down. ... Choose Data> Sort to sort the two columns. ...
(microsoft.public.mac.office.excel) - Re: How do I filter names using only the first letter?
... >Try using a helper column, If your data were in column A, in column B enter ... >and drag down to the end of your data list in column A, ... >>I am trying to filter a list of names using only the first letter. ... Did he mean sort? ...
(microsoft.public.excel.worksheet.functions) |
|
