Geek asks and answers

How can I get a random cell in OpenOffice Calc?

I was browsing through the list of Stack Exchange sites, and I can only think that SO is the right place to ask about it (at least I saw a few questions with Excel).

I have an array of values Sheet1.B3:B9. On another sheet, I am trying to get a random value from one of these cells.

I suppose it should be something with a function RANK(), but I grab onto a straw.

How can I get the value of a random cell in this range?

+3
source share
2 answers

In Excel, this will give a random search in the range

=INDEX(Sheet1!$B$3:$B$9,INT(RAND()*7)+1)

Or you can specify a range of source name data

=INDEX(RandDataSource,INT(RAND()*ROWS(RandDataSource))+1)

I don't know if this applies to Openoffice

+3

LibreOffice Calc B3 B9 Sheet1 :

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

More articles:


All Articles