Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
I use this function to find a random content of a cell:
=index(A3:A100, randbetween(1, counta(A3:A100) ) )
Some of the cells in A are empty. How can I change this function, so that only those cells are considered, that are not empty?
As far as I know, you can't. You should have an auxiliary column with all values, no blanks, and run it over it.
Required, but never shown