In LibreOffice Calc how do I choose a random cell excluding cells with specified text?

In a LibreOffice Calc I am trying to retrieve the value from a random cell within a group of cells, some of those cells *may* contain the word "None", I don't want any of those chosen when the random cell is chosen...example: |Input|Output| |----:|:-----| |Maybe|Time| |Time|Time| |Wants|Maybe| |None|Wants| |Of|Tell| |My|My| |Effort|Time| |None|Can| |Can|My| |Tell|Effort| However, the only randomization methods I've been able to figure out for myself do full randomization, example: |Input|Output| |----:|:-----| |Maybe|None| |Time|Time| |Wants|Maybe| |None|Wants| |Of|None| |My|My| |Effort|Time| |None|Can| |Can|None| |Tell|Effort|