Excel Sales Forecasting for Dummies, Wiley, 2005

							                              Re: Random Selection of items in Excel?

Re: Random Selection of items in Excel?

Source: http://www.tech−archive.net/Archive/Excel/microsoft.public.excel.misc/2005−09/msg03469.html



      • From: "Conrad Carlberg" <carlbergc@xxxxxxxxxxxxx>
      • Date: Fri, 23 Sep 2005 07:18:30 GMT

Hi Maureen,

Glad to hear it.
−−
C^2
Conrad Carlberg

Excel Sales Forecasting for Dummies, Wiley, 2005


"mnpremo" <mnpremo@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:00AC25A5−BD8D−4BCD−AE4E−28D54D1188DD@xxxxxxxxxxxxxxxx
> I just got it to work − Just what I was looking for. THANKS!!!
>
> "Conrad Carlberg" wrote:
>
> > Hi Maureen,
>>
> > I've always found that the simplest way is to select as many adjacent
cells
> > in column B as you have numbers in column A. With those column B cells
> > selected, enter this formula:
>>
> > =RAND()
>>
> > and hold down CTRL as you press Enter. This will enter pseudo−random
numbers
> > in column B, one for each value in column A. At this point, it usually
makes
> > sense to convert your =RAND() formulas to values. Select them, choose
Edit |
> > Copy,. then choose Edit | Paste Special, click the Values option, and
click
> > OK. (There's also a keyboard shortcut to do this, but it's not a big
> > timesaver.)
>>
> > Now, suppose that your existing numbers are in cells A1:A495. If you've
put
> > random values in B1:B495, select A1:B495 and sort (either ascending or


Re: Random Selection of items in Excel?                                                               1
                             Re: Random Selection of items in Excel?
> > descending) on column B. This will give you a random ordering of the
numbers
> > in column A. If you want a randomly selected set of column A values,
just
> > select A1:A5.
>>
> > −−
> > C^2
> > Conrad Carlberg
>>
> > Excel Sales Forecasting for Dummies, Wiley, 2005
>>
>>
> > "mnpremo" <mnpremo@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> > news:FC103B44−62B0−4FAD−99F8−ABB527C21785@xxxxxxxxxxxxxxxx
> > > I'm creating an Excel spreadsheet that has several hundred numbers
listed
> > (in
> > > no particular order) in the first column. The numbers are all in this
> > > format: 000.00.00.00
>>>
> > > I was wondering if Excel has the ability to go through and select
several
> > of
> > > these numbers randomly from the column so that I can then have a
random
> > > sample from my list of hundreds of numbers.
>>>
> > > Thank you−
> > > Maureen
>>
>>
>>


.



     • References:
            ♦ Re: Random Selection of items in Excel?
                   ◊ From: Conrad Carlberg

     • Prev by Date: Quick Excel formula question before I go on holiday tomorrow!
     • Next by Date: Re: Quick Excel formula question before I go on holiday tomorrow!
     • Previous by thread: Re: Random Selection of items in Excel?
     • Next by thread: Re: This is probably simple to fix
     • Index(es):
            ♦ Date
            ♦ Thread


Re: Random Selection of items in Excel?                                                  2