Randomizer skip empty cells

Hi there!

I'm new on this forum and I got a question. I made a randomizer and I would like to know how to skip empty cells. Right now, if a empty cell is selected it will result in a 0. In this case I would like to skip this cell and go on to the next till the randomizer finds a cell with a value. My formula right now is:

=INDEX($A$2:$A$1000;RANDBETWEEN(1;1000))

For some reason I can't upload a document..... -> uploaded an example

Thanks in advance