# Excel Sales Forecasting for Dummies, Wiley, 2005

Document Sample

```					                              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

• Date: Fri, 23 Sep 2005 07:18:30 GMT

Hi Maureen,

−−
C^2

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!!!
>
>
> > 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
>>
> > Excel Sales Forecasting for Dummies, Wiley, 2005
>>
>>
> > "mnpremo" <mnpremo@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> > > 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?

• 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