Pull random cell on column B if column C is empty

I'm pulling a random data from Column B but how would I only pull the ones that has a empty data in Column C?

Here's the code:

=INDEX($B:$B,RANDBETWEEN(1,COUNTA($B:$B)),1)

Originally Posted by curb

I'm pulling a random data from Column B but how would I only pull the ones that has a empty data in Column C?

Here's the code:

=INDEX($B:$B,RANDBETWEEN(1,COUNTA($B:$B)),1)

Does

Please Login or Register  to view this content.

work? I don't appear to have RandBetween functionality on my Mac.