Repeat formula until is not Zero`

[darkybot]

H i everyone, I'm a noob regarding excel and I have a question for you more advance users that maybe you can help me out:

I created this as a test buy in which articles will constantly change every time the document is open, or they press F9. To do this, the following formula is in "Random" sheet in A# column:

=INDEX(Some!A2:A18,RANDBETWEEN(1,ROWS(Some!A2:A18)),1)

It gathers info from "Some" sheet, and it works well. Now what I want is to avoid showing articles with stock zero, and this is the part that I don't know how to do it.

Any help, I appreciate it!

Thanks.

 

[Fluff]

As this is now a totally different question, you need to start a new thread. Thanks

 

[darkybot]

Hi @Fluff, the last part of this post was locations, so I'm asking something that can be easily replied here since is part of the same original post, creating new ones each time something is asked I see it as such a waste of forum space. (I created a new one to comply, just wanted to give you my feedback regarding that)
Following this post: How can I show all locations without repeating it, and is there a way to sort this array by location from smallest to biggest?

Thanks!

 

[Fluff]

Thanks for starting a new thread.