Choosing a random text value from a list

Question

I have an Excel spreadsheet like this:

Checkbox	Value
FALSE	Value1
TRUE	Value2
TRUE	Value3
FALSE	Value4

I want to create a list with FALSE values and choose a random text value from that list. For choosing random text value I tried using CHOOSE(RANDBETWEEN()) I tried to use IF(NOT(Checkbox), Value, "") but it gives empty cells, and I do not want that.

Answer 1

Try this:

=CHOOSEROWS(FILTER(B2:B100,A2:A100=FALSE),RANDBETWEEN(1,COUNTIFS(A2:A100,FALSE)))