PowerUp Description
The pwrRANDFROMRANGE PowerUp function returns the value in a randomly selected cell from the range provided.
PowerUp Syntax
pwrRANDFROMRANGE(range)
The pwrRANDFROMRANGE PowerUp function has the following arguments:
range– Required. This is the range of cells from which to select the random cell.
Return Value
pwrRANDFROMRANGE will return the value from one of the cells in the range.
Remarks
The range may have multiple rows and columns. In other words, it can be two dimensional.
Example
=pwrRANDFROMRANGE(A1:Z20)