Microsoft Office Tutorials and References
In Depth Information
Using RAND and RANDBETWEEN to Generate Random Numbers and Data
Figure 11.19.
Figure 11.19. The
The SUBTOTAL
SUBTOTAL function in cell E2 ignores rows hidden as the
function in cell E2 ignores rows hidden as the
result of a filter.
result of a filter.
Note
Although the function in Figure 11.19 uses the function number 109, the
Subtotal command always ignores rows hidden as the result of a fil-
ter. =SUBTOTAL(9,E5:E5090) would return an identical result when the
rows are hidden through a filter, as in this case. If you have rows
hidden by the Hide command, you should use 109 to ignore the manually
hidden rows.
Using
Using RAND
to Generate Random Numbers and Data
In a number of situations, you might want to generate random numbers. Excel
offers two functions to assist with this process: RAND and RANDBETWEEN.
RAND and
and RANDBETWEEN
RANDBETWEEN to Generate Random Numbers and Data
Syntax
=RAND()
The RAND function returns an evenly distributed random number greater than
or equal to 0 and less than 1. A new random number is returned every time the
worksheet is calculated.
Search JabSto ::

Custom Search