vendredi 3 juin 2022

How can I adjust this spreadsheet formula to take a random *non-blank* value from the specified range?

I am trying to achieve a certain unusual result using Google Sheets and here's what I've got so far.

My formula takes the value of a randomly selected cell within the named range "IntroLines":

=INDEX(IntroLines,RANDBETWEEN(1,ROWS(IntroLines)),1)

The only problem with it is that some of the cells in that named range are blank and I would like NOT to select those cells. Any ideas how I could update this formula to enforce that a non-blank value is selected?

Note: I would strongly prefer to solve this problem without removing blank cells from the named range.




Aucun commentaire:

Enregistrer un commentaire