software

Hi,

I am looking to find a function that can assign a set of random values
to a column. For example if I have a list of names I want the
spreadsheet to be able to churn out a random value for the following
list,

3a 3b 3c 4a 4b 4c 5a 5b 5c

Name Random Value
M. Hardy 4a
G. Dodd 5b
B, Smith 3b

The list needs to be able to be customized right up to 7a to allow for
future expansion.

Many thanks in advance,

Marie--
Marie1uk
------------------------------------------------------------------------
Marie1uk's Profile: www.excelforum.com/member.php...oamp;userid=20984
View this thread: www.excelforum.com/showthread...hreadid=503643Look in help for the function RAND(), in help for RAND there is also an
example of getting integers between certain values, you can use that then
use that integer together with INDEX, put the values you want to assign in a
range and lookup them, if non repeating values see:

www.mcgimpsey.com/excel/udfs/randint.html

--
Regards,

Peo Sjoblom

Portland, Oregon

quot;Marie1ukquot; gt; wrote in
message ...
gt;
gt; Hi,
gt;
gt; I am looking to find a function that can assign a set of random values
gt; to a column. For example if I have a list of names I want the
gt; spreadsheet to be able to churn out a random value for the following
gt; list,
gt;
gt; 3a 3b 3c 4a 4b 4c 5a 5b 5c
gt;
gt; Name Random Value
gt; M. Hardy 4a
gt; G. Dodd 5b
gt; B, Smith 3b
gt;
gt; The list needs to be able to be customized right up to 7a to allow for
gt; future expansion.
gt;
gt; Many thanks in advance,
gt;
gt; Marie
gt;
gt;
gt; --
gt; Marie1uk
gt; ------------------------------------------------------------------------
gt; Marie1uk's Profile:
gt; www.excelforum.com/member.php...oamp;userid=20984
gt; View this thread: www.excelforum.com/showthread...hreadid=503643
gt;=TRUNC(RAND()*3 3)amp; CHAR(TRUNC(RAND()*3 97))then drag fill down the column.

--
Regards,
Tom Ogilvy

quot;Marie1ukquot; gt; wrote in
message ...
gt;
gt; Hi,
gt;
gt; I am looking to find a function that can assign a set of random values
gt; to a column. For example if I have a list of names I want the
gt; spreadsheet to be able to churn out a random value for the following
gt; list,
gt;
gt; 3a 3b 3c 4a 4b 4c 5a 5b 5c
gt;
gt; Name Random Value
gt; M. Hardy 4a
gt; G. Dodd 5b
gt; B, Smith 3b
gt;
gt; The list needs to be able to be customized right up to 7a to allow for
gt; future expansion.
gt;
gt; Many thanks in advance,
gt;
gt; Marie
gt;
gt;
gt; --
gt; Marie1uk
gt; ------------------------------------------------------------------------
gt; Marie1uk's Profile:
www.excelforum.com/member.php...oamp;userid=20984
gt; View this thread: www.excelforum.com/showthread...hreadid=503643
gt;

Thanks Tom,

What values determine the minimum amp; maximum numbers (range), eg if I
wanted it to only go from 3a to say 5a instead of 7 for some cells?--
Marie1uk
------------------------------------------------------------------------
Marie1uk's Profile: www.excelforum.com/member.php...oamp;userid=20984
View this thread: www.excelforum.com/showthread...hreadid=503643
Any advice as to how I can tweak the range would be appreciated.

Thanks--
Marie1uk
------------------------------------------------------------------------
Marie1uk's Profile: www.excelforum.com/member.php...oamp;userid=20984
View this thread: www.excelforum.com/showthread...hreadid=503643