Need Match(RAND() to ignore empty cells.

Hi there!

I have a sheet going that has the following cells:


Screenshot_9.jpg

Now the idea behind it is that you'll be able to enter the S&D Coat Markings, assign them a percentage and when you reload, the top excel box will display randomly pulled coat markings based on their percentage (or possibility) of happening.

I got it pulling the random markings, no problem, by using this:

=INDEX($Q$115:$Q$120,MATCH(RAND(),$S$115:$S$120))

However, not all the boxes need to be used all the time. But, when you don't have something in all the boxes, this happens:

Screenshot_10.jpg

It's including the blank boxes- even when I set their value at 0.00%???

How do I make it skip those empty boxes, so it only draws information from the ones with text inside of them?

Thank you in advance!

I figured it out! :D

The reason it was counting these cells was because it was counting it as if it had text in it. I cleared the cells completely and copy/pasted the info I needed into the appropriate side instead of typing it and it's working like a charm! :D