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

With Microaoft-365, give a try to-

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

Answer 2

How about:

=@SORTBY(B2:B5,A2:A5-RANDARRAY(ROWS(B2:B5)))

If it's possible that A2:A5 doesn't comprise a single FALSE entry, as per the comments from @Domenic:

=IF(AND(A2:A5),"",@SORTBY(B2:B5,A2:A5-RANDARRAY(ROWS(B2:B5))))