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 considered are not empty?

  • Please describe what the formula does, include sample input/output data, choose one web app , add a brief description of your search/research efforts as is suggested in How to Ask. – Rubén Nov 8 '19 at 20:19

As far as I know, you can't. You should have an auxiliary column with all values, no blanks, and run it over it.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.