Excel Tips

In LibreOffice Calc to get a random cell between cells B3 and B9 of Sheet1 you can do:

=INDEX(Sheet1.B3:B9, RANDBETWEEN(1,5))

As the following screenshot shows, you have a range of data from A1 to A15, the Rand and Index formula can help you display the random cells in a new column. Please do as follows:

1. In the adjacent cell such as B1, enter the formula =RAND(), and press the Enter key, then copy the formula to the cell B15. And the random values will be filled with the cells. See screenshot:

2. Then in the next cell over, in this case cell C1, enter the formula =INDEX($A$1:$A$15,RANK(B1,$B$1:$B$15)).

3. Then press Enter key, and select the cell C1, drag the fill handle to cover as many cells as desired selections. And random 5 cells of range A1:A15 have been displayed in the column C. See screenshot: