Microsoft Office Tutorials and References
In Depth Information
Choosing a Random Item from a List
The capital letter Ais also known as character 65 in the ASCII character
set. Bis 66, Cis 67, and so on up through Z, which is character 90. You can
use =CHAR(RANDBETWEEN(65,90)) to generate random capital letters.
Many
of
the
product
SKUs
in
this
book
were
generated
using
=CHAR(RANDBETWEEN(65,90))&RANDBETWEEN(101,199).
Figure 11.21 shows many examples of RANDBETWEEN.
Figure 11.21.
Figure 11.21. RANDBETWEEN
RANDBETWEEN can generate integers and with a little cre-
can generate integers and with a little cre-
ativity, even prices or letters.
ativity, even prices or letters.
Choosing a Random Item from a List
In Figure 11.22 , you want to randomly assign employees to certain projects.
The list of projects is in column A. The list of employees is in E2:E6. As
shown
in
Figure
11.22 ,
the
function
for
B2:B11
is
=INDEX($E$2:$E$6,RANDBETWEEN(1,5)).
 
Search JabSto ::




Custom Search